CiviCRM Community Forums (archive)

When I try to upgrade my 4.5.8 database to 4.6beta4 the installer process stalls at:

[Error: Upgrade DB to 4.6.alpha7]
ALTER TABLE civicrm_mailing_abtest ADD COLUMN `created_id` int unsigned COMMENT 'FK to Contact ID', ADD COLUMN `created_date` datetime COMMENT 'When was this item created', ADD COLUMN `testing_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD COLUMN `winner_criteria` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, ADD CONSTRAINT FK_civicrm_mailing_abtest_created_id FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL [nativecode=1060 ** Duplicate column name 'created_id']

Does anyone know if this point to an error in the installer? And how to proceed from here?

Just in case it helps anyone else: I ran into this problem due to a problem upgrading from 4.5.8 to 4.6.0 (I have CRM set to use a different database than my Joomla install, so I think I have to manually replace the com_civicrm-admin/civicrm.zip -> civicrm/templates/CRM/common/civicrm.settings.php.template with a version with the correct database - at least, I haven't found another way to have the install use the correct DB.)

Anyway, I messed it up and had a partial install that affected the database.  Then I ran into this error during the database upgrade.  To fix it, I had to drop my crm database, recreate it, restore from the 4.5.8 backup, and install the upgrade (getting my replacement of civicrm.settings.php.template right this time!)