Author Topic: 1.9 to 2.0Beta2 and Joomla (Read 1907 times)

montano · February 26, 2008, 01:56:05 pm

The original installation was 1.9. I am attempting to upgrade to 2.0 beta 2 and got through most of the steps when this occurred in step 5

Code: [Select]

Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>         ALTER TABLE custom_value_1_Custom_Contact_Information
        ADD COLUMN `ID` varchar(255),
        ADD INDEX INDEX_ID ( ID ) [nativecode=1060 ** Duplicate column name 'ID']
    [type] => DB_Error
    [user_info] =>         ALTER TABLE custom_value_1_Custom_Contact_Information
        ADD COLUMN `ID` varchar(255),
        ADD INDEX INDEX_ID ( ID ) [nativecode=1060 ** Duplicate column name 'ID']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="        ALTER TABLE custom_value_1_Custom_Contact_Information
        ADD COLUMN `ID` varchar(255),
        ADD INDEX INDEX_ID ( ID ) [nativecode=1060 ** Duplicate column name 'ID']"]

[/code]

Donald Lobo · February 26, 2008, 02:06:56 pm

you have a custom field called id in v1.9. the short term fix is to rename that custom field to something else (like myID) so it does not conflict with our auto created id. we'll add this as a verification step and also disallow this in 2.0

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: 1.9 to 2.0Beta2 and Joomla (Read 1907 times)

montano

1.9 to 2.0Beta2 and Joomla

Donald Lobo

Re: 1.9 to 2.0Beta2 and Joomla