Solved Problem with phpmyadmin (making ot)

[Perfectibia]

Hi,
I got an error in phpmyadmin when I tried to changed character id to 3 (GM)...
The error was:

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


Anyone know what the problem is? I'm quite new to this..


Thx!
Perfectibia

 

[Cornex]

You need to upgrade "group_id" not character id

 

[Perfectibia]

You need to upgrade "group_id" not character id

But that dosnt make me Gm/admin? Well, I already have group_id=3 on my account and on the characher.


EDIT: To make admin/gm I have to change the id on players/"my character" and then change the id from 2 till 3.. thats where the error pops up ;/

 

[Cornex]

But that dosnt make me Gm/admin? Well, I already have group_id=3 on my account and on the characher.


EDIT: To make admin/gm I have to change the id on players/"my character" and then change the id from 2 till 3.. thats where the error pops up ;/

Only change on table "players" and change group_id. 1 is player etc. Change it to 4 that is GM.

 

[Perfectibia]

Only change on table "players" and change group_id. 1 is player etc. Change it to 4 that is GM.

Worked!
4=GM
5=Admin
,right? But okey, I tried it and now I'm able to be Gm.. thx!

 

[Cornex]

Worked!
4=GM
5=Admin
,right? But okey, I tried it and now I'm able to be Gm.. thx!

4=GM
5=Community Manager
6=GOD