Mysql Database error

[davidcantu96]

I keep getting this error everytime i want to login on any account. Im not sure what the problem might be please help!

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

> Map size: 32319x32903.
> Map loading time: 0.018 seconds.
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `secret`, `type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'dav999'
Message: Unknown column 'secret' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `secret`, `type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = 'dav999'
Message: Unknown column 'secret' in 'field list'

 

[Codex NG]

It means secret does not exist in your database as a column.

Unknown column 'secret' in 'field list'

 

[davidcantu96]

Well yeah i know that but i should just add it then? and if so, how do I add it? This is strange because yesterday I turned it on and it worked great and now this happened

 

[davidcantu96]

I dont think I need the 'secret' column on the database anyway is there a way I can stop that?

 

[Tarek]

I dont think I need the 'secret' column on the database anyway is there a way I can stop that?

Yes, If you find from where it's being executed and tunring off the event.

 

[Codex NG]

Well yeah i know that but i should just add it then? and if so, how do I add it? This is strange because yesterday I turned it on and it worked great and now this happened

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

 

[davidcantu96]

Thanks it worked!!

 

[davidcantu96]

Yes, If you find from where it's being executed and tunring off the event.

yeah I thought about that too but I guess I prefer adding the column maybe I avoid getting more error later.