Solved Help please guy's

[KarolkaDemolka]

A Database Error Occurred

Error Number: 1146

Table 'xanteria.poll' doesn't exist

SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()

 

[Ninja]

CREATE TABLE IF NOT EXISTS `poll` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `question` VARCHAR(150) ,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_start` datetime ,
  `date_end` datetime ,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `question` (`question`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `poll_answer` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `poll_id` INT(11) NOT NULL,
  `answer` VARCHAR(150) ,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `poll_votes` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `answer_id` INT(11) ,
    `poll_id` INT(11) ,
    `account_id` INT(11) NOT NULL,
    PRIMARY KEY (`id`),
    FOREIGN KEY (`answer_id`) REFERENCES `poll_answer` (`id`) ON DELETE CASCADE,
    FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE,
    FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Akkz]

Solved!

 

[KarolkaDemolka]

thanks

- - - Updated - - -

Can't connect to MySQL database.
affffffffff

- - - Updated - - -

A Database Error Occurred

Unable to connect to your database server using the provided settings.

- - - Updated - - -

it's work now
but why druid simple and rock simple no down in phpmyadmin ?