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

I Got This Error

a7aa7a

Member
Joined
Jul 5, 2011
Messages
316
Reaction score
13
Hello !
After Hard Work :(


I Got This Error


mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onl
inetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=
players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.on
linetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0; - MYSQL E
RROR: Unknown column 'onlinetime7' in 'field list' (1054)
mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`
=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `ex
phist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experi
ence-players.exphist_lastexp, `exphist_lastexp`=players.experience; - MYSQL ERRO
R: Unknown column 'exphist7' in 'field list' (1054)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)


Anyone Help Me :'( Faaastt
 
SQL:
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';
 
Back
Top