Solved Player_Storage bug

[ariyan]

Hi,

I got this bug that's really weird and i don't know how to fix it.
I currently got some players playing on my server and i don't want anything to happen to the database cause the players will get pissed off at me.

If someone could help me with this bug i'd appericiate it very much.

Here's a pic of the bug that happens in TFS.


Thanks!

 

[Loney]

Maybe you have something wrong in the player_storage table. Delete player_storage table and run this query at PMA:

CREATE TABLE `player_storage`
(
	`player_id` INT NOT NULL DEFAULT 0,
	`key` INT UNSIGNED NOT NULL DEFAULT 0,
	`value` VARCHAR(255) NOT NULL DEFAULT '0',
	KEY (`player_id`), UNIQUE (`player_id`, `key`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Your server must be offline.

 

[ariyan]

Maybe you have something wrong in the player_storage table. Delete player_storage table and run this query at PMA:

CREATE TABLE `player_storage`
(
	`player_id` INT NOT NULL DEFAULT 0,
	`key` INT UNSIGNED NOT NULL DEFAULT 0,
	`value` VARCHAR(255) NOT NULL DEFAULT '0',
	KEY (`player_id`), UNIQUE (`player_id`, `key`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Your server must be offline.

thanks i'll try this in 15 minutes!

- - - Updated - - -

Maybe you have something wrong in the player_storage table. Delete player_storage table and run this query at PMA:

CREATE TABLE `player_storage`
(
	`player_id` INT NOT NULL DEFAULT 0,
	`key` INT UNSIGNED NOT NULL DEFAULT 0,
	`value` VARCHAR(255) NOT NULL DEFAULT '0',
	KEY (`player_id`), UNIQUE (`player_id`, `key`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Your server must be offline.

I think that the bug has been fixed, i'm not sure but thanks!!!
Yea it has been fixed thank you!