CiviCRM Community Forums (archive)

Hello,

I just installed CiviCRM and attempted to create a new Event.  After I enter the information on the first step and click "continue" I get the following error:

Sorry. A non-recoverable error has occurred.

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`fenixf5_drpl1/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`)), 1452

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )
[/i]
   

[code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , modified_id , modified_date ) VALUES ('civicrm_event' ,  2 ,  1 ,  20071027 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`fenixf5_drpl1/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`))]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , modified_id , modified_date ) VALUES ('civicrm_event' ,  2 ,  1 ,  20071027 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`fenixf5_drpl1/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_log (entity_table , entity_id , modified_id , modified_date ) VALUES ('civicrm_event' ,  2 ,  1 ,  20071027 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`fenixf5_drpl1/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`))]"]
)

Please advise.  I need to have this working for a project I have to complete by the middle of the week.  Thank you.[/code]

Thank you.  That did work.  However, now after I went through step one of creating a new event, it completely skipped over subsequent steps.  So now I can see my event in the event list but when I click on it there are no details it is just a blank content area.  When I click the "configure" link I get the same thing.  Please advise.

edit  - Upon further investigation, I think this wa due to the fact that I installed Views and calendar.  Everything was fine before now I cant even see contact information.  I know I should post in another thread but if someone does see this and knows what I need to do in order to get civicrm back to normal I would appreciate it.

Lobo,

Thanks again.  What I ended up doing was just uninstalling the whole thing and reinstalling seeing as how I had no real data in there yet.  Its working fine now.  Please take a look at my latest thread when you get a chance though.  I really do need some assistance:

http://forum.civicrm.org/index.php/topic,1448.0.html