Help! My server's VIP List is bugged!

[zieworski denero]

Hello all. I don't know, but I think my vip list is bugged... this is what i get in my gui:

[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:

You must execute this sql code in your database :

DROP TABLE IF EXISTS `player_viplist`;

And after that you must execute this 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!

 

[zieworski denero]

And when i went to localhost, and to player_vip, this appears:

Fel

SQL-fråga: Ändra

SHOW INDEX FROM `player_viplist` ;

MySQL sa: Dokumentation
#145 - Table '.\otserv\player_viplist' is marked as crashed and should be repaired

 

[zieworski denero]

bump

 

[Kodis]

dont bump within 24hours ;(

 

[zieworski denero]

:/ anyone?

 

[Darad]

Tried google?

 

[JDB]

Your servers VIP is messed up?
That is weird, my VIP has never messed up on TFS.

 

[SpiderOT]

open phpmyadmin then click on player_viplist then operations under Table maintenance
you will find repair table click it
i think this will help not sure

 

[zieworski denero]

Didn't work :/

very strange...

 

[SpiderOT]

well you better drop it and import other one but all vip list will be deleted

 

[zieworski denero]

but if i drop it, won't all the characters be deleted?

 

[zieworski denero]

anyone`?

 

[pawelzion]

don't drop it , clean this table

 

[zieworski denero]

what do you mean?;O

 

[zieworski denero]

Look

 

[zieworski denero]

Solved!

You must execute this sql code in your database :

DROP TABLE IF EXISTS `player_viplist`;

And after that you must execute this 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;