MYSQL Got some server errors in the console.

[lindblad88]

As the title says. MYSQL console errors appears in my console when i'm trying to login. How do I fix this?

mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
 mysql_real_query(): SELECT `name` FROM `players` WHERE `account_id` = 9 AND `world_id` = 0 AND `deleted` = 0 - MYSQL ERROR: Unknown column 'deleted' in 'where clause' (1054)
 mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 9 AND `type` = 3 AND `active` = 1 AND (`expires` > 1364771119 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)

- - - Updated - - -

getting this error now:

SELECT * FROM `bans` WHERE `value` = 9 AND `type` = 3 AND `active` = 1 AND (`expires` > 1364772910 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)

any thoughts?

mysqL errors rocks.. oh wait

 

[Ninja]

ALTER TABLE `bans` ADD `value` INT UNSIGNED NOT NULL COMMENT 'ip - ip address, player - player_id, account - account_id, notation - account_id' AFTER `type`;

 

[lindblad88]

hi, getting this error when im trying to add it into my database:

#1060 - Duplicate column name 'value'

- - - Updated - - -

bump

- - - Updated - - -

Solved.