Erro 1146 - Gesior ACC characters - Suporte Tibia OTServer - TibiaKing

Postado Fevereiro 27, 2015 10 anos

Estou com esse pequeno erro no meu site, agradeço dês de já...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'orion.player_advances' doesn't exist' in C:\xampp\htdocs\characters.php:280 Stack trace: #0 C:\xampp\htdocs\characters.php(280): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\characters.php on line 280

EDIT : peço que fechem o topico, pois ja encontrei a solução : D

DROP TABLE IF EXISTS `player_advances`;

CREATE TABLE `player_advances` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`cid` int(11) DEFAULT NULL,

`skill` int(11) DEFAULT NULL,

`oldlevel` int(11) DEFAULT NULL,

`newlevel` int(11) DEFAULT NULL,

`time` int(11) DEFAULT NULL,

UNIQUE KEY `id` (`id`),

KEY `cid` (`cid`),

CONSTRAINT `player_advances_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;