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) »
  • Database error upgrading from 1.9 to 2.0
Pages: [1]

Author Topic: Database error upgrading from 1.9 to 2.0  (Read 1758 times)

Wonder95

  • Guest
Database error upgrading from 1.9 to 2.0
March 30, 2008, 06:01:31 pm
In doing a test upgrade from CiviCRM 1.9 to 2.0 on my local machine (and boy, am I glad I did a test one first!), I get the following backtrace and error when I run step 5 of the upgrade process:
Code: [Select]
backTrace

C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\Error.php, backtrace, 258
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, fatal, 81
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\Form.php, preProcess, 300
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\QuickForm\Action\Display.php, buildForm, 98
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\HTML\QuickForm\Controller.php, perform, 195
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\HTML\QuickForm\Page.php, handle, 95
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\Controller.php, handle, 223
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\Invoke.php, run, 203
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\Invoke.php, upgrade, 150
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\drupal\civicrm.module, invoke, 321
, civicrm_invoke,
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\menu.inc, call_user_func_array, 418
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\index.php, menu_execute_active_handler, 15

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Database consistency check failed for step 5. Value missing in civicrm_custom_field for the column 'name'.

I'm using a dump of both the Drupal and CiviCRM databases from the live site, so I know I have the most current data and database structure.

In looking at the database dump, two of my custom fields have NULL values in the 'name' column in the civicrm_custom_settings table.  When I edit the fields settings in CiviCRM admin, I see a field for the label, but not the field name.  Is that something that gets created behind the scenes when a custom field is created?  If so, if I edit the table and add a name for the field, will it break anything?  Everything has worked fine so far with those custom fields without the names, so I don't want to break that.

Thanks.

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: Database error upgrading from 1.9 to 2.0
March 30, 2008, 06:15:11 pm

Yes, you need to add a 'name' value to those missing that in the DB. We dont know why 'name' is empty in certain db's

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

davej

  • Ask me questions
  • ****
  • Posts: 404
  • Karma: 21
Re: Database error upgrading from 1.9 to 2.0
April 29, 2008, 08:22:23 am
In my case, the empty (null) name fields all occurred where the label contained a slash, so I guess the code that generated the name from the label choked on the slash.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Database error upgrading from 1.9 to 2.0

This forum was archived on 2017-11-26.