Errors with NEWEST TFS rep++ FAST

[enriel]

Anyone can help me with this one?

mysql_real_query(): SELECT `id`, `type`, `param`, `expires`, `added`, `admin_id`, `comment`, `reason`, `action`, `statement` FROM

 

[EvulMastah]

Anyone can help me with this one?

Copy the whole error line?
You probably got some field missing.

Either way, try to delete your bans table and create it again:

CREATE TABLE `bans`
(
	`id` INT UNSIGNED NOT NULL auto_increment,
	`type` TINYINT(1) NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban',
	`value` INT UNSIGNED NOT NULL COMMENT 'ip, player guid, account number',
	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'mask',
	`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;

 

[enriel]

Copy the whole error line?
You probably got some field missing.

It happens every time someone logs in and wait I'll check again.

Oh and here is the error;

mysql_real_query(): SELECT `id`, `type`, `param`, `expires`, `added`, `admin_id`, `comment`, `reason`, `action`, `statement` FROM `bans` WHERE `value` = 8956909 AND `active` = 1 AND (`expires` > 1234723278 OR `expires` <= 0): MYSQL ERROR: Unknown column 'statement' in 'field list'

 

[EvulMastah]

The best way would be to recreate it as in my first answer here... or run this query:

ALTER TABLE `bans` ADD `statement` VARCHAR(255) NOT NULL DEFAULT ''

 

[klekSu]

I cannot run this query, tells me it duplicates bla bla you know. But i've recreated the tables gettng sql from schema.sql and that error still crashes TFS.

 

[klekSu]

Bump.