Solved This Thing Appeared Recently

[Black Dove]

I Dunno What Is That But It Hadn't Been Before
It Suddenly Appear And Dunno If It's a Bug Or What And Also Don't Know How Could I Fix It Hope You Help Me

[01/06/2014 11:12:22] 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/2014 11:12:22] 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
[01/06/2014 11:12:23] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[01/06/2014 11:12:23] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login'

Server Is Running Ok But Dunno What Is That !

 

[Frostie]

Add this table to ur database

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

 

[Black Dove]

In " Players " Table ?

 

[Himii]

Sql or mysql?

 

[Black Dove]

@Himii
Sqlite ..
Using
SQLite Database Browser 2.0 b1.exe

 

[Black Dove]

Awki I Solved It
ThanQ @Frostie For Your Instructions
ThanQ "My Developer" For Editing And Fixing
---------------------------------------------------
Its 2 Bugs

1#

[01/06/2014 11:12:22] 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/2014 11:12:22] 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
[01/06/2014 11:12:23] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1

This One Require Adding These Tables :-

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ALTER TABLE `players` ADD`ALTER TABLE `players` ADD`onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD`onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0';

It Works 100%

Second Part

[01/06/2014 11:12:23] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login'

Its Because I Got Globalevents.xml/Shop.lua
And As My Developer Explanation He Told Me You Don't Got The Tables That This Script Need So You Have To Deacvtivated

So Now After Doing It The Error Removed