Randomly error while saving player

[Elox]

MySQL ERROR mysql_real_query: INSERT INTO `player_viplist` (`player_id`, `vip_id`) VALUES (771, 8),(771, 11),(771, 14),(771, 38),(771, 42),(771, 43),(771, 60),(771, 70),(771, 85),(771, 86),(771, 111),(771, 129),(771, 160),(771, 192),(771, 193),(771, 195),(771, 234),(771, 316),(771, 510),(771, 523),(771, 602),(771, 731),(771, 732),(771, 733),(771, 738),(771, 747),(771, 769),(771, 770),(771, 796),(771, 827),(771, 951),(771, 1054),(771, 1188),(771, 1227),(771, 1382),(771, 1411),(771, 1499) Cannot add or update a child row: a foreign key constraint fails (`tfs/player_viplist`, CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE)
 MySQL ERROR mysql_real_query: INSERT INTO `player_viplist` (`player_id`, `vip_id`) VALUES (771, 8),(771, 11),(771, 14),(771, 38),(771, 42),(771, 43),(771, 60),(771, 70),(771, 85),(771, 86),(771, 111),(771, 129),(771, 160),(771, 192),(771, 193),(771, 195),(771, 234),(771, 316),(771, 510),(771, 523),(771, 602),(771, 731),(771, 732),(771, 733),(771, 738),(771, 747),(771, 769),(771, 770),(771, 796),(771, 827),(771, 951),(771, 1054),(771, 1188),(771, 1227),(771, 1382),(771, 1411),(771, 1499) Cannot add or update a child row: a foreign key constraint fails (`tfs/player_viplist`, CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE)
MySQL ERROR mysql_real_query: INSERT INTO `player_viplist` (`player_id`, `vip_id`) VALUES (771, 8),(771, 11),(771, 14),(771, 38),(771, 42),(771, 43),(771, 60),(771, 70),(771, 85),(771, 86),(771, 111),(771, 129),(771, 160),(771, 192),(771, 193),(771, 195),(771, 234),(771, 316),(771, 510),(771, 523),(771, 602),(771, 731),(771, 732),(771, 733),(771, 738),(771, 747),(771, 769),(771, 770),(771, 796),(771, 827),(771, 951),(771, 1054),(771, 1188),(771, 1227),(771, 1382),(771, 1411),(771, 1499) Cannot add or update a child row: a foreign key constraint fails (`tfs/player_viplist`, CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE)

Error while saving player: Blabla

This happens randomly when people logout sometimes.
Had my OT up running for a little more than a 1 week and this has happen like 6 times now on different characters (Not on the same day).
I'm using TFS 0.2.

Anyone know what the problem could be? And how to fix it?

Thanks in advance. :thumbup:

 

[Chris]

Try, by using the flag editor, edit the group flags by allowing everyone to use the 'Special VIP' and also set the maxvip field to 50 or so.

Oh, by the way - to get hold of the flageditor, just search the download board.

Good luck!

 

[tim26]

error is because otserv can't save vips i prefer delete all players and replace table vip_list or try without delete but i think you must do it

 

[slaw]

@up

Ahh, yea, thats very good solution... I prefer miore peaceful method.

There is something with foreign keys in table `player_viplist` - `player_viplist_ibfk_2`. I quess, you copied table player_viplist_ibfk_2 and named it `player_viplist`.

 

[Elox]

Okay thanks for trying to help.
Going to try the thing with the FLAGEDITOR first, cause I don't want to delete all players. :/

Anyway, how could this have happen? Haven't 'edited' anything in the database.
I've just imported the database.


-Edit-
Can't find a Flageditor, I've searched on the forum but all I find was "Elf's custom flag generator" but the link didn't work.