Olha, estou com um problema na minha database, quando clico em players ele volta a tela de login e aparece isso

 

Error

 

 

 

No activity within 1800 seconds; please log in again

 

 

Estava tudo certo mas isso me causou um outro problema

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'realserver.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('2171630') #2 C:\xampp\htdocs\accountmanagement.php(32): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(310): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55

 

o que posso fazer?

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;

Muito obrigado, REP+ pra voce!

cú

Editado Fevereiro 14, 2015 10 anos por MessyTezzie (veja o histórico de edições)

 vlw