Problem with acc manager?

[JayBeee]

When I create a character with acc manager and then try to change the account number in the database, I get this error:

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

Is it something that's wrong with the database or the account manager? I've got no idea.

 

[ntmr]

It's the database.

The field "id" in the "accounts" table is directly linked to the field "account_id" in the "players" table, I think that there is no way to change.

 

[Jester]

Try to make again the database if you don't lose too much, I mean if you don't have the ot online. I had such errors once, and I droped my database and downloaded again theforgottenserver.sql and worked fine.

 

[Mark]

You cannot change the account number of a player to an account that doesn't exist. Make sure that the account exists first.

 

[jamil]

just create a new "account" first, like a dublication of the other acc.
Then change the acc number (and the acc id ofc).
Now you will be able to change the account id from "players" for the new acc.

Then, you can delete the old acc.

 

[xxgoosexx]

if you are doing mysql from the command line, just do

set foreign_key_checks=0;

and then you can update your account number in players/accounts

UPDATE `players` SET `account_id` = newacc# WHERE `account_id` = oldacc# ;
UPDATE `accounts` SET `id` = newacc# WHERE `id` = oldacc# ;

i think the variables are right, then when you are done put the checks back on

set foreign_key_checks=1;