• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

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,175
Solutions
17
Reaction score
481
Location
Sweden
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