• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC delete charater bug myaac

antonio664

Member
Joined
Jan 9, 2013
Messages
121
Reaction score
5
[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

Active Member
Joined
Nov 3, 2009
Messages
131
Solutions
1
Reaction score
32
Location
Stockholm, Sweden
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.


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
 
Top