Solved cannot login mysql error

[Gunmetalx]

The Forgotten Server - Version 1.2
Compiled with Microsoft Visual C++ version 14.0
Compiled on Sep 9 2016 20:28:10 for platform x86

A server developed by Mark Samman
Visit our forum for updates, support, and resources: http://otland.net/.

>> Loading config
>> Establishing database connection... MySQL 6.1.2
>> Running database manager
>> Loading vocations
>> Loading items
[Warning - Items::parseItemNode] Unknown floorChange: eastex
[Warning - Items::parseItemNode] Unknown floorChange: southex
>> Loading script systems
>> Loading monsters
>> Loading outfits
>> Checking world type... PVP
>> Loading map
> Map size: 33760x33023.
> Map loading time: 8.46 seconds.
>> Initializing gamestate
>> Loaded 786 npcs and spawned 52816 monsters.
>> Loaded 20 towns with 1037 houses in total.
>> Loaded all modules, server starting up...
>> Forgotten Server Online!

> Broadcasted message: "Hunters on the hunt north of the Green Claw Swamp.".
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `secret`, `ty
pe`, `premdays`, `lastday` FROM `accounts` WHERE `name` = '1'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `secret`, `
type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = '1'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `secret`, `ty
pe`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'gunmetal89'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `secret`, `
type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'gunmetal89'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `secret`, `ty
pe`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'gunmetal89'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `secret`, `
type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'gunmetal89'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `secret`, `ty
pe`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'gunmetal89'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `secret`, `
type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'gunmetal89'
Message: Unknown column 'secret' in 'field list'

Tried logging in multiple times, always getting that error each time

 

[Gunmetalx]

Figured it out, went to phpadmin and selected my database and i clicked SQL and ran this query

ALTER TABLE `accounts`ADD `secret` varchar(255);

 

[japolekk94]

thank u bro is working <3