save error

[kalleanka39]

hello!nofing is saving on the serv i erros all the time:


SQLITE ERROR sqlite_exec: DELETE FROM `map_store`; no such table: map_store
[02/02/2010 22:55:32] Notice: Map save (binary) took : 0 s


SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 1, `group_id` = 1, `vocation` = 3, `health` = 185, `healthmax` = 185, `experience` = 0, `lookbody` = 44, `lookfeet` = 44, `lookhead` = 44, `looklegs` = 44, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 31, `posy` = 31, `posz` = 7, `cap` = 420, `sex` = 1, `lastlogin` = 1265147192, `lastip` = 2136008529, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1265147195, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 7 LIMIT 1; near "LIMIT": syntax error


plzz some 1 help me!!!

ooo adn its armonia 5.4

 

[Cykotitan]

use mysql instead of sqlite

 

[kalleanka39]

okey do is it alot of work to change it?

 

[Nevalopo]

You need a MYSQL server... There are loads of tutorials on this forum for setting one up.

 

[kalleanka39]

okey thx for the help

 

[zerghel]

For map store just open your s3db file with sqlite studio And change the name to the table tile_store to map_store it worked for me

 

[Cykotitan]

For map store just open your s3db file with sqlite studio And change the name to the table tile_store to map_store it worked for me

it's tile_items, and it can't work since they don't have the same columns.

CREATE TABLE "map_store" (
	"house_id" INTEGER NOT NULL,
	"data" BLOB NOT NULL
)

but you shouldn't use sqlite at all, it's likely to cause issues