Quando clico na pagina characters meu site buga.

Postado Fevereiro 23, 2013 12 anos

Quando eu clico na pagina characters do meu site de otserver aparece a mensagem:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'reason' in 'field list'' in C:\Users\Renata\Desktop\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\Users\Renata\Desktop\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\Users\Renata\Desktop\xampp\htdocs\pot\OTS_Account.php(955): OTS_AccountBan->find('8069458') #2 C:\Users\Renata\Desktop\xampp\htdocs\characters.php(274): OTS_Account->isBanned() #3 C:\Users\Renata\Desktop\xampp\htdocs\index.php(103): include('C:\Users\Renata...') #4 {main} thrown inC:\Users\Renata\Desktop\xampp\htdocs\pot\OTS_AccountBan.php on line 55

Ajuda PLLLLLXXXXXX

Citar

Mention

Postado Fevereiro 23, 2013 12 anos

execute isso no phpmyadmin

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;