Export Event Participants - DB Error: value count on row

[mcgeehon]

I have been experiencing a DB error recently when trying to export participants of various events.  It appears to be a MySQL error generated possibly due to Civi trying to insert a row number of '1' into an AUTOINCREMENT row in the civicrm_export_temp_ tables.

Is this a known issue?  Are there known incompatability problems with the latest versions of MySQL? 

The query in question is:

Code: [Select]

INSERT INTO civicrm_export_temp_dd69852bf6cf49e42b51a19e77fa07af (id, civicrm_primary_id,contact_type,contact_sub_type,do_not_email,do_not_phone,do_not_mail,do_not_sms,do_not_trade,is_opt_out,legal_identifier,external_identifier,sort_name,display_name,nick_name,legal_name,image_url,preferred_communication_method,preferred_language,preferred_mail_format,hash,contact_source,first_name,middle_name,last_name,job_title,birth_date,is_deceased,deceased_date,household_name,organization_name,sic_code,user_unique_id,current_employer_id,contact_is_deleted,addressee,email_greeting,postal_greeting,gender,individual_prefix,individual_suffix,current_employer,location_type,street_address,street_number,street_number_suffix,street_name,street_unit,supplemental_address_1,supplemental_address_2,city,postal_code_suffix,postal_code,geo_code_1,geo_code_2,address_name,master_id,county,state_province,country,phone,phone_ext,email,on_hold,is_bulkmail,signature_text,signature_html,im_provider,im,openid,world_region,url,phone_type_id,provider_id,event_id,event_title,event_start_date,event_end_date,event_type,participant_id,participant_status,participant_role_id,participant_note,participant_register_date,participant_source,participant_fee_level,participant_is_test,participant_is_pay_later,participant_fee_amount,participant_discount_name,participant_fee_currency,participant_registered_by_id,participant_campaign_id,participant_campaign)
VALUES (1,'24204','Individual','','','','','','','','','','Doe, John','John Doe','','','','','en_US','Both','f454a121255bd20593aaefcfa9df080c','','John','','Doe','Mr','','','','','','','','24205','','John Doe','Dear John','Dear John','','','','Energy','','','','','','','','','','','','','','','','','','','','','John.Doe@gmail.com','','','','','','','','','','','','1694','Standard Event','2013-06-12 18:30:00','2013-06-12 20:00:00','Standard Event','18338','Registered','Attendee','','2013-05-23 09:04:55','Event Title','','','','','','USD','','','','','','','','')

Here is what phpmyAdmin says when running the above INSERT:

#1136 - Column count doesn't match value count at row 1

Here is what I am running:
CiviCRM: 4.3.3
Database client version: libmysql - 5.5.31


Any Ideas?

[Donald Lobo]

can u reproduce this on our demo servers (i suspect so). if so, please do file an issue and we'll take a look

lobo

[mcgeehon]

Done.  I reproduced it on the sandbox server and created filed a new issue in Jira.

[Yashodha Chaku]

mcgeehon :

Export of participants for free events resulted in the error.
This has been fixed for 4.3, will be available in the next release.

Here is the patch :
https://github.com/civicrm/civicrm-core/pull/928.patch

HTH
-Yashodha