Storage Problem On my OT!

[GM FaithFull]

Ok so every time a player relogs, it brings him back to temple and tells him to choose a outfit, just as if he started from scratch.
Not even the items save nothing saves.
I don't know how to fix this is what happens when a player logs out



[19/3/2017 4:9:10] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES (13, 1, 101, 2323, 1, ''),(13, 3, 102, 1988, 1, ''),(13, 4, 103, 8871, 1, ''),(13, 5, 104, 7730, 1, ''),(13, 6, 105, 2195, 1, ''),(13, 10, 106, 8902, 1, ''),(13, 102, 107, 2261, 1, ''),(13, 102, 108, 2305, 1, ''),(13, 102, 109, 2789, 100, 'd'),(13, 102, 110, 2420, 1, ''),(13, 102, 111, 2278, 1, ''),(13, 102, 112, 2269, 1, ''),(13, 102, 113, 2293, 1, ''),(13, 102, 114, 7590, 1, ''),(13, 102, 115, 2273, 1, ''),(13, 102, 116, 2268, 1, ''),(13, 102, 117, 2183, 1, '') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`baiak860`.`player_items`, CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `01players` (`id`) ON DELETE CASCADE) (1452)
[19/3/2017 4:9:10] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES (13, 1, 101, 2323, 1, ''),(13, 3, 102, 1988, 1, ''),(13, 4, 103, 8871, 1, ''),(13, 5, 104, 7730, 1, ''),(13, 6, 105, 2195, 1, ''),(13, 10, 106, 8902, 1, ''),(13, 102, 107, 2261, 1, ''),(13, 102, 108, 2305, 1, ''),(13, 102, 109, 2789, 100, 'd'),(13, 102, 110, 2420, 1, ''),(13, 102, 111, 2278, 1, ''),(13, 102, 112, 2269, 1, ''),(13, 102, 113, 2293, 1, ''),(13, 102, 114, 7590, 1, ''),(13, 102, 115, 2273, 1, ''),(13, 102, 116, 2268, 1, ''),(13, 102, 117, 2183, 1, '') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`baiak860`.`player_items`, CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `01players` (`id`) ON DELETE CASCADE) (1452)
[19/3/2017 4:9:10] mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES (13, 1, 101, 2323, 1, ''),(13, 3, 102, 1988, 1, ''),(13, 4, 103, 8871, 1, ''),(13, 5, 104, 7730, 1, ''),(13, 6, 105, 2195, 1, ''),(13, 10, 106, 8902, 1, ''),(13, 102, 107, 2261, 1, ''),(13, 102, 108, 2305, 1, ''),(13, 102, 109, 2789, 100, 'd'),(13, 102, 110, 2420, 1, ''),(13, 102, 111, 2278, 1, ''),(13, 102, 112, 2269, 1, ''),(13, 102, 113, 2293, 1, ''),(13, 102, 114, 7590, 1, ''),(13, 102, 115, 2273, 1, ''),(13, 102, 116, 2268, 1, ''),(13, 102, 117, 2183, 1, '') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`baiak860`.`player_items`, CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `01players` (`id`) ON DELETE CASCADE) (1452)
[19/3/2017 4:9:10] Error while saving player: Tests.


any help please?

 

[WibbenZ]

Please read the rules; Rules for the Support board
#5, #7 (use code tags, easier to read)

Have you modified your source code or your database?
Are you using the correct TFS with the correct database schema?

 

[GM FaithFull]

Yes everything was working great, i don't know what happened and yeah i'm sorry i'm new here i don't know what happened but everything was working good. The server is running on a linux based. [TFS] Revisado por Chaitosoft.com - a sua loja de otserv 0.4_DEV

 

[GM FaithFull]

Fixed, no more help XD

 

[Amiroslo]

Fixed, no more help XD

you might want to share how

 

[GM FaithFull]

Well I just had to upload a new database, that fixed the issue, problem is lost all accounts, but it's new server so no problem