Help me

[jazso]

atal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bans.reason' in 'field list'' in C:\xampp\htdocs\bans.php:4 Stack trace: #0 C:\xampp\htdocs\bans.php(4): PDO->query('SELECT `bans`.`...') #1 C:\xampp\htdocs\index.php(358): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\bans.php on line 4

 

[Loney]

Execute this query at your PMA:

CREATE TABLE IF NOT EXISTS `bans` (
`id` int(10) 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(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
`param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
`active` tinyint(1) NOT NULL DEFAULT '1',
`expires` int(11) NOT NULL,
`added` int(10) unsigned NOT NULL,
`admin_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text NOT NULL,
`reason` int(10) unsigned NOT NULL DEFAULT '0',
`action` int(10) unsigned NOT NULL DEFAULT '0',
`statement` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type` (`type`,`value`),
KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

 

[jazso]

no :S! help D:

 

[Cronox]

You need added column reason in table bans not works query loney why you have created your table..
add this query:

ALTER TABLE `bans` ADD
`reason` int(10) NOT NULL DEFAULT 0;