error on login account website ZNOTE ACC

[wafuboe]

i get this error on the website when loggin on an account


string(183) "SELECT `a`.`secret` AS `secret`, `za`.`secret` AS `znote_secret` FROM `accounts` AS `a` INNER JOIN `znote_accounts` AS `za` ON `a`.`id` = `za`.`account_id` WHERE `a`.`id`='5' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'a.secret' in 'field list'

any ideas?

 

[Infernum]

make sure the server is on

 

[Amiroslo]

try
ALTER TABLE `accounts` ADD COLUMN `secret` CHAR(16) NULL AFTER `password`;

 

[wafuboe]

still the same :/

 

[wafuboe]

solved, tfs updated the databse thanks