Solved Znote AAC issue

[yuitsi2]

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`='1' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

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

I've encountered this error when I am trying to logg in to an account. Does anyone know how to fix the issue?

 

[Eazy154]

Im having the exact same error :/

Edit: Found the solution by Xeraphus, you have to add the Code in your mySQL:

Code:
ALTER TABLE `accounts` ADD `secret` int(11);

 

[Cornex]

Im having the exact same error :/

Edit: Found the solution by Xeraphus, you have to add the Code in your mySQL:

Code:
ALTER TABLE `accounts` ADD `secret` int(11);

The type should be char(16) and defaults to null.

ALTER TABLE `accounts` ADD `secret` CHAR(16) DEFAULT NULL;

 

[d03n3r]

Hello,
I have the same error :-(

But where do I have to put the code "
ALTER TABLE `accounts` ADD `secret` CHAR(16) DEFAULT NULL;" you say " in your mySQL" but where I can find it?

 

[StreamSide]

Hello,
I have the same error :-(

But where do I have to put the code "
ALTER TABLE `accounts` ADD `secret` CHAR(16) DEFAULT NULL;" you say " in your mySQL" but where I can find it?

you have to execute that query on ur db

 

[Tarek]

Hello,
I have the same error :-(

But where do I have to put the code "
ALTER TABLE `accounts` ADD `secret` CHAR(16) DEFAULT NULL;" you say " in your mySQL" but where I can find it?

If you are using TFS 1.3/1.2 launch tfs once then the error should be gone.

 

[d03n3r]

Fixed it, thanks guys!