Error while saving player!!!, need help plzzzzz

[prencisa]

when i open char and make items or move then relog can't find the items and i back to first place i looged on
need help plzz.
i get this msg in otsever logs

sqlite3_prepare_v2(): SQLITE ERROR: near "''": syntax error (UPDATE "players" SET "lastlogin" = 1355586316, "lastip" = 1391145482, "level" = 300, "group_id" = 4, "health" = 2000, "healthmax" = 3000, "experience" = 441084800, "lookbody" = 68, "lookfeet" = 76, "lookhead" = 78, "looklegs" = 39, "looktype" = 75, "lookaddons" = 0, "lookmount" = 0, "maglevel" = 150, "mana" = 5000, "manamax" = 55000, "manaspent" = 0, "soul" = 100, "town_id" = 2, "posx" = 154, "posy" = 46, "posz" = 7, "cap" = 900, "sex" = 0, "balance" = 0, "stamina" = 151200000, "skull" = 0, "skulltime" = 0, "promotion" = 0, "conditions" = x'', "loss_experience" = 100, "loss_mana" = 100, "loss_skills" = 100, "loss_containers" = 100, "loss_items" = 100, "lastlogout" = 1355586323, "blessings" = 0, "pvp_blessing" = 0, "offlinetraining_time" = 43200, "offlinetraining_skill" = -1, "marriage" = 0,
Error while saving player (name of my char).

 

[Loney]

TFS version?

 

[prencisa]

9.7

- - - Updated - - -

Otxserver 2.42

 

[Byrackarn]

I use 8.60 tfs 0.3.6
Mysql also.
I have error while save player also
Check my thread

- - - Updated - - -

I use 8.60 tfs 0.3.6
Mysql also.
I have error while save player also
Check my thread

 

[jo31_99]

Execute this

-- ---------------------------- 
-- Table structure for `bans` 
-- ---------------------------- 
DROP TABLE IF EXISTS `bans`; 
CREATE TABLE `bans` ( 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion', 
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number', 
  `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)', 
  `active` tinyint(1) NOT NULL DEFAULT '1', 
  `expires` int(11) NOT NULL, 
  `added` int(10) unsigned NOT NULL, 
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0', 
  `comment` text NOT NULL, 
  `reason` int(10) unsigned NOT NULL DEFAULT '0', 
  `action` int(10) unsigned NOT NULL DEFAULT '0', 
  `statement` varchar(255) NOT NULL DEFAULT '', 
  PRIMARY KEY (`id`), 
  KEY `type` (`type`,`value`), 
  KEY `active` (`active`) 
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

-- ---------------------------- 
-- Records of bans 
-- ---------------------------- 


-- ---------------------------- 
-- Table structure for `player_depotitems` 
-- ---------------------------- 
DROP TABLE IF EXISTS `player_depotitems`; 
CREATE TABLE `player_depotitems` ( 
  `player_id` int(11) NOT NULL, 
  `sid` int(11) NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots', 
  `pid` int(11) NOT NULL DEFAULT '0', 
  `itemtype` int(11) NOT NULL, 
  `count` int(11) NOT NULL DEFAULT '0', 
  `attributes` blob NOT NULL, 
  UNIQUE KEY `player_id_2` (`player_id`,`sid`), 
  KEY `player_id` (`player_id`), 
  CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE 
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

-- ---------------------------- 
-- Records of player_depotitems 
-- ----------------------------

- - - Updated - - -

Execute this

-- ---------------------------- 
-- Table structure for `bans` 
-- ---------------------------- 
DROP TABLE IF EXISTS `bans`; 
CREATE TABLE `bans` ( 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion', 
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number', 
  `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)', 
  `active` tinyint(1) NOT NULL DEFAULT '1', 
  `expires` int(11) NOT NULL, 
  `added` int(10) unsigned NOT NULL, 
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0', 
  `comment` text NOT NULL, 
  `reason` int(10) unsigned NOT NULL DEFAULT '0', 
  `action` int(10) unsigned NOT NULL DEFAULT '0', 
  `statement` varchar(255) NOT NULL DEFAULT '', 
  PRIMARY KEY (`id`), 
  KEY `type` (`type`,`value`), 
  KEY `active` (`active`) 
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

-- ---------------------------- 
-- Records of bans 
-- ---------------------------- 


-- ---------------------------- 
-- Table structure for `player_depotitems` 
-- ---------------------------- 
DROP TABLE IF EXISTS `player_depotitems`; 
CREATE TABLE `player_depotitems` ( 
  `player_id` int(11) NOT NULL, 
  `sid` int(11) NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots', 
  `pid` int(11) NOT NULL DEFAULT '0', 
  `itemtype` int(11) NOT NULL, 
  `count` int(11) NOT NULL DEFAULT '0', 
  `attributes` blob NOT NULL, 
  UNIQUE KEY `player_id_2` (`player_id`,`sid`), 
  KEY `player_id` (`player_id`), 
  CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE 
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

-- ---------------------------- 
-- Records of player_depotitems 
-- ----------------------------

- - - Updated - - -

REP++ if i helped

- - - Updated - - -

REP++ if i helped