Help With Sql Error

[oOIOo]

i have that Errors in Server it appear after my update to the server



what i do ?

 

[Lares]

Unknown column 'onlinetimetoday'

U must add this column to database.

 

[oOIOo]

how to fix it please

 

[JoccE]

Seams like you are using a 0.3 database with a 0.2 server or something like that

 

[oOIOo]

iam using database of server 8.5 with one of server 8.55

 

[sorcerers king]

Yeah here is the proplem.

 

[Cykotitan]

Execute SQL queries:

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';

UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

 

[Lares]

Yep in 8.55 ad maybe 8.54 probably are new columns in database and u must add this queries manual.

 

[Gramwsloneczko]

@Lares
It's not basically in TFS, it's just addon made by Gesior?