CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • DB Fatal Error on an export
Pages: [1]

Author Topic: DB Fatal Error on an export  (Read 581 times)

markimus

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
DB Fatal Error on an export
April 17, 2012, 03:25:21 pm
I Am trying to do an export for a mailing list and each time I click 'export' I get this error

Any idea what I need to do to fix this? 


Code: [Select]
=> -22
    [message] => DB Error: value count on row
    [mode] => 16
    [debug_info] =>
INSERT INTO civicrm_export_temp_ac84c4a9faaccd454a961e9759b464e1 (id, first_name,last_name,street_address,city,postal_code,household_name,state_province,organization_name,addressee,street_name,postal_greeting,email_greeting,civicrm_primary_id,master_id,state_province_id,postal_greeting_id,addressee_id,is_deceased,do_not_mail,supplemental_address_1,7_a_b_first_name,7_a_b_last_name,7_a_b_street_address,7_a_b_city,7_a_b_postal_code,7_a_b_household_name,7_a_b_state_province,7_a_b_organization_name,7_a_b_addressee,7_a_b_street_name,7_a_b_postal_greeting,7_a_b_email_greeting,7_a_b_id,7_a_b_master_id,7_a_b_state_province_id,7_a_b_is_deceased,7_a_b_do_not_mail,7_a_b_supplemental_address_1)
VALUES (1,'Helen','Hampson','6 Cranleigh Heath SE','Calgary','T3M0E6','','AB','','','','','','5','','1100','','','','','','','','','','','','','','','','','','','','','','','','','')
 [nativecode=1136 ** Column count doesn't match value count at row 1]
    [type] => DB_Error
    [user_info] =>
INSERT INTO civicrm_export_temp_ac84c4a9faaccd454a961e9759b464e1 (id, first_name,last_name,street_address,city,postal_code,household_name,state_province,organization_name,addressee,street_name,postal_greeting,email_greeting,civicrm_primary_id,master_id,state_province_id,postal_greeting_id,addressee_id,is_deceased,do_not_mail,supplemental_address_1,7_a_b_first_name,7_a_b_last_name,7_a_b_street_address,7_a_b_city,7_a_b_postal_code,7_a_b_household_name,7_a_b_state_province,7_a_b_organization_name,7_a_b_addressee,7_a_b_street_name,7_a_b_postal_greeting,7_a_b_email_greeting,7_a_b_id,7_a_b_master_id,7_a_b_state_province_id,7_a_b_is_deceased,7_a_b_do_not_mail,7_a_b_supplemental_address_1)
VALUES (1,'Helen','Hampson','6 Cranleigh Heath SE','Calgary','T3M0E6','','AB','','','','','','5','','1100','','','','','','','','','','','','','','','','','','','','','','','','','')
 [nativecode=1136 ** Column count doesn't match value count at row 1]
    [to_string] => [db_error: message="DB Error: value count on row" code=-22 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT INTO civicrm_export_temp_ac84c4a9faaccd454a961e9759b464e1 (id, first_name,last_name,street_address,city,postal_code,household_name,state_province,organization_name,addressee,street_name,postal_greeting,email_greeting,civicrm_primary_id,master_id,state_province_id,postal_greeting_id,addressee_id,is_deceased,do_not_mail,supplemental_address_1,7_a_b_first_name,7_a_b_last_name,7_a_b_street_address,7_a_b_city,7_a_b_postal_code,7_a_b_household_name,7_a_b_state_province,7_a_b_organization_name,7_a_b_addressee,7_a_b_street_name,7_a_b_postal_greeting,7_a_b_email_greeting,7_a_b_id,7_a_b_master_id,7_a_b_state_province_id,7_a_b_is_deceased,7_a_b_do_not_mail,7_a_b_supplemental_address_1)
VALUES (1,'Helen','Hampson','6 Cranleigh Heath SE','Calgary','T3M0E6','','AB','','','','','','5','','1100','','','','','','','','','','','','','','','','','','','','','','','','','')
 [nativecode=1136 ** Column count doesn't match value count at row 1]"]
Success is the ability to go from one failure to another with no loss of enthusiasm.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • DB Fatal Error on an export

This forum was archived on 2017-11-26.