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

pliz help !! error znote account

cheka

New Member
Joined
Oct 19, 2011
Messages
13
Reaction score
0
string(131) "INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `activekey`, `flag`) VALUES ('5', '', '1446162897', '601690673', 'cl')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'flag' in 'field list'


10.82
 
Solution
SQL:
alter table `znote_accounts` ADD `flag` VARCHAR(20) NOT NULL;
Query from memory, I think this is about correct. Not entirely sure.

>Add query in phpmyadmin SQL tab after you select the database.

Edit: Thread moved to OpenTibia -> Support board
SQL:
alter table `znote_accounts` ADD `flag` VARCHAR(20) NOT NULL;
Query from memory, I think this is about correct. Not entirely sure.

>Add query in phpmyadmin SQL tab after you select the database.

Edit: Thread moved to OpenTibia -> Support board
 
Solution
string(67) "SELECT `flag` FROM `znote_accounts` WHERE `account_id` = 7 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'flag' in 'field list'
 
Back
Top