CiviCRM Community Forums (archive)

This is with a test site which is fortunate because I have not yet been able to recover by restoring the database with a recent backup and using the original 3.2.0 files (also recent backup).

The site has English as default language and French as an additional language.

On running CiviCRM upgrade script

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

Which is not very useful!

I examined the db in phpMyadmin and see that the restored backup has has the "view" tables converted to "isam" which must be a problem with the cPanel user not having MySQL "SUPER" and "VIEW" privileges.

This leads me to think the upgrade failed because this is using MySQL 5.0.x on a multi-lingual CiviCRM install.

I can fix the problem with the cPanel user so backups are not corrupted (I think). I'll also restore the test site from main, from the command line if necessary and see if I can get an upgrade to work.

Here are the errors and backtrace via the Drupal watchdog

$Fatal Error Details = Array ( [callback] => Array (

• => CRM_Core_Error [1] => handle )
  Code: [Select]
  => -22 [message] => DB Error: value count on row [mode] => 16 [debug_info] => INSERT INTO civicrm_option_value (option_group_id, label_en_US, label_fr_CA, value, name, grouping, filter, is_default, weight, description_en_US, description_fr_CA, is_optgroup,is_reserved, is_active, component_id, visibility_id ) VALUES (@ogrID , 'Grant Report', 'grant', 'CRM_Report_Form_Grant', NULL, 0, 0, @max_weight+1, 'Grant Report', 0, 0, 1, @grantCompId, NULL), (@ogrID, 'Participant list Count Report', 'Participant list Count Report', 'event/participantlist', 'CRM_Report_Form_Event_ParticipantListCount', NULL, 0, 0, @max_weight+2, 'Shows the Participant list with Participant Count.', 'Shows the Participant list with Participant Count.', 0, 0, 1, @eventCompId, NULL), (@ogrID, 'Income Count Summary Report', 'Income Count Summary Report', 'event/incomesummary', 'CRM_Report_Form_Event_IncomeCountSummary', NULL, 0, 0, @max_weight+3, 'Shows the Income Summary of events with Count.', 'Shows the Income Summary of events with Count.', 0, 0, 1, @eventCompId, NULL) [nativecode=1136 ** Column count doesn't match value count at row 1] [type] => DB_Error [user_info] => INSERT INTO civicrm_option_value (option_group_id, label_en_US, label_fr_CA, value, name, grouping, filter, is_default, weight, description_en_US, description_fr_CA, is_optgroup,is_reserved, is_active, component_id, visibility_id ) VALUES (@ogrID , 'Grant Report', 'grant', 'CRM_Report_Form_Grant', NULL, 0, 0, @max_weight+1, 'Grant Report', 0, 0, 1, @grantCompId, NULL), (@ogrID, 'Participant list Count Report', 'Participant list Count Report', 'event/participantlist', 'CRM_Report_Form_Event_ParticipantListCount', NULL, 0, 0, @max_weight+2, 'Shows the Participant list with Participant Count.', 'Shows the Participant list with Participant Count.', 0, 0, 1, @eventCompId, NULL), (@ogrID, 'Income Count Summary Report', 'Income Count Summary Report', 'event/incomesummary', 'CRM_Report_Form_Event_IncomeCountSummary', NULL, 0, 0, @max_weight+3, 'Shows the Income Summary of events with Count.', 'Shows the Income Summary of events with Count.', 0, 0, 1, @eventCompId, NULL) [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_option_value (option_group_id, label_en_US, label_fr_CA, value, name, grouping, filter, is_default, weight, description_en_US, description_fr_CA, is_optgroup,is_reserved, is_active, component_id, visibility_id ) VALUES (@ogrID , 'Grant Report', 'grant', 'CRM_Report_Form_Grant', NULL, 0, 0, @max_weight+1, 'Grant Report', 0, 0, 1, @grantCompId, NULL), (@ogrID, 'Participant list Count Report', 'Participant list Count Report', 'event/participantlist', 'CRM_Report_Form_Event_ParticipantListCount', NULL, 0, 0, @max_weight+2, 'Shows the Participant list with Participant Count.', 'Shows the Participant list with Participant Count.', 0, 0, 1, @eventCompId, NULL), (@ogrID, 'Income Count Summary Report', 'Income Count Summary Report', 'event/incomesummary', 'CRM_Report_Form_Event_IncomeCountSummary', NULL, 0, 0, @max_weight+3, 'Shows the Income Summary of events with Count.', 'Shows the Income Summary of events with Count.', 0, 0, 1, @eventCompId, NULL) [nativecode=1136 ** Column count doesn't match value count at row 1]"] ) [/li][/list]


$backTrace = /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 189 , handle, /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Utils/File.php, query, 243 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php, sourceSQLFile, 154 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php, source, 275 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php, processLocales, 291 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php, processSQL, 212 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 219 /home/foodadm/public_html/drupal/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 351 , civicrm_invoke, /home/foodadm/public_html/drupal/includes/menu.inc, call_user_func_array, 348 /home/foodadm/public_html/drupal/index.php, menu_execute_active_handler, 18

CiviCRM upgrade successful 

All went smoothly with your fix. No issues found so far. I'll be doing some CiviContribute, CiviEvent and CiviMail set-ups on this test install today and will let you know if I encounter any issues.

Thank you!
Neil