• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Solved Missing table

lycefur

New Member
Joined
Jul 13, 2010
Messages
99
Reaction score
2
I just managed to download and 'install' a layout posted on otland but in the corner of my ots' site it shows:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theforgottenserver.z_polls' doesn't exist' in C:\xampp\htdocs\layouts\tibiacom1\layout.php:565 Stack trace: #0 C:\xampp\htdocs\layouts\tibiacom1\layout.php(565): PDO->query('SELECT * FROM z...') #1 C:\xampp\htdocs\index.php(317): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\layouts\tibiacom1\layout.php on line 565

Could you give me a command - what sql command should I paste to create that missing table and remove this error?

Ty for any help giving rep.
 
Last edited:
Code:
CREATE TABLE `z_polls` (
                           `id` int(11) NOT NULL auto_increment,
                           `question` varchar(255) NOT NULL,
                           `end` int(11) NOT NULL,
                           `start` int(11) NOT NULL,
                           `answers` int(11) NOT NULL,
                           `votes_all` int(11) NOT NULL,
                           PRIMARY KEY  (`id`)
                         ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
 
Back
Top