[HELP]BAN command

[renancs]

Im getting this cossole error
mysql_real_query(): INSERT INTO `bans` (`id`, `type`, `value`, `param`, `expires`, `added`, `admin_id`, `comment`, `reason`, `action`, `statement`) VALUES (NULL, 3, 6392822, 153, 1265840476, 1265235676, 7, '???', 0, 3, '') - MYSQL ERROR: Unknown column 'statement' in 'field list' (1054)

When im tring to namelock some player in mine server,, does some one got a ideia to solve this?

Thank you!

 

[zerghel]

in your database the bans table is missing or empty? xD

 

[chojrak]

Missing 'statement' column in 'bans' table, did you properly import schema?

 

[Dilio]

Run this in your database:

DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans`
(
	`id` INT UNSIGNED NOT NULL auto_increment,
	`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
	`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
	`active` TINYINT(1) NOT NULL DEFAULT TRUE,
	`expires` INT NOT NULL,
	`added` INT UNSIGNED NOT NULL,
	`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
	`comment` TEXT NOT NULL,
	`reason` INT UNSIGNED NOT NULL DEFAULT 0,
	`action` INT UNSIGNED NOT NULL DEFAULT 0,
	`statement` VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`id`),
	KEY `type` (`type`, `value`),
	KEY `active` (`active`)
) ENGINE = InnoDB;

That SHOULD fix your error.