• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

s3db database problem! pls help

Y

yompe

New Member
Joined
Jan 19, 2010
Messages
16
Reaction score
0
Code: 
[09/04/2011 21:13:33] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 8 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 432000;)
[09/04/2011 21:13:33] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 1000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 1728000;)
[09/04/2011 21:13:33] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 5000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 2592000;)
[09/04/2011 21:13:33] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 10000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 5184000;)
[09/04/2011 21:13:33] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 150000 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 7776000;)

can some one make a short guide how to fix this

and this error how to fix?
Code: 
[10/04/2011 09:19:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
 
Last edited:
Back
Top