• 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!

Modern AAC Problem.

superoy

New Member
Joined
May 8, 2011
Messages
119
Reaction score
3
Hey guys, i've got a problem.
I've made my database etc through this tutorial; http://otland.net/f479/website-installing-modern-aac-uniform-server-91951/

A Database Error Occurred
Error Number: 1054

Unknown column 'answer_id' in 'where clause'

SELECT * FROM poll_votes WHERE answer_id = 0

I already googled it, and found several hits from OTland.net.
This topic was the best i found; http://otland.net/f16/website-125306/
But i don't really understand the post of Cykotitan, because i dont know where to execute the command.
Neither do i understand Fallen's post.

Im sorry if im really stupid, but its my first OT. Hope somebody can help!

Sincerely,
Superoy
 
Last edited:
Code:
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
 
Back
Top Bottom