Recent Posts

1

Internationalization and Localization / Search critieria missing when writing to cache

« Last post by eggtart on Today at 11:28:00 pm »

I have a multilingual site with Chinese/English.

While displaying in Chinese, I try to do an advanced contact search based on, say membership type, and will get 500 records back.  When I select all the records and choose mailing labels, it will say 1000 records selected (all the contacts in my db).  This will not happen if I choose to do everything in English.

Apparently, both the search criteria and the search results are stored in civicrm_cache based on the qfkey.  When I look them up in the DB, I found that everything is fine with the English search.  I see the member_membership_type_id in queryParams.  But when I look at the cache entry for the Chinese search, I cannot find anything about member_membership_type_id.  There is nothing after queryParams.  This happens to all the multilingual fields (e.g. membership type, membership status, etc).  Somehow, all these fields are gone with writing to the cache when we are using Civicrm in non-English mode.

Any help would be greatly appreciated.


Thanks!

2

Using CiviEvent / Re: Custom Standalone Screen for Event

« Last post by xavier on Today at 11:17:04 pm »

Hi,

I'm not sure I understood why you need to display the get like that (I'm assuming it's a proof of concept), but never display a GET (or any user provided data) without filtering it first. It'd be trivial to abuse and use to hack a way in your installation.

If the aim it to put, say the id of an event, you need to be sure it's an integer before using it.

X+

3

Using Drupal Modules / Custom field using contact reference and civi webform

« Last post by josue on Today at 10:59:00 pm »

hey folks,

i have a custom field that uses the individual contacts in a group to offer options, via contact reference.

i want to make that field available in a drupal webform. i am, of course, using the fabulous civicrm webform integration module!

i have it almost there, and wondering what i am missing.

contact2 just has the Existing Contact field checked.
contact1 has the custom field, with the option User Select chosen.

when i go to the Form Component list, the contact2 Existing Contact field is a Select List, default values is Auto - From Filters, and a Filter is set to limit the options to a group.

the contact1 custom field has Static Option, contact2 checked and is a Listbox.

when i choose an option from contact2 Existing Contact, it does save the response in the proper place (the contact1 custom field).

but when i bring up a record that has an entry for that custom field, it does not show up in the webform.

any ideas on how to properly set this up?

thanks!

--josue

4

Joomla! Installations / Installing CIVICRM 4.3.3

« Last post by Webby123 on Today at 10:53:24 pm »

Hi together,
I tried to upload Civicrm to my joomla system . No error messages , but not mentioned in the list of components.
nothing?

Somebody any ideas?

thanks a lot

webby

5

Using CiviEvent / Re: Custom Standalone Screen for Event

« Last post by jere on Today at 10:10:14 pm »

The webform-civicrm didn't work. It only gives access to contacts and not event data fields.

I did find a way, though, to get what I need. As a test I created a very simple api I called EventRecords.php that I put in my custom php directory under api/v3/:

Code: [Select]

function civicrm_api3_event_records_get($params) {
  return $_GET;
}

Thanks to http://wiki.civicrm.org/confluence/display/CRMDOC43/How+to+migrate+or+write+an+api.

In EventInfo.tpl file (my-custom-template-directory/CRM/Event/Form/ManageEvent/EventInfo.tpl) I added these lines at the top as a test:

Code: [Select]

{crmAPI entity="EventRecords" action="get" var="myData"}
{foreach from=$myData key=getkey item=getvalue}
  <div>{$getkey} : {$getvalue}</div>
{/foreach}

And it worked. It displayed all the values of the $_GET array:
reset : 1
action : update
snippet : 4
id : 9
qfKey : 48006f8ba3f46a273acd264030fa9f13_2305
component : event
q : civicrm/event/manage/settings

I am still pretty new to civicrm, and I did not see a way to write a profile-like custom screen I could call from a link without exposing the $_GET array to either a hook or to the smarty template. The only way I knew to do this is using the $form->assign from a hook (without modifying the core php files). It appears this approach lets me use the api functionality from the smarty template as a kind of hook that could retrieve things, do logic, call api's, and even executeQuery (if necessary) in php and send the results in an array back to the smarty template.

I am hoping the standard functionality of civicrm will handle the updates if I am only using custom fields linked to an event. If not, I could use a standard api for that or I could include an update function in the EventRecords.php as well and call either from a javascript/crmAPI function.

I know it is a hack. If someone sees a better way or a problem I haven't seen let me know.

6

User Groups / Bi-Lingual English/French User Group

« Last post by Richard_Rieger on Today at 08:34:40 pm »

Hello All:
 Was not sure if this is the right place, but here goes, (nothing ventured...)

 I was reading about the ability of Software to handle multiple languages within CivCRM,  and was not sure about the implementation of Dual Language implementations.

Specifically, in the Canadian Context,(Uses both French and English) for Federal Government uses, along with others, There are two places specifically, where uni-lingual implementations fall apart, namely

(A) the User interface.

and

(B) The automatic conversion of Postal information depending on the destination of the mail piece.

Eg:

English Canadian Postal Mail Format

Joe Constituent
123-456 Any Street Name
AnyTown, Province-Name
Postal-Code

or
French Canadian Postal Mail Format

Mme Josephene Voter
123-456 Rue Park
AnyTown(Fr), Quebec
H0H 0H0

where Rue Park is the French Translation of "Park Street".

This then is the problem that is faced when sending Postal Mail within Canada, It is based on two paramaters , the sending language, and the recipeint destination.

7

Using CiviCRM / Repetitions on scheduled reminders in CiviCRM 4.3.2 not working

« Last post by prabhath on Today at 08:27:42 pm »

Hi All,
I'm trying to setup schedule reminders in CiviCRM 4.3.2 for membership renewal reminders.
I have successfully created to send the notice 30 days prior to the membership end date and it's working fine.
However when I enabled repetition and set it to "every 1 day(s) until 6 moth(s) after Membership End Date" it did not send that notification.
I have a membership that expired on 14/05/2013.

I'm using CiviCRM 4.3.2 on Wordpress 3.5.1

Thanks!

8

Using CiviEvent / DB Error: syntax error after upgrade from 3.4.8 to 4.1.5 (Drupal 6)

« Last post by michaels23 on Today at 06:35:42 pm »

I just upgraded from 3.4.8 to 4.1.5 (Drupal 6). Everything works great except events. Almost every event-related 'operation' results in the backtrace and error details below.

I've been able to use phpMyAdmin to trouble-shoot the syntax. All I needed to do is remove one of the DISTINCT arguments at the beginning of the query.

All I know is this fixes the syntax error. I have know idea if this is the 'correct' fix or how to actually implement it in CiviEvent?

Code: [Select]

backTrace

/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 146
, handle,
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2428
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1614
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 153
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 929
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, singleValueQuery, 3921
/home/scethics/scethics.org/sites/scethics.org/files/civicrm/php/CRM/Event/Selector/Search.php, searchQuery, 289
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php, getTotalCount, 239
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Event/Form/Search.php, __construct, 461
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Event/Form/Search.php, postProcess, 191
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/Form.php, preProcess, 327
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 97
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/scethics/scethics.org/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 292
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Event/Page/Tab.php, run, 57
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Event/Page/Tab.php, browse, 186
/home/scethics/scethics.org/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 245
/home/scethics/scethics.org/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 381
, civicrm_invoke,
/home/scethics/scethics.org/includes/menu.inc, call_user_func_array, 352
/home/scethics/scethics.org/index.php, menu_execute_active_handler, 17
error details

Code: [Select]

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT count( DISTINCT  DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 1758 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civ' at line 1]
    [type] => DB_Error
    [user_info] => SELECT count( DISTINCT  DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 1758 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civ' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT count( DISTINCT  DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 1758 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civ' at line 1]"]
)


9

Upgrading CiviCRM / Re: After upgrade to 4.3.3, contribution "Additional Details" , "Honoree" not usable

« Last post by Coleman Watts on Today at 05:22:38 pm »

Check your firebug console for any errors when this happens.

10

Upgrading CiviCRM / Re: Upgrading from 4.3.1 to 4.3.4

« Last post by Coleman Watts on Today at 05:21:17 pm »

@crazywolf I still don't quite know what you've done. What customizations have you done and how did you do them?
Bottom line is that if you upgrade CiviCRM then you have to replace the civicrm directory on your server. So you should not have changed anything in there or of course it will not survive the upgrade.
Everything else you do to customize civicrm will be fine, which includes things like
- Tweaking the css using your own theme
- Changing settings via the UI
- Adding modules or extensions
- Overriding or appending templates in your custom tpl directory
- Adding custom searches, etc.