Windows tfs 1.2 Znote Unknown column

[Sp0tl3ss]

hello i get this error on my znote acc website..

• 
  string(93) "SELECT * FROM players WHERE group_id < 2 ORDER BY experience - exphist_lastexp DESC LIMIT 5;"
  (query - SQL error)
  Type: select_multi (select multiple rows from database)
  
  Unknown column 'exphist_lastexp' in 'order clause'

any1 have an idea how to fix it? i know somthign is missing in my database..

 

[Dyabl0]

Have you got column 'exphist_lastexp' in players table?

If no, inside phpmyadmin -> select your database -> sql -> paste:

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

 

[Sp0tl3ss]

Thanks Alot for the help! you dont happend to have this one also?

"

• 
  string(93) "SELECT * FROM players WHERE group_id < 2 AND broadcasting = 1 ORDER BY viewers DESC LIMIT 5;"
  (query - SQL error)
  Type: select_multi (select multiple rows from database)
  
  Unknown column 'broadcasting' in 'where clause'"

 

[Dyabl0]

Try with this:

ALTER TABLE `players`ADD `broadcasting` INT NOT NULL DEFAULT 0;.

 

[Sp0tl3ss]

Try with this:

ALTER TABLE `players`ADD `broadcasting` INT NOT NULL DEFAULT 0;.

thx also workt nice! it got me a new error tho
"

• 
  string(93) "SELECT * FROM players WHERE group_id < 2 AND broadcasting = 1 ORDER BY viewers DESC LIMIT 5;"
  (query - SQL error)
  Type: select_multi (select multiple rows from database)
  
  Unknown column 'viewers' in 'order clause'"

 

[Dyabl0]

The errors are due to implementation of cast system, but your database hasn't got those tables and columns which causes those errors:

ALTER TABLE `players` ADD `viewers` int(11) not null default '0';

 

[Sp0tl3ss]

The errors are due to implementation of cast system, but your database hasn't got those tables and columns which causes those errors:

ALTER TABLE `players` ADD `viewers` int(11) not null default '0';

you are a fuckin saint boy! thx for this fast help! +rep!