Windows SQL Error

[Alyhide]

Every once in a while in my server, it does this, any sql command to fix it?

[25/07/2011 15:30:49] 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)

 

[Korrex]

Idk, you could try:

WHERE `players` ADD  `onlinetimetoday` INT NOT NULL();

or smth, i'm not really good with SQL Query's.

 

[Alyhide]

Thank you, It worked

 

[Korrex]

Thank you, It worked

Glad to be of service .