- Joined
- Jun 19, 2009
- Messages
- 1,852
- Reaction score
- 5
Hello all. I don't know, but I think my vip list is bugged... this is what i get in my gui:
This is what i get... my server won't save my players :S anyone knows how to fix it?
[SOLVED]
How to solve:
Thank you pawel!
[18/08/2009 13:32:22] mysql_real_query(): DELETE FROM `player_viplist` WHERE `player_id` = 2032; - MYSQL ERROR: Table '.\otserv\player_viplist' is marked as crashed and should be repaired (145)
Error while saving player: <playername>
This is what i get... my server won't save my players :S anyone knows how to fix it?
[SOLVED]
How to solve:
pawelzion said:You must execute this sql code in your database :
Code:DROP TABLE IF EXISTS `player_viplist`;
And after that you must execute this code :
Code:CREATE TABLE `player_viplist` ( `player_id` INT NOT NULL COMMENT 'id of player whose viplist entry it is', `vip_id` INT NOT NULL COMMENT 'id of target player of viplist entry', FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE, FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB;
Thank you pawel!
Last edited: