Cannot make any changes to CiviCRM - DB Error: Constraint violation

[Lionsharz]

Hi,

Fresh install 4.4.4 I cannot edit anything - once I press save the following error is returned...  Any ideas?

Code: [Select]

Sorry but we are not able to provide this at the moment.
DB Error: constraint violation
Error Details
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`stage_civinew`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  4 , 'civicrm_contact,4' ,  4686 ,  20141025214536 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`stage_civinew`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  4 , 'civicrm_contact,4' ,  4686 ,  20141025214536 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`stage_civinew`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_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_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  4 , 'civicrm_contact,4' ,  4686 ,  20141025214536 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`stage_civinew`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)
Return to home page.
Thanks for any help you can give!

N

[Coleman Watts]

If this is a fresh install, I'm not sure why you did not install the latest version. If you have no data then you've got nothing to lose by re-installing with 4.5.2 or at least 4.4.8.

[Hershel]

Coleman's suggestion makes sense. It seems your problem has to do with logging that you enabled, so if you can disable that, it might work also.

[Lionsharz]

thanks for the response guys.

What happened here was we had 2 Drupal installs (stage and live) pointing to the same CiviCRM database. The sites were roughly the same but I ran Backup & Migrate from the live back to stage. Everything seemed to work ok but then I couldn't make any changes to civicrm. I don't want to upgrade at this time - all I wanted to do was move the database under the live site as we had finished ou development work for the time being.

I cannot turn off logging through the UI (it throws an error). Is there any way to disable logging from inside the database?

[JonGold]

I'd check your Backup & Migrate settings and see if you excluded any tables from the backup.  You might also want to use mysqldump or PhpMyAdmin instead of Backup & Migrate and see if that gives you better luck.

[Lionsharz]

no it wasn't excluding any tables. The B&M is only for the Drupal install -not civicrm...

[Lionsharz]

The issue came from the export from PhpMyAdmin. I needed to export again unchecking the checkbox for 'check for foreign keys' I played around with some other settings on the export page and then re-imported. It came good after that.