CiviCRM Community Forums (archive)

I'm trying to upgrade to 2.0.3 from 1.9.  I followed all upgrade instructions on CiviCRM.org including the #4 of sourcing and rebuilding the database, and when I get to step 5 (custom data) of the script I get the following error:

Yet again I'm getting the following error at step 5 of the CiviCRM upgrade installer - when I try STEP 7 of the upgrade instructions (to run the installer script) ... this is five step process and on the 5 step, Drupal throws out the following error:   (additionally I'm using the new sourced and cleaned up database here per step 4 of the overall upgrade instructions, but it appears to still be having issues with the custom data per this error):

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_1_membership
        ADD COLUMN `mailing_address_zippostal_code:` double,
        ADD INDEX INDEX_mailing_address_zippostal_code: ( mailing_address_zippostal_code: ) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': ( mailing_address_zippostal_code: )' at line 3]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_1_membership
        ADD COLUMN `mailing_address_zippostal_code:` double,
        ADD INDEX INDEX_mailing_address_zippostal_code: ( mailing_address_zippostal_code: ) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': ( mailing_address_zippostal_code: )' at line 3]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="        ALTER TABLE civicrm_value_1_membership
        ADD COLUMN `mailing_address_zippostal_code:` double,
        ADD INDEX INDEX_mailing_address_zippostal_code: ( mailing_address_zippostal_code: ) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': ( mailing_address_zippostal_code: )' at line 3]"



this is a bug in the upgrade script. can you cut-n-paste what the name of the custom field is in your 1.9 database. we transform that name into a column name and seems like we dont eliminate the ':'

As deepak mentions, you can get past the error by changing the name of your custom field

lobo