• 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'
 

marek12

Available for sprite works
Joined
Apr 8, 2020
Messages
385
Solutions
4
Reaction score
344
ALTER TABLE `znote_accounts` ADD `active_email` TINYINT(4) NOT NULL DEFAULT '0' AFTER `active`;

run query
 
OP
OP
CoolBuys1290

CoolBuys1290

Member
Joined
Aug 23, 2018
Messages
80
Reaction score
8
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'
 

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,947
Solutions
252
Reaction score
1,890
Location
Norway
GitHub
Znote
You are missing the email column from the accounts table. Which is odd, which OT server are you using?
 
Top