Windows Website Error (Xampp+ModernAAC

[Alyhide]

 

[cbrm]

drop table poll_votes

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 ;

 

[Alyhide]

Still giving the same error o.0

 

[Alyhide]

bump

 

[Chris]

ALTER TABLE `poll_votes` ADD `answer_id` INT(11) DEFAULT 0;

 

[Alyhide]

Worked

 

[Alyhide]

Now it's..


Error Number: 1054

Unknown column 'active' in 'where clause'

SELECT `id`, `title`, `body`, `time` FROM `news` WHERE `active` = '1' ORDER BY id DESC LIMIT 3

 

[president vankk]

ALTER TABLE `news` ADD COLUMN `active` INT(11) DEFAULT 1;

 

[Santi]

 SELECT `id`, `title`, `body`, `time` FROM  `news` WHERE `active` = 1 ORDER BY `id` DESC LIMIT 3