Erro no guild wars do server

Postado Junho 22, 2012 12 anos

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'realserver.guilds' doesn't exist' in C:\xampp\htdocs\pot\OTS_Guild.php:124 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Guild.php(124): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\wars.php(72): OTS_Guild->load('1') #2 C:\xampp\htdocs\index.php(244): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Guild.php on line 124

o que fazer?

Citar

Mention

Postado Junho 22, 2012 12 anos

A tabela guilds, não existe.

Execute esse comando:

CREATE TABLE `guilds`

(

	`id` INT NOT NULL AUTO_INCREMENT,

	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

	`name` VARCHAR(255) NOT NULL,

	`ownerid` INT NOT NULL,

	`creationdata` INT NOT NULL,

	`motd` VARCHAR(255) NOT NULL,

	PRIMARY KEY (`id`),

	UNIQUE (`name`, `world_id`)

) ENGINE = InnoDB;

Citar

Mention