3 replies to this topic

[eugeneb]

Hi guys,

 

I tried creating a new module in a brand new install. Has anyone gotten this error:

 

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails
Stack Trace: [click to toggle display]
X2Engine Version: 8.0
PHP Version: 7.0.33-0ubuntu0.16.04.12

 

I tried various things during the creation process but end up with this 1217 error

 

Any advise?

 

Thanks

[jack]

Hi Eugene,

Can you please upload the full stack trace plus the SQL statement so I can better diagnose the issue.

-Jack

[eugeneb]

SOLVED!

 

Hi Jack, I found the problem. I am trying to create a module called Events. Not realizing X2 has its own Events module already, creating the bug as its trying to remove the existing one. Thats also why it happened in my tests in other X2 instances I have. I tested using Events.

 

Sorry guys, my bad. I should have looked at the existing modules in the DB first.

[jack]

No problem, happy you found a solution.
-Jack