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) »
  • Problem migrating to 2.2.9.
Pages: [1]

Author Topic: Problem migrating to 2.2.9.  (Read 963 times)

MichelBiezunski

  • Guest
Problem migrating to 2.2.9.
September 14, 2009, 12:46:38 pm
I have (tried to) migrate to 2.2.9 on Drupal. I have uninstalled the preceding version I had, dropped all tables, restarted from scratch. The
installation went fine, but when I tried to add a new individual,
I received the message below.
I am new to CiviCRM, and I have spent some time getting around
it but I couldn't find a solution.

Message --------------------------------------------------

Sorry. A non-recoverable error has occurred.

DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrmdb`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
-------------------------------------------------------------

Thank you for any help you can provide.

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: Problem migrating to 2.2.9.
September 14, 2009, 01:03:12 pm

Most likely you forgot to truncate the session table. Can you logout and log back in OR better yet truncate your drupal session table

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

MichelBiezunski

  • Guest
Re: Problem migrating to 2.2.9.
September 14, 2009, 01:17:20 pm
Lobo,
Thank you.
Following your instructions, I truncated sessions on the drupal database.
I used the command mysql -u xxx -p
then:
mysql> use drupaldb;
mysql> truncate sessions;
But now, it doesn't let me in again. It says user / password not recognized.
Any idea what went wrong?

Michel

MichelBiezunski

  • Guest
Re: Problem migrating to 2.2.9.
September 14, 2009, 01:22:10 pm
Lobo,

It actually worked. Please ignore my last message.
It's not the same username/password for Drupal,
I was confused. Sorry.

Michel

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Problem migrating to 2.2.9.

This forum was archived on 2017-11-26.