Acc maker ma?y problem

[Slither01]

Mam taki bl?d w prawo d?? acc makera


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

w linijcie layout 598 mam

$viewpoll = $SQL->query('SELECT * FROM z_polls where end > '.$time.' ORDER BY id DESC LIMIT 1');

I jeszcze nie moge wgra? monster?w ani czar?w do acc makera : \

 

[andy1995]

Odp: Acc maker ma?y problem

Dodaj do bazy

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 ;

CREATE TABLE `z_polls_answers` (
  `poll_id` int(11) NOT NULL,
  `answer_id` int(11) NOT NULL,
  `answer` varchar(255) NOT NULL,
  `votes` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL ;