Recent Posts

Pages: [1] 2 3 ... 10
2
Post-installation Setup and Configuration / KCFinder configuration
« Last post by ehendricks on Today at 01:10:26 pm »
Drupal 7, CiviCRM 4.3.8 (though I've seen this with 4.4.6 as well)

Both the KCFinder configured image uploadURL and uploadDir are correct (sites/default/files) and this is the directory used by Drupal.  However, when open KCFinder via Civi the path has "/images" appended to it.

I have googled, searched for a setting and looked at the code without any luck.  Any help would be very much appreciated.
3
Indeed, I found now article saying about it:
https://www.drupal.org/node/1825018

I am digging in the Internet for the answer how to change it but unfortunately I can't find working solution.
I cannot disable binary logging if I am not SUPER user.
Code: [Select]
PURGE BINARY LOGS BEFORE '2014-09-03 09:00:00';
So the only option is to change priviledges to SUPER user.
GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';

but this sql is not working for me.

any clue?
4
was writing this while Coleman was adding his - am pasting without censoring myself

You can keep using Webforms - which is how we would most likely approach this.

If just using the option in webforms to load the spouse/child isn't specific enough then you could use a View to put a block somewhere, and use links of each of their family members to add their id as cid2=xxx on the webform so it prefills with eg ChildA's data.

Registering for Events can also be done via Webform but will depend on your payment set up.

Primary Contact can also access their dashboard and via that edit the Name/Address type details of their family members.

It may be possible to use a Drupal block approach and have links that put the id for kids on to a civi event rego page but not sure about that.

Hope the above gives you something to work on
5
1) Make sure the relationships created by the webform are "permissioned".
2) Install this extension: https://civicrm.org/extensions/relationship-permissions-acls
3) Give each of the related contacts on the webform an "Existing Contact" field. Configure that field to set "default value" based on the appropriate relationship to contact 1.
6
Here's the setup: I have a webform which, through a combination of Webform Civicrm and Rules, creates multiple contacts. The primary user, a second parent, and a child. It creates the parent-child relationships between them, and also creates a household with the relationship of "is a household member of" for the contacts involved. The primary user then becomes a linked Drupal user account.

All of this is perhaps ancillary to the question, which is as follows:
How do I allow the Drupal user (first parent, the one who filled out the form) to view and edit the related contacts in civicrm? I'm not sure whether to use profiles, or how this should work exactly. Ideally, the parent would then be able to, say, sign up the child for an event, and change the child's information if it had gotten out of date.
7
It's a sql permission issue, due to the fact that your server is running an outdated version of mySQL. You could solve it by upgrading mySQL or else give your user SUPER privileges.
8
The problem is not fixed in the newest version 4.4.6.
I am troubling with the error if I have Phone field in the registration form for Event.

I tried solution with inserting 3 lines in the php file (administrator folder in Joomla: admin.civicrm.php). It's not working for me.
I tried with MySQL query but with no success.
I tried with the link .../civicrm/menu/rebuild?reset=1&triggerRebuild=1.

None of these solutions worked for me.

[EDIT]
I enabled debuggin:
Code: [Select]
Database Error Code: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), 1419
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
    CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
    [type] => DB_Error
    [user_info] =>
    CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]"]
)


Any solution for that please?
9
Using Core CiviCRM Functions / Re: Making full use of Tags
« Last post by eWareness on Today at 11:21:53 am »
I will try to explain the difficulty. We can import a contact to a single group(mailing list). The solution provided above does not address our prime issue.

The issue at hand is the requirement to accept zero-eight checkbox topics, and enter the contact into the correct mailing groups they select.

In other words, I want someone on my website to provide Name, email, and select any to all topics they are interested in, and then import that data into a group created for each topic.
10
Never a bad idea to open a new well written bug report about an identfiied issue, IMO.

Does not guaruntee a fix, but good to have it out there.
Pages: [1] 2 3 ... 10