Gesior Forum not work

[xitos]

Hiho

I followed the tutorial on how to make the forum but did not work yet, of the following error:

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

Line 128:

$info = $SQL->query("SELECT `section`, COUNT(`id`) AS 'threads', SUM(`replies`) AS 'replies' FROM `z_forum` WHERE `first_post` = `id` GROUP BY `section`")->fetchAll();

and how it adds that in phpmyadmin?

CREATE TABLE IF NOT EXISTS `posts` (
`id` int(11) NOT NULL auto_increment,
`subject` varchar(255) default NULL,
`icon` int(5) default NULL,
`date` varchar(45) default NULL,
`time` varchar(30) default NULL,
`author` varchar(30) default NULL,
`board` int(5) default NULL,
`thread` int(20) default NULL,
`post` text,
`signature` int(5) default NULL,
`edited` int(5) NOT NULL,
`edit_date` varchar(45) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;

CREATE TABLE IF NOT EXISTS `threads` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`icon` int(5) default NULL,
`closed` int(5) default NULL,
`stick` int(5) NOT NULL,
`date` varchar(45) default NULL,
`time` varchar(30) default NULL,
`author` varchar(30) default NULL,
`board` int(5) default NULL,
`views` int(20) default NULL,
`last` int(40) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `forums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255),
`description` text,
`closed` int(5) default NULL,
`access` int(5) NOT NULL,
`guild_id` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


INSERT INTO `forums` (`id`, `name`, `description`, `closed`, `access`, `guild_id`) VALUES
(1, 'First forum.', 'This is your first forum.', 0, 0, 0);

 

[xitos]

upup

 

[xitos]

help guys please !!