[SQL] Error

[thebeck]

Hey guys i'm using UniformServer and after install all, these error appeared on my startup:

[19:9:02.093] mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onl
inetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4,
`onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetim
e2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday
`=0; - MYSQL ERROR: Unknown column 'onlinetime7' in 'field list' (1054)
[19:9:02.093] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphis
t6, `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' (1054)
[19:9:02.093] 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)
[19:10:02.140] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=player
s.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` =
1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

what shoul I do :s

 

[Chris]

ALTER TABLE `players` ADD `onlinetime7` INT(11) DEFAULT 0;
ALTER TABLE `players` ADD `exphist7` INT(11) DEFAULT 0;
ALTER TABLE `players` ADD `onlinetimetoday` INT(11) DEFAULT 0;

 

[thebeck]

I had graphics on gesior that represents the exp history of last 7 days on the characters page , time online etc. I think that's it but what's the solution? ^^

 

[Chris]

You're correct. Although the errors you posted above are not caused by Gesior or its subscripts, but rather a LUA script found within your ./data/ folder. The solution is the three queries in my previous post. Execute them through phpMyAdmin (or whatever other database manager you might be using).