(Resolvido)[GESIOR] ERRO Alguem me ajudee

[juliosky 26]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otserv.z_forum' doesn't exist' in C:\Documents and Settings\Administrador\Meus documentos\Downloads\xampp\htdocs\latestnews.php:288 Stack trace: #0 C:\Documents and Settings\Administrador\Meus documentos\Downloads\xampp\htdocs\latestnews.php(288): PDO->query('SELECT `z_forum...') #1 C:\Documents and Settings\Administrador\Meus documentos\Downloads\xampp\htdocs\index.php(63): include('C:\Documents an...') #2 {main} thrown in C:\Documents and Settings\Administrador\Meus documentos\Downloads\xampp\htdocs\latestnews.php on line 288

 

está dando esse erro, alguem me ajude ?

[luanluciano93 1994]

Use esse comando na database (pelo phpmyadmin)

 

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',
`closed` tinyint(1) NOT NULL default '0',
`sticky` int(11) 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(15) NOT NULL default '0.0.0.0',

PRIMARY KEY  (`id`),
KEY `section` (`section`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

Espero te ajudado!

[juliosky 26]

Use esse comando na database (pelo phpmyadmin)

 

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',
`closed` tinyint(1) NOT NULL default '0',
`sticky` int(11) 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(15) NOT NULL default '0.0.0.0',

PRIMARY KEY  (`id`),
KEY `section` (`section`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

Espero te ajudado!

 

Consegui, mt obrigadooo mano ajudou bastante REP+