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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Foreign Key failure - possible bug
Pages: [1]

Author Topic: Foreign Key failure - possible bug  (Read 1422 times)

tgoorden

  • Guest
Foreign Key failure - possible bug
February 14, 2008, 07:29:18 am
Hi,

I'm having pretty serious issues with my CiviCRM 1.9 + Drupal installation. I keep getting foreign key constraint failures in the logging mechanism. I think civiCRM is trying to insert a civicrm_contact(id) that does not exists (any more). I'm guessing something went wrong when merging contact details. Most likely, I must have merged the admin profile with a newer duplicate of the same profile. Hence, contact ID "1" is no longer available, but it seems to have lingered on somewhere because civiCRM still tries to use it.
'm guessing a manual intervention is in order, but I have trouble figuring out how civiCRM matches the currently logged in profile with an internal CiviCRM ID. I thought it might be in civicrm_uf_match, but the contact_id's there seem in order (there's nothing there with contact_id=1).

Help!
Thomas

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: Foreign Key failure - possible bug
February 14, 2008, 10:01:51 am

can you truncate your drupal session table and try again.

We also cache the contactID in the session table which i suspect is tripping you up. if truncating the session does work, can you file an issue for this in the issue tracker and link to this forum topic

thanx

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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Foreign Key failure - possible bug

This forum was archived on 2017-11-26.