CiviCRM Community Forums (archive)

I am upgrading from 1.8(php4 on Drupal) to 2.0.5 with (MySQL - 5.0.45 + PHP 5.2.6) and hit a problem in step #5 of the update process. From doing a bit of searching, I'm thinking that my problem is the plus sign in a custom field.  From what I see in the error msgs. The problems are from a test field that I can drop since it has no data that I need.

CiviCRM 2.0 Upgrade: Step Five (Custom Data Upgrade)

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

    DB Error: syntax error

    Return to home page.

Error Details:

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

    [co de] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_1_additional_guests__max_3
        ADD COLUMN `additional_guest_(2)_name_+_email` varchar(255),
        ADD INDEX INDEX_additional_guest_(2)_name_+_email ( additional_guest_(2)_name_+_email ) [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 '2)_name_+_email ( additional_guest_(2)_name_+_email )' at line 3]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_1_additional_guests__max_3
        ADD COLUMN `additional_guest_(2)_name_+_email` varchar(255),
        ADD INDEX INDEX_additional_guest_(2)_name_+_email ( additional_guest_(2)_name_+_email ) [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 '2)_name_+_email ( additional_guest_(2)_name_+_email )' 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_additional_guests__max_3
        ADD COLUMN `additional_guest_(2)_name_+_email` varchar(255),
        ADD INDEX INDEX_additional_guest_(2)_name_+_email ( additional_guest_(2)_name_+_email ) [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 '2)_name_+_email ( additional_guest_(2)_name_+_email )' at line 3]"]
)

I hope this goes up OK. On my Mac the whole preview tries to fit in a one line box.  :-(

Thank you for the pointer to the "civicrm_custom_field" database entry. I went in and changed/deleted the plus signs and parentheses and then gave it another try, and things went fine :-)

I am now thru steps 5 & 6 and am moving on the Drupal session table.

Can't wait to take it live :-)