guild waro

[melegy]

Hello
I've this error in my t site when i try to go into "guild war" section

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

regards.

 

[Cornex]

Are you using TFS 1.x? If yes, try

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild1` int(11) NOT NULL DEFAULT '0',
  `guild2` int(11) NOT NULL DEFAULT '0',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `started` bigint(15) NOT NULL DEFAULT '0',
  `ended` bigint(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guild1` (`guild1`),
  KEY `guild2` (`guild2`)
) ENGINE=InnoDB;