eugeneb 49 Posted March 31, 2020 Report Share Posted March 31, 2020 Hi guys, I tried creating a new module in a brand new install. Has anyone gotten this error: Error Code: 500Error 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 failsStack Trace: [click to toggle display]X2Engine Version: 8.0PHP 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 Quote Link to post Share on other sites
jack 7 Posted April 6, 2020 Report Share Posted April 6, 2020 Hi Eugene,Can you please upload the full stack trace plus the SQL statement so I can better diagnose the issue.-Jack Quote Link to post Share on other sites
eugeneb 49 Posted April 7, 2020 Author Report Share Posted April 7, 2020 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. Quote Link to post Share on other sites
jack 7 Posted April 7, 2020 Report Share Posted April 7, 2020 No problem, happy you found a solution.-Jack Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.