• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC Znote Error

Dojjjaaan

New Member
Joined
Jan 26, 2018
Messages
3
Reaction score
0
Hey Guys. When I try to creat an account on my Znote site I get this error.


string(51) "SELECT `id` FROM `accounts` WHERE `name`='5260680';"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'name' in 'where clause'


any ideas how to fix it ? :)
 
Using a retro distribution?
Change `name` to `id`

It tries to find account by looking at account name. But old distributions/clients use account number, which is using account.id column. These databases often don't have the "name" column in account table.
 
On what URL did you get that error message?
And where did you get the Znote AAC files from?
Did this error occur after you did some modifications, like changing layout?

It is hard for me to pinpoint where you need to edit unless I get this information.
 
Ahh yes, Znote AAC Supports TFS version 0.2.13 or higher, 0.2.8 is a bit too old.

Why have you chosen Mystic Spirit 0.2.8? There might be a better alternative out there that is more supported.

ZnoteAAC/register.php at master · Znote/ZnoteAAC · GitHub
You could try to change this to:
PHP:
'id'        =>    $_POST['username'],
There is most likely many more compatibility issues beside this on the AAC, especially after you login to an account.
 
Back
Top