dúvida Quando clico na pagina characters meu site buga.

[leister 0]

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

[aniporas 8]

seu bd não ta completo

ta faltando coisa

[leister 0]

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;

[Piabeta Kun 359]

resolvido, pedindo para que movam!

[Demonbholder 420]

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