Big Problem

[hucko]

I Can't Understand What is that problem to fix it !!! so ,any help ?

sorry for my bad English ..


Note: i run the ot on the computer .............

> Initializing game state modules and registering services...
[09/05/2012 14:56:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT houses.owner,houses.id,players.name FROM houses
[09/05/2012 14:56:50] LEFT JOIN players ON players.id=houses.owner
[09/05/2012 14:56:50] WHERE players.lastlogin < (UNIX_TIMESTAMP() - 14*24*60*60)
[09/05/2012 14:56:50] AND
[09/05/2012 14:56:50] players.world_id =0)
[09/05/2012 14:56:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (DELETE FROM "guild_wars" WHERE "status" = 0 AND "begin" < 1336391810
[09/05/2012 14:56:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (UPDATE "guild_wars" SET "status" = 5, "end" = 1336564610 WHERE "status" = 1 AND "end" > 0 AND "end" < 1336564610
> Initializing game state modules and registering services...
[09/05/2012 14:56:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT houses.owner,houses.id,players.name FROM houses
[09/05/2012 14:56:50] LEFT JOIN players ON players.id=houses.owner
[09/05/2012 14:56:50] WHERE players.lastlogin < (UNIX_TIMESTAMP() - 14*24*60*60)
[09/05/2012 14:56:50] AND
[09/05/2012 14:56:50] players.world_id =0)
[09/05/2012 14:56:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (DELETE FROM "guild_wars" WHERE "status" = 0 AND "begin" < 1336391810
[09/05/2012 14:56:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (UPDATE "guild_wars" SET "status" = 5, "end" = 1336564610 WHERE "status" = 1 AND "end" > 0 AND "end" < 1336564610

and i found this code > Always spamming my TFS 0.3.6 every minute

[09/05/2012 16:09:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login'

 

[hucko]

help ............................!

 

[lawxz]

you must add table z_ots_comunication

 

[hucko]

and HOW i add table z_ots_comunication



Note: i run the ot on the computer .............

 

[hucko]

Bump


Note: i run the ot on the computer .............

 

[hucko]

Bump ....

 

[hucko]

Bump

 

[hucko]

Please any one help me ....

 

[Zaul]

Login to the database and do Create table ots_com blabla bla
Let me google that for you