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) »
  • Failed upgrade from 1.9.13019 to 2.0
Pages: [1]

Author Topic: Failed upgrade from 1.9.13019 to 2.0  (Read 1192 times)

fongd

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
Failed upgrade from 1.9.13019 to 2.0
October 08, 2009, 10:46:54 am
Hi,

We've inherited an old CiviCRM 1.9 installation and are aiming to upgrade it to CiviCRM 3.0. My understanding is that I have to apply the 1.9 => 2.0 upgrade first, so I've been following this page as a reference:

http://wiki.civicrm.org/confluence/display/CRMDOC21/Upgrade+Drupal+Sites+to+2.0

I'm stuck at step 4, where I'm supposed to rebuild the database to ensure integrity. When I try to feed the data back into the "fix" database, I get the following error:

ERROR 1054 (42S22) at line 87: Unknown column 'lang_code' in 'field list'

Line 87 of the SQL file is an INSERT statement that references a "lang_code" column in the civicrm_contact table that isn't set up by the civicrm_41.mysql SQL script. I get the feeling this is a custom field, but I'm at a loss as to how to proceed here. From what I've been told, CiviCRM was not customized (from a coding standpoint), so this column must have been added through CiviCRM. Can anyone provide some pointers on how I might be able to get the upgrade going?

Thanks in advance!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Failed upgrade from 1.9.13019 to 2.0
October 08, 2009, 05:21:12 pm
Pretty sure there was never a lang_code column in civicrm_contact table. Just re-verified by looking at schema definition file for 1.9:
http://svn.civicrm.org/civicrm/branches/v1.9/xml/schema/Contact/Contact.xml

... so I'm guessing the info you got about customization was not correct / complete. I'd look for references to that field in the installed codebase - as well as see if there's data in that field in order to get some idea as to if / how it's being used.
Protect your investment in CiviCRM by  becoming a Member!

fongd

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
Re: Failed upgrade from 1.9.13019 to 2.0
October 14, 2009, 08:10:59 am
Thanks for the tip! I compared the files between the stock CiviCRM 1.9 download here and the one that was installed for the old Drupal site, and there are some differences. I'll have to do some more digging to figure out how to migrate this to 2.0...

fongd

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
Re: Failed upgrade from 1.9.13019 to 2.0
October 15, 2009, 12:41:12 pm
I did a comparison of files between the installed CiviCRM module and the stock download, and the only differences that came up were very minor in scope and don't appear to have anything to do with any custom DB columns. Is it possible that the lang_code column (and possibly others) were created through CiviCRM somehow?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Failed upgrade from 1.9.13019 to 2.0
October 15, 2009, 03:55:45 pm

no. we dont allow folks to extend the core civicrm tables

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Failed upgrade from 1.9.13019 to 2.0

This forum was archived on 2017-11-26.