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

Znote tfs 1.2 error when login to account (need help) secret column missing

Joriku

Working in the mines, need something?
Joined
Jul 16, 2016
Messages
1,076
Solutions
15
Reaction score
370
Location
Sweden
YouTube
Joriku
Everything else works fine exept when i log in, then i get this
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`='1' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'a.secret' in 'field list'
e090877ea17eb139156243e30ba333e0
 
PHP:
ALTER TABLE `accounts` ADD `secret` CHAR(16) DEFAULT NULL;
string(116) "SELECT `id`, `character_name`, `time` FROM `znote_deleted_characters` WHERE `original_account_id` = 1 AND `done` = 0"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'klonera.znote_deleted_characters' doesn't exist
Gyazo - 076627f0d72cb974df2659377e8a1101.png
 
Back
Top