Database errors / SQL

[dratewka2]

When I use any sort of MySQL Browser, when I edit ANYTHING in the database it says this.

#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`otserv/players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE)


What the hell is that? And how do I fix it?
PHPMyadmin does the same thing, and sqlite doesn't work properly, so how do I fix this?

 

[jamil]

That's because you are trying to delete an account that belongs to a "player" in player's directory.

And you cant delete an account that is used, therefore, try to create a new account instead of changing the actual one

 

[dratewka2]

Problem is, my damn account manager gives me an auto account number. =[
But whatever I'll live with it.

 

[jamil]

you should be able to change that in config.lua, so that the acc manager dont generate acc numbers.