Ive got a problem, is that i downloaded the TFS 8.5 GUI and the server is OK, I use SQLite but... when i log in, players dont save when they logout: here i got a copy of the error:
[10/07/2009 20:10:59] SQLITE ERROR sqlite_exec: UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1247271059 WHERE `id` = 782822 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:10:59] > ERROR: Failed to save account: xxxxxx (xd its my acc, I use it for all, srry)!
[10/07/2009 20:11:00] God Vannaril has logged in.
[10/07/2009 20:11:00] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] God Vannaril has logged out.
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 8, `group_id` = 3, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 1176, `posy` = 1543, `posz` = 7, `cap` = 10000, `sex` = 1, `lastlogin` = 1247271060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1247271062, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 8, `group_id` = 3, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 1176, `posy` = 1543, `posz` = 7, `cap` = 10000, `sex` = 1, `lastlogin` = 1247271060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1247271062, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 8, `group_id` = 3, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 1176, `posy` = 1543, `posz` = 7, `cap` = 10000, `sex` = 1, `lastlogin` = 1247271060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1247271062, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] Error while saving player: God Vannaril
[10/07/2009 20:11:03] God Vannaril has logged in.
[10/07/2009 20:11:03] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:10:59] SQLITE ERROR sqlite_exec: UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1247271059 WHERE `id` = 782822 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:10:59] > ERROR: Failed to save account: xxxxxx (xd its my acc, I use it for all, srry)!
[10/07/2009 20:11:00] God Vannaril has logged in.
[10/07/2009 20:11:00] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] God Vannaril has logged out.
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 8, `group_id` = 3, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 1176, `posy` = 1543, `posz` = 7, `cap` = 10000, `sex` = 1, `lastlogin` = 1247271060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1247271062, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 8, `group_id` = 3, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 1176, `posy` = 1543, `posz` = 7, `cap` = 10000, `sex` = 1, `lastlogin` = 1247271060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1247271062, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 8, `group_id` = 3, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 1176, `posy` = 1543, `posz` = 7, `cap` = 10000, `sex` = 1, `lastlogin` = 1247271060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1247271062, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[10/07/2009 20:11:02] Error while saving player: God Vannaril
[10/07/2009 20:11:03] God Vannaril has logged in.
[10/07/2009 20:11:03] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
