Z_forum

[pieter quak]

if i try to get on my site i get this

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: z_forum' in C:\xampp\htdocs\latestnews.php:205 Stack trace: #0 C:\xampp\htdocs\latestnews.php(205): PDO->query('SELECT `z_forum...') #1 C:\xampp\htdocs\index.php(70): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 205


How do i fix this?

 

[pieter quak]

Bump

 

[pieter quak]

Bump

 

[pieter quak]

Bumpin' in the name of bumpzor!!!!!

 

[rockseller]

z_forum table doesn't exist, you need to create them with the proper Schema / .SQL which should be included in the package you are trying to use

 

[Zer0xe]

CREATE TABLE `z_forum` (
  `id` int(11) NOT NULL auto_increment,
  `first_post` int(11) NOT NULL default '0',
  `last_post` int(11) NOT NULL default '0',
  `section` int(3) NOT NULL default '0',
  `replies` int(20) NOT NULL default '0',
  `views` int(20) NOT NULL default '0',
  `author_aid` int(20) NOT NULL default '0',
  `author_guid` int(20) NOT NULL default '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL default '0',
  `post_date` int(20) NOT NULL default '0',
  `last_edit_aid` int(20) NOT NULL default '0',
  `edit_date` int(20) NOT NULL default '0',
  `post_ip` varchar(32) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

ALTER TABLE `accounts` ADD `last_post` INT( 11 ) NOT NULL DEFAULT '0';

-Zer0xe

 

[pieter quak]

Thanks both

And Fallout ROX!!!