AAC delete charater bug myaac

[antonio664]

[Error - mysql_real_query] Query: DELETE FROM players WHERE deletion != 0 AND deletion < 1607516326
Message: Cannot delete or update a parent row: a foreign key constraint fails (databaseOT.quickloot_containers, CONSTRAINT fk_quickloot_containers_player_id FOREIGN KEY (player_id) REFERENCES players (id))


It did not give this problem, until recently.

TFS 1.3
MYAAC

 

[jonasu]

Your quickloot edit is causing this problem. You can't delete player since it has a child entry in the quickloot_containers table. Check with the provider of that script how you should implement this correctly. I did find below after a quick search.

MySQL - Delete row that has a foreign key constraint which reference to itself

I have a table in which I store all the forum messages posted by the users on my website. The messages hierarchy strucrue is implement using a Nested set model. The following is a simplified stru...

dba.stackexchange.com

Seems like you need to change the query for deletion in myaac, adding ORDER BY nleft DESC;
PLEASE TEST BEFORE TRYING THIS ON PRODUCTION DATABASE, YOU HAVE BEEN WARNED