• 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!

have small problem with database

God Mythera

God Mythera

Veteran OT User
Joined
Aug 11, 2012
Messages
2,051
Solutions
2
Reaction score
260
Location
United States
hello i keep getting this error how can i fix it?

Code: 
[09/09/2012 13:04:41] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

and also this error

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

Rep++ for help!!!
 
Sort by date Sort by votes
made by you database have columns z_ots_comunications and onlinettime, remove tables
I remember is only for SQL ..
you use SQLite not?
you dont have this in globalevents.xml script onlinetime?
 
Last edited:
Upvote 0 Downvote
Back
Top