• 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 AAC SQL Problem

CoolBuys1290

Member
Joined
Aug 23, 2018
Messages
80
Reaction score
8
When I try to register, I get this error:
string(69) "SELECT id FROM accounts WHERE email='[email protected]';"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'email' in 'where clause'
 
ALTER TABLE `znote_accounts` ADD `active_email` TINYINT(4) NOT NULL DEFAULT '0' AFTER `active`;

run query
 
Error
SQL query: Copy




ALTER TABLE znote_accounts ADD active_email TINYINT(4) NOT NULL DEFAULT '0' AFTER active





MySQL said: Documentation

#1060 - Duplicate column name 'active_email'
 
You are missing the email column from the accounts table. Which is odd, which OT server are you using?
 
Back
Top