Solved Znote AAC - error at login

SamX · Dec 22, 2016

I'm getting the following error when trying to login on my website. Using latest version of Znote from Github.

Code:

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

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

Thanks.

StreamSide · Dec 22, 2016

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

SamX · Dec 22, 2016

StreamSide said:
Unknown column 'za.secret' in 'field list'

Any ideas how to fix it?

Znote · Dec 23, 2016

If using TFS 1.2:
Start the OT server.
Close the OT server.

See if you still have an error.

SamX · Dec 24, 2016

Znote said:
If using TFS 1.2:
Start the OT server.
Close the OT server.

See if you still have an error.

I'm still getting the error. Tried to restart it multiple times.

dartedd450 · Dec 24, 2016

SamX said:
I'm still getting the error. Tried to restart it multiple times.

Try this

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

SamX · Dec 24, 2016

dartedd450 said:
Try this

Tried that, still getting the same error

dartedd450 · Dec 24, 2016

At the start when you first set up ur AAC and haven't linked your DB, you usually get an error code with a window telling you to copy+paste a code in your db SQL... Did you do that at the start?

SamX · Dec 24, 2016

dartedd450 said:
At the start when you first set up ur AAC and haven't linked your DB, you usually get an error code with a window telling you to copy+paste a code in your db SQL... Did you do that at the start?

Yup, that's all done. Tried it again just incase, didn't work.

Znote · Dec 27, 2016

Updating Znote AAC from previous install?

Code:

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

Cornex · Dec 27, 2016

Code:

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

SamX · Dec 27, 2016

Znote said:
Updating Znote AAC from previous install?

Code:

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

That worked, cheers.

Solved Znote AAC - error at login

SamX

VoltageOT Developer

Znote

StreamSide

Joseluis Gonzalez

SamX

VoltageOT Developer

Znote

<?php echo $title; ?>

SamX

VoltageOT Developer

dartedd450

Member

SamX

VoltageOT Developer

dartedd450

Member

SamX

VoltageOT Developer

Znote

<?php echo $title; ?>

Cornex

Web Developer

SamX

VoltageOT Developer

Similar threads