CiviCRM Community Forums (archive)

CiviCRM 3.2.4

Problems with getting dashlets to appear on the Dashboard.

After checking the 'Available for Dashboard?' checkbox and clicking the 'Update Report' button on a report page, it returns an error of: 'Sorry. A non-recoverable error has occurred. DB Error: constraint violation'

Log attached.

Any ideas on how to fix this?

Thanks,

COS

Logging out and logging back in makes no difference.

All tables check as InnoDB.

I moved the website from one server to another. Did I break something? Any idea what?

cos

Upload didn't work on last post attempt.

I believe that I am following the instructions correctly. I've moved several sites, and they have worked well after moving.

I thought that perhaps the schema was messed up, so updated that according to this post:
http://wiki.civicrm.org/confluence/display/CRMDOC32/Ensuring+Schema+Integrity+on+Upgrades

If anyone wants to update their schema with a bash script, you can try the one I wrote. It's attached.

But updating the schema didn't help. Any ideas?

COS

Hello All,

I thought that perhaps something was bunged up in the config_backend. Set it to NULL. Didn't help.

So the real problem is that the database has gotten out of sync with itself. Don't know how I managed to convince it to do that, but I did.

When it runs the inserts, it barfs:

INSERT INTO civicrm_dashboard_contact ( dashboard_id, contact_id )
                  VALUES  ( 16, 1 ), ( 16, 3 ), ( 16, 9 ), ( 16, 14 ), ( 16, 78 ), ( 16, 3859 ), ( 16, 4285 ), ( 16, 4293 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`alisa_gf_net_dev_CC/civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]

Well duh, if I run

SELECT id FROM civicrm_contact;

I get
+------+
| id   |
+------+
|    1 |
| 4282 |
| 4283 |
| 4284 |
| 4285 |
| 4286 |

These ids don't exist: 3,9,14,78,3859

OK, so now the question is, where is CiviCRM getting the idea that those ids exist? What table is it pulling them from? I need to go to that table and delete those entries because they are stale.

Thanks so much,

COS