• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

getting some errors when starting server

tyngaste

New Member
Joined
Dec 2, 2008
Messages
223
Reaction score
0
Location
Sweden
[20/02/2009 17:38:31] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:38:31] mysql_real_query(): 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;: MYSQL ERROR: Unknown column 'onlinetime7' in 'field list'
[20/02/2009 17:38:31] mysql_real_query(): 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;: MYSQL ERROR: Unknown column 'exphist7' in 'field list'
[20/02/2009 17:38:31] 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'
[20/02/2009 17:39:02] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:39:32] 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'
[20/02/2009 17:39:33] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:40:04] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:40:33] 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'
[20/02/2009 17:40:35] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:41:06] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:41:34] 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'
[20/02/2009 17:41:37] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:42:08] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:42:35] 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'
[20/02/2009 17:42:39] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:43:10] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:43:36] 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'
[20/02/2009 17:43:41] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:44:12] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:44:30] > Saving server...
[20/02/2009 17:44:37] 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'
[20/02/2009 17:44:37] Preparing shutdown...
[20/02/2009 17:44:37] Exiting> Saving server...
[20/02/2009 17:44:43] Error: generating report file...

help me with this one please
 
Create onlinetimetoday in your players table structure.

Well, reinstall all gesior.pls scripts. You are missing more than just one field.
 
Back
Top