Error when trying to delete users...

[AscendancyGaming]

Ok, we're purging our member list of folks who've applied, had no contact for quite some time, etc. and hadn't any problems deleting them through the ACP, until we got the following error for 4 of them.....

Server Error

Mysqli statement execute error : Cannot delete or update a parent row: a foreign key constraint fails (`guilda7_xenforo`.`lpsf_response`, CONSTRAINT `lpsf_response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `xf_user` (`user_id`))

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
4. Zend_Db_Adapter_Abstract->delete() in XenForo/DataWriter.php at line 1784
5. XenForo_DataWriter->_delete() in XenForo/DataWriter.php at line 1737
6. XenForo_DataWriter->delete() in XenForo/Controller.php at line 918
7. XenForo_Controller->_deleteData() in XenForo/ControllerAdmin/User.php at line 574
8. XenForo_ControllerAdmin_User->actionDelete() in XenForo/FrontController.php at line 310
9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
10. XenForo_FrontController->run() in /home/guilda7/public_html/admin.php at line 13

There is nothing special about these folks, as they're all just applicants who we've not heard from or anything.
Any idea as to why we cannot remove them?
Thanks in advance for any help on this!

 

[Jake Bunce]

XenForo doesn't use foreign key constraints. You must have added that to your schema. Any particular reason?

If you don't need the constraints then you can just remove them from your schema.

 

[ragtek]

that's probably a bug in the simple forms addon

 

[AscendancyGaming]

Ahh, so if we disable simple forms we can remove them, and then re-enable simple forms?

 

[AscendancyGaming]

Tried disabling Simple forms and still get the same error. It's odd because it's only for 4 people. The other 20 we had no problem deleting at all.

Also, how do I change the Schema? I haven't any idea if we did something inadvertantly.

 

[ragtek]

I don't have the addon, so i can't help you

i've only found several threads with the same problems
http://xenforo.com/community/threads/problem-deleting-members.31769/
http://www.xendach.de/threads/löschen-eines-users.609/

strange that it still isn't fixed
anybody reported it?

 

[Jake Bunce]

Also, how do I change the Schema? I haven't any idea if we did something inadvertantly.

I have never used foreign key constraints. I assume they would be accessible in phpmyadmin.

But ideally you should contact the author of that addon.