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 »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Upgrade to 4.1 error
Pages: [1]

Author Topic: Upgrade to 4.1 error  (Read 1097 times)

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Upgrade to 4.1 error
February 17, 2012, 09:16:00 am
I get this upgrade error after extension installation:
Database Error Code: Duplicate column name 'filter', 1060
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_custom_field` ADD `filter` VARCHAR(255) NULL COMMENT 'Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.' [nativecode=1060 ** Duplicate column name 'filter']
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_custom_field` ADD `filter` VARCHAR(255) NULL COMMENT 'Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.' [nativecode=1060 ** Duplicate column name 'filter']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_custom_field` ADD `filter` VARCHAR(255) NULL COMMENT 'Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.' [nativecode=1060 ** Duplicate column name 'filter']"]
)

Looks like a beta 3 downgrade I did didnt completely downgrade [downgrade was performed by system restore point 3rd party extension called Akeeba which is usually solid]

Has the rest of the upgrade happenned or does the process fail/fall over on any error?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Upgrade to 4.1 error
February 17, 2012, 10:26:14 am
The upgrade did NOT complete (due to fatal error). Probably best if you can retry starting w/ 4.0.x or 3.4.x DB. If the filter column exists then the DB is in an inbetween state.
Protect your investment in CiviCRM by  becoming a Member!

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Re: Upgrade to 4.1 error
February 20, 2012, 10:51:34 am
Thanks - think i fixed this by sorting version issues and checking upgrade. Looks sweet now
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Upgrade to 4.1 error

This forum was archived on 2017-11-26.