what is wrong here?

[Silentsniper]

Everytime i start up the server, this message appears continously on the console.

[26/04/2011 16:33:39] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'forgotten.z_ots_comunication' doesn't exist (1146)
[26/04/2011 16:34:09] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

Any solution?

 

[Gurrha]

you should get the mysql data for shop!

 

[Gurrha]

http://otland.net/f118/ver-0-1-0-gesior-item-pacc-shop-php-lua-forgotten-server-5772/
rep me

 

[Silentsniper]

ok it fixed the first issue but how to i fix
[26/04/2011 21:17:41] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

 

[Silentsniper]

bump =]

 

[Feloth]

Don't bump unless 24hours has passed.

 

[Archez]

Execute this:

ALTER TABLE `players` ADD `onlinetimetoday` int(16);

Forget it, one query won't be enough, check Cykotitan's second link. \/

 

[Cykotitan]

http://otland.net/f16/how-do-i-add-otserv-z_ots_comunication-tabels-my-admin-php-115424/#post1140606
http://otland.net/f118/gesior-acc-m...wergamers-online-time-stats-44762/#post451902