Solved Unknown column 'key' in 'field list'

[tev]

Query: SELECT `id`, `vip_time`, `guild_points`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`, `vote` FROM `accounts` WHERE `name` = '1'

SQLSTATE: 42S22
Driver code: 1054
Error message: Unknown column 'key' in 'field list'

 

[Codex NG]

The key column does not exist in the accounts table.

I don't know what the datatype of key would be however, you could just run this query to add it to the table.

ALTER TABLE `accounts` ADD `key` int NOT NULL;

 

[tev]

The key column does not exist in the accounts table.

I don't know what the datatype of key would be however, you could just run this query to add it to the table.

ALTER TABLE `accounts` ADD `key` int NOT NULL;

Solved, thanks!

 

[Archeer17]

Thanks Bro