Windows Website

[Lava Titan]

Hello, can someone tell me what does this mean?

A Database Error Occurred
Error Number: 1054

Unknown column 'answer_id' in 'where clause'

SELECT * FROM poll_votes WHERE answer_id = 0

By the way: im using Modern AAC

What should i do? :x

 

[picachu]

go on poll_votes
and create a table answer_id INL

 

[DonHagman]

Easu bumping.. One bump each 24 hours

 

[Lava Titan]

well i think thats done pikachu but still having same error

 

[Cykotitan]

drop all (3) of your poll* tables and execute this:

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 ;

 

[Lava Titan]

Worked, thanks cyko =p

 

[Cykotitan]

maybe you did it on a wrong database? or the queries failed? check your table to see if the column was created ok

 

[Lava Titan]

Edit:

A Database Error Occurred
Error Number: 1054

Unknown column 'active' in 'where clause'

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

 

[Kofels]

Do active field (boolean) SQL addition on your table.

 

[Lava Titan]

how

 

[Kofels]

MySQL :: MySQL 5.5 Reference Manual :: 12.1.6 ALTER TABLE Syntax -.-

 

[Lava Titan]

A Database Error Occurred
Error Number: 1054

Unknown column 'active' in 'where clause'

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

This is the last error i got and didnt find anything to fix yet

 

[Lava Titan]

Bump

 

[Fallen]

probably:

ALTER TABLE `news` ADD `active` BOOL NOT NULL DEFAULT 0;

 

[Lava Titan]

Thanks, worked =p rep++ for every1 who helped =p

 

[Lava Titan]

New error on console this time :X

[17/04/2011 22:07:48] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'flammingvets.z_ots_comunication' doesn't exist (1146)

 

[Lava Titan]

Problem fixed

 

[tusik123]

Hey , please someone help me
every time im doing password on my website , im get number like u put something on Sha1.
im really dont know how to put it to normal password.
please help me

 

[Danger II]

Which AAC Tusik?

 

[tusik123]

i use ModernAAC-trunk.r129