Znote Acc Tfs 1.0 sql error

Klonera

Once upon a time.
Joined
Jul 16, 2016
Messages
359
Reaction score
36
Location
Sweden
string(322) "SELECT `account_id`, `town_id`, `name`, `level`, `group_id`, `vocation`, `health`, `healthmax`, `experience`, `mana`, `manamax`, `sex`, `lastlogin`, `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7` FROM `players` WHERE `id` = 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'exphist1' in 'field list'
 

Rexxar

of Unimatrix Zero-One
Joined
Jun 4, 2009
Messages
872
Reaction score
34
Location
Narnia
Looks like you are using a version of Znote that is incompatible with whatever server you are using.

It means the website is trying to access data from the column exphist1 in your players database, but that column doesn't exist.

So either add it to the database, or change the website code so it doesn't try to access it. Or change account manager all together.
 

Shadow_

asgard-ot.com
Premium User
Joined
Jun 2, 2018
Messages
298
Reaction score
57
Location
Cairo, Egypt
just excute this in sql of the database you are using
Code:
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';
then this one
Code:
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`
 
Top