Jump to content


Photo

Can't create a new module in Version 8


  • Please log in to reply
3 replies to this topic

#1 eugeneb

eugeneb

    Advanced Member

  • Members
  • PipPipPip
  • 355 posts
  • LocationCenturion, south Africa

Posted 31 March 2020 - 02:14 AM

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



#2 jack

jack

    Admin

  • Administrators
  • 61 posts

Posted 06 April 2020 - 11:07 AM

Hi Eugene,

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

-Jack



#3 eugeneb

eugeneb

    Advanced Member

  • Members
  • PipPipPip
  • 355 posts
  • LocationCenturion, south Africa

Posted 07 April 2020 - 01:03 AM

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.



#4 jack

jack

    Admin

  • Administrators
  • 61 posts

Posted 07 April 2020 - 10:00 AM

No problem, happy you found a solution.
-Jack






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users