Outros {Duvida query}

[xlx 0]

Sempre q tento lir pra my account da esse erro!

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otserver.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\xampp\htdocs\pot\OTS_Account.php(935): OTS_AccountBan->find('1') #2 C:\xampp\htdocs\accountmanagement.php(31): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(145): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55

 

Editado Março 18, 2016 por xlx (veja o histórico de edições)

[Tricoder 896]

@xlx

Tenta executar isso:

ALTER TABLE `bans` ADD `reason` INT UNSIGNED NOT NULL DEFAULT 0

 

[xlx 0]

4 minutos atrás, Azhaurn disse:

@xlx

Tenta executar isso:

ALTER TABLE `bans` ADD `reason` INT UNSIGNED NOT NULL DEFAULT 0

 

da esse erro

#1060 - Duplicate column name 'reason'