Author Topic: Upgrade problem 3.3.3 to 3.3.5 (Read 876 times)

Simon147 · February 09, 2011, 07:21:28 am

Hello all,

I ran into the following error message when upgrading from 3.3.3 to 3.3.5:

Upgrade CiviCRM to Version 3.3.5
Die Website befindet sich im Offline-Modus.
Sorry. A non-recoverable error has occurred.
DB Error: value count on row
Error Details
Database Error Code: Column count doesn't match value count at row 1, 1136
Additional Details:

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

    [code] => -22
    [message] => DB Error: value count on row
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_option_value
  (option_group_id, label_en_US, label_de_DE, label_fr_FR, label_it_IT, label_en_GB, value, name, grouping, filter, is_default, weight, description_en_US,  description_de_DE,  description_fr_FR,  description_it_IT,  description_en_GB, is_optgroup,is_reserved, is_active, component_id, visibility_id ) 
VALUES
    (@ogrID  , 'Grant Report (Statistics)', 'grant/statistics', 'CRM_Report_Form_Grant_Statistics', NULL, 0, 0,  @max_weight+1, 'Shows statistics for Grants', 0, 0, 1, @grantCompId, 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_de_DE, label_fr_FR, label_it_IT, label_en_GB, value, name, grouping, filter, is_default, weight, description_en_US,  description_de_DE,  description_fr_FR,  description_it_IT,  description_en_GB, is_optgroup,is_reserved, is_active, component_id, visibility_id ) 
VALUES
    (@ogrID  , 'Grant Report (Statistics)', 'grant/statistics', 'CRM_Report_Form_Grant_Statistics', NULL, 0, 0,  @max_weight+1, 'Shows statistics for Grants', 0, 0, 1, @grantCompId, 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_de_DE, label_fr_FR, label_it_IT, label_en_GB, value, name, grouping, filter, is_default, weight, description_en_US,  description_de_DE,  description_fr_FR,  description_it_IT,  description_en_GB, is_optgroup,is_reserved, is_active, component_id, visibility_id ) 
VALUES
    (@ogrID  , 'Grant Report (Statistics)', 'grant/statistics', 'CRM_Report_Form_Grant_Statistics', NULL, 0, 0,  @max_weight+1, 'Shows statistics for Grants', 0, 0, 1, @grantCompId, NULL) [nativecode=1136 ** Column count doesn't match value count at row 1]"]
)

A similar error was encountered by others decribed here.

As it looks, things are working fine in my CiviCRM for now. I just have no idea what this error means and if there could appear other problems because of it.

Simon

Dave Greenberg · February 09, 2011, 02:03:26 pm

Simon - This is an error that affected CiviCRM sites that have Multiple Languages enabled. Unfortunately, we can't be sure that your DB upgrade complete successfully - so the best approach would be to restore a copy of your 3.3.3 DB and redo the upgrade process after applying this patch to your 3.3.5 code-base:

https://fisheye2.atlassian.com/rdiff/CiviCRM?csid=32379&u&N

CiviCRM Community Forums (archive)

News:

Author Topic: Upgrade problem 3.3.3 to 3.3.5 (Read 876 times)

Simon147

Upgrade problem 3.3.3 to 3.3.5

Dave Greenberg

Re: Upgrade problem 3.3.3 to 3.3.5