TFS 0.4 Save player data not work

[Szafi]

Hello i have problem...

MySQL:

config.lua

savePlayerData = true

and player dont save.

/save and more not working.

began to happen after installation Gęsior acc maker 2012

Video:

How to fix?

 

[StreamSide]

why u still using 0.4

 

[Szafi]

why u still using 0.4

My friend add a lot function's and more functions to my engine.

@topic
I look in console

[20:44:53.481] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 22 - MYSQL ERROR: Table 'ots.guild_invites' doesn't exist (1146)
[20:44:53.483] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 22 - MYSQL ERROR: Table 'ots.guild_invites' doesn't exist (1146)
[20:44:53.487] mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 22 - MYSQL ERROR: Table 'ots.guild_invites' doesn't exist (1146)
[20:44:53.488] Error while saving player: God Szafi.

 

[StreamSide]

ots.guild_invites doesnt exist

 

[Szafi]

ots.guild_invites doesnt exist

How to can fix? Where i found this table? I reinstall acc maker - not work.

 

[StreamSide]

CREATE TABLE `guild_invites`
(
    `player_id` INT NOT NULL DEFAULT 0,
    `guild_id` INT NOT NULL DEFAULT 0,
    UNIQUE (`player_id`, `guild_id`),
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

with search buttom

 

[Szafi]

CREATE TABLE `guild_invites`
(
    `player_id` INT NOT NULL DEFAULT 0,
    `guild_id` INT NOT NULL DEFAULT 0,
    UNIQUE (`player_id`, `guild_id`),
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

with search buttom

Cant create

2013 - Lost connection to MySQL server during query

@edit
for again run sql question

#1146 - Table 'ots.guild_invites' doesn't exist

@edit2

#1005 - Can't create table 'ots.guild_invites' (errno: 150)

@edit3
i go sleep, i try tomorrow and say. 14h to make OT, my head do not thoughts

 

[StreamSide]

try with another db

 

[Szafi]

Sloved:

shutdown tfs

service mysql restart

or

shutdown -r now

run MySQL

DROP TABLE IF EXISTS `guild_invites`

and

CREATE TABLE `guild_invites`
(
`player_id` INT NOT NULL DEFAULT 0,
`guild_id` INT NOT NULL DEFAULT 0,
UNIQUE (`player_id`, `guild_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Thanks