CiviCRM Community Forums (archive)

Drupal 6.15; CiviCRM 3.1.2; Mac OSX 10.6.2; Safari 4.0.4

After installing 3.1.2, going to CiviCRM Home (civicrm/dashboard?reset=1) I'm presented with an offer to configure my dashboard and a notice that 'loading...' is ongoing (see attached). There's are spinning dots indicating an ongoing process, but it never stops. If I do click 'configure dashboard', I get the error below and a very odd screen (see also attached). Other potentially pertinent notes: I completely deleted a previous install of 3.0.4, deleted the CiviCRM associated database, and started from scratch (or so I think).
--------
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 (`resource_civicrm/civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
Return to home page.
Error Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] =>
                    INSERT INTO civicrm_dashboard_contact ( dashboard_id, contact_id )
                    VALUES  ( 1, 102 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`resource_civicrm/civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] =>
                    INSERT INTO civicrm_dashboard_contact ( dashboard_id, contact_id )
                    VALUES  ( 1, 102 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`resource_civicrm/civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="
                    INSERT INTO civicrm_dashboard_contact ( dashboard_id, contact_id )
                    VALUES  ( 1, 102 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`resource_civicrm/civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)[/i][/i]
--------------


I have the exact same problem after upgrading to 3.1.2.

The dashboard works fine under IE (strange) but is stuck as above under FireFox.

The upgrade sequence all the way from 3.0.2 took forever - so if I have to reinstall CiviCRM and import my data, is the problem in the code base not the data?

Just to clarify, the problem with individual contacts existed *before* the cleansing, not after...

Re the subject problem of the dashboard being 'stuck', after reinstalling several times, I had misread Kurund's simpler solution of logging out. I was logged in as User 1 after doing a Drupal DB upgrade when the problem first occurred.

Logging out did fix my problem with the dashboard being stuck but this reoccurs consistently when logged in as Drupal User 1. Dashboard works fine logged in as different Civicrm-permissioned user. The difference (no them) in IE was caused by hitting IE's CSS file limit. Dashboard 'stuck' problem reoccurs ( but without the full DB constraint error message) with User 1 on both FF & IE as reported by 1green1.

Sorry for the confusion - good advice given by Kurund.

When I reported this as a bug, Mr Lobo refused to consider it as such and directed me to the forum -- which contained NOTHING of relevance. Evidently this didn't affect previous versions of CiviCRM. If fixing this requires a complete reinstall, it is certainly quite bug-like. Mr Lobo claimed there must be "some old session data attached to your browser" but provide absolutely no additional guidance. I'm sure he's busy and is clear a best-loved maintainer, but that's cold to say the least. Most of us have no idea what "session data" is to begin with.

This is what I did. I tried the same procedure on another computer with the same version of Safari. No problem. It worked fine. Searched in a number of places and finally found how to "reset safari" (under the Safari menu -- see Reset Safari. There's probably something similar for IE.). This blows away a lot of stuff including everything you have in open Safari windows, so make sure you're ready.

But it worked.

Note, this also caused a similar problem with editing individual contacts...

In any case, this is not a simple issue of "some old session data attached to your browser" as if the truth of that assertion was enough. It needs some specific attention.

I recall the upgrade howto instructing us to remove session information from the database prior to each upgrade iteration.

Did you do this?
<url>/civicrm/admin?sessionReset=2

Worked for me.



- Dan.

I had the same problem - I had uninstalled CiviCRM and then reinstalled it and lots of stuff on the Configuration Checklist worked but that Dashboard page was stuck -- I think the problem probably was cached data on my browser.

I was using Firefox and couldn't get around the error -- errors such as
INSERT INTO civicrm_dashboard_contact ( dashboard_id, contact_id )
                    VALUES  ( 1, 102 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civigtt`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]

Saw one of these posts saying it worked in Internet Explorer so I quickly tried that and the page came up. So then I thought ok, now it's fixed and the database is happy, went back to Firefox and had the same error.

Read the post about clearing caches so in Firefox went to Tools/Clear Recent History and cleared caches and active logins - I can't recall for sure but I might have cleared just the first four items in that list that comes up - Browsing, Form, Cookies, Cache -- with no luck, and it might not have been until I added clearing active logins.

Anyway, problem fixed by first opening the page in ie, which I suspect is irrelevant, and then clearing caches etc in Firefox.

FYI I'm on Drupal 6.20 and CiviCRM 3.3.2, Win 7 Pro, Wamp. Oooh. Clever. I just noticed that the forum knows which versions of everything I'm on.