CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade error going from 3.3.2 -> 3.4.8
Pages: [1]

Author Topic: Upgrade error going from 3.3.2 -> 3.4.8  (Read 726 times)

pswartz

  • I post occasionally
  • **
  • Posts: 41
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7.x
  • MySQL version: 5.1.46
  • PHP version: 5.3.3
Upgrade error going from 3.3.2 -> 3.4.8
January 07, 2012, 07:08:04 am
Hi All,
I'm prepping my site to make the leap to Drupal7/CiviCRM4, but wanted to do the minor upgrades first.  On my test site (Drupal 6.22 on OpenSuSE 11.3) with CiviCRM 3.3.2 installed I get this error when running the upgrade script --

Code: [Select]
Database Error Code: Duplicate column name 'goal_general', 1060
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_campaign` ADD `goal_general` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci default NULL NULL COMMENT 'General goals for Campaign.' [nativecode=1060 ** Duplicate column name 'goal_general']
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_campaign` ADD `goal_general` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci default NULL NULL COMMENT 'General goals for Campaign.' [nativecode=1060 ** Duplicate column name 'goal_general']
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_campaign` ADD `goal_general` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci default NULL NULL COMMENT 'General goals for Campaign.' [nativecode=1060 ** Duplicate column name 'goal_general']"]
)

I have never used CiviCampaign and don't see where it is even available to be enabled in the "Enable Components" page.

I'm used Webmin to create the database backup prior to the upgrade and use it to restore the db after the failure.

Any help would be greatly appreciated.

Thanks,
Patrick

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade error going from 3.3.2 -> 3.4.8

This forum was archived on 2017-11-26.