• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MySQL saving bugs

ntmr

hi!
Senator
Joined
Jul 7, 2007
Messages
1,835
Reaction score
15
Location
Santa Catarina, Brazil
My server have problems to save some things to the MySQL database.

Code:
> MySQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes` ) VALUES (238,102,110,2311,10,'n\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''n\')' at line 1
> MySQL ERROR mysql_real_query: INSERT INTO `player_depotitems` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes` ) VALUES (161,101,102,2956,1,' »r\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' »r\')' at line 1
> MySQL ERROR mysql_real_query: INSERT INTO `player_depotitems` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes` ) VALUES (182,136,141,2311,10,'n\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''n\')' at line 1
> MySQL ERROR mysql_real_query: INSERT INTO `tile_items` (`tile_id`, `sid` , `pid` , `itemtype` , `count`, `attributes` ) VALUES (1079,1,0,1764,1,'"\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''"\')' at line 1
> MySQL ERROR mysql_real_query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`) VALUES (19,256,'Jah Rootsn\Vajukan\Puman\Hamphreyn\Arto Fairn\Snarf Freakn\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Jah Rootsn\Vajukan\Puman\Hamphreyn\Arto Fairn\Snarf Freakn\')' at line 1
> MySQL ERROR mysql_real_query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`) VALUES (19,256,'Jah Rootsn\Vajukan\Puman\Hamphreyn\Arto Fairn\Snarf Freakn\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Jah Rootsn\Vajukan\Puman\Hamphreyn\Arto Fairn\Snarf Freakn\')' at line 1
> MySQL ERROR mysql_real_query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`) VALUES (19,256,'Jah Rootsn\Vajukan\Puman\Hamphreyn\Arto Fairn\Snarf Freakn\') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Jah Rootsn\Vajukan\Puman\Hamphreyn\Arto Fairn\Snarf Freakn\')' at line 1

Please, fix this :)
 
Yes, i was have somethink like you. You should making really much mysql database BackUp, or your players can be backed. At this moment, i have problem too with houses. Sometimes, players lost all items in houses. And i must making backup.

I hope this is in TFS bugs, or just we are making somethink wrong, or using wrong acc? Don't know. =\
 

Similar threads

Replies
1
Views
118
Back
Top