Help i've got error spamming my serverlog

[Moataz Hero]

Hello everyone
i am got error and this error spamming in my serverlog and its make the column sucks and making the ot laggy i hope someone help me :< i'll show u the error i got

28/05/2011 23:11:09] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[28/05/2011 23:11:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

Help me

 

[Kyran]

You're missing a table in your database, create the table and problem will be solved

 

[Cykotitan]

and try to use mysql not sqlite

 

[Moataz Hero]

You're missing a table in your database, create the table and problem will be solved

where is that table? need more explain how to that problem to be solved

and try to use mysql not sqlite

already and bugg still >.<
and the new problem with vip
when i loggin with vip look

[28/05/2011 23:32:01] Owner Moataz has logged in.
[28/05/2011 23:32:01] Error during getDataInt(vipdays).
[28/05/2011 23:32:01] Error during getDataInt(vipdays).
[28/05/2011 23:32:04] Error during getDataInt(vipdays).
[28/05/2011 23:32:07] Error during getDataInt(vipdays).
[28/05/2011 23:32:10] Error during getDataInt(vipdays).

really need help fast!

 

[Wymietek]

Install gesior or remove shop script (in global events).
About vip just show us script...

 

[Moataz Hero]

Install gesior or remove shop script (in global events).
About vip just show us script...

bro i removed shop script and the problem still >.<

look this
i think this is the problem of onlinetime , what i make for i fix this?

[29/05/2011 00:32:17] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP ( SELECT houses.owner,houses.id,players.name FROM houses
[29/05/2011 00:32:17]                 LEFT JOIN players ON players.id=houses.owner
[29/05/2011 00:32:17]                 WHERE players.lastlogin < (UNIX_TIMESTAMP() - 14*24*60*60)
[29/05/2011 00:32:17]                 AND
[29/05/2011 00:32:17]                 players.world_id =0)

 

[Moataz Hero]

Bump someone Help me!!

 

[Moataz Hero]

Bump

 

[Moataz Hero]

Bump!!!!!!

 

[Moataz Hero]

No one help in otland ???

 

[Mattt]

You can only bump once every 24 hours.

 

[Moataz Hero]

Bump

 

[Moataz Hero]

Help!!!!!!!!!!!!!

 

[Moataz Hero]

[01/06/2011 00:28:35] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
[01/06/2011 00:28:35] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)

HELP!!!

 

[Cyro]

Still Not Fixed? :S