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 in C:\Users\Renata\Desktop\xampp\htdocs\pot\OTS_AccountBan.php on line 55

Ajuda PLLLLLXXXXXX

seu bd não ta completo

ta faltando coisa

pode me explicar como arrumo isso?? pllx

ou sei la.. tem como me passar uma database completa?

Ja resolvi o Problema: é so executar 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;

resolvido, pedindo para que movam!

Tópico movido para a seção de dúvidas e pedidos resolvidos.