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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Drupal : multilingual update 3.3.3 > 3.3.5 fails "DB Error: value count on row"
Pages: [1]

Author Topic: Drupal : multilingual update 3.3.3 > 3.3.5 fails "DB Error: value count on row"  (Read 1180 times)

ehanuise

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 2
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.17
  • MySQL version: 5.1.49-3
  • PHP version: 5.3.3-7+squeeze3
Drupal : multilingual update 3.3.3 > 3.3.5 fails "DB Error: value count on row"
February 14, 2011, 01:12:48 am
I tried upgrading 3.3.3 to 3.3.5, and I get this error :
DB Error: value count on row

Quote from: Error Details
Database Error Code: Column count doesn't match value count at row 1, 1136
Additional Details:

Array
(
    [callback] => Array
        (
           
  • => 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_fr_FR, label_nl_NL, label_en_GB, value, name, grouping, filter, is_default, weight, description_fr_FR,  description_nl_NL,  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_fr_FR, label_nl_NL, label_en_GB, value, name, grouping, filter, is_default, weight, description_fr_FR,  description_nl_NL,  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_fr_FR, label_nl_NL, label_en_GB, value, name, grouping, filter, is_default, weight, description_fr_FR,  description_nl_NL,  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]"]
)

This is a recent instll in test, so I'll just delete all and install 3.3.5 from scratch, but still, this could be a problem for others too.
« Last Edit: February 14, 2011, 01:34:57 am by ehanuise »

sushant

  • I post frequently
  • ***
  • Posts: 126
  • Karma: 8
  • CiviCRM version: v3.2.x,v3.3.x v4.0.x, v4.x,trunk
  • CMS version: Drupal 6/7 ,joomla 1.5,1.6
  • MySQL version: 5.1.51
  • PHP version: 5.3.3
Re: Drupal : multilingual update 3.3.3 > 3.3.5 fails "DB Error: value count on row"
February 14, 2011, 02:08:10 am
Hi ehanuise,
Here is the solution for your problem:
http://forum.civicrm.org/index.php/topic,18527.msg76979.html

Hth,
Sushant
CiviCRM Priority Support
http://support.civigardens.com/
http://osseed.com

ehanuise

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 2
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.17
  • MySQL version: 5.1.49-3
  • PHP version: 5.3.3-7+squeeze3
Re: Drupal : multilingual update 3.3.3 > 3.3.5 fails "DB Error: value count on row"
February 14, 2011, 02:10:44 am
Thanks!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Drupal : multilingual update 3.3.3 > 3.3.5 fails "DB Error: value count on row"

This forum was archived on 2017-11-26.