CiviCRM Community Forums (archive)

Upgrade from 4.0 to 4.1 in Joomla 2.5 fails with the following error.  Ultimate goal is to go from 3.4.7 in a Joomla 1.5 installation to 4.4 in Joomla 3.2.  Installing civiCRM 4.0 in Joomla 3.2 failed, so for now I'm using a dummy Joomla 2.5 installation to make the upgrades.  Managed to get from 3.47 to 4.0 ok, using a stand-alone database, and backed up the tables at that point.  But now the 4.1 upgrade script returns:

Sorry. A non-recoverable error has occurred.
DB Error: unknown error
Error Details
Database Error Code: Duplicate column name 'fullscreen_url', 1060
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_dashboard` ADD `fullscreen_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'fullscreen url for dashlet' [nativecode=1060 ** Duplicate column name 'fullscreen_url']
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_dashboard` ADD `fullscreen_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'fullscreen url for dashlet' [nativecode=1060 ** Duplicate column name 'fullscreen_url']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_dashboard` ADD `fullscreen_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'fullscreen url for dashlet' [nativecode=1060 ** Duplicate column name 'fullscreen_url']"]
)
Return to home page.

What should I do next?

Hershel was correct - the previous upgrade of the database had not completed but somehow was still able to run.  When the next upgrade came, it failed. 

It (eventually - that's another story) worked following a schema rebuild on an earlier database and redoing the earlier upgrade.

Christopher