[MODERNAAC] A Database Error Occurred Error Number: 1054 Unknown column 'active'...

[Flip Hosting]

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

What should I do? I've imported my schema and it added 35 queries..

REP++

 

[Flip Hosting]

Bump, thread didnt show up on first page....

 

[Flip Hosting]

It doesnt show up on first page.. Bug?

 

[Havocbringer]

ALTER TABLE `poll_votes` ADD COLUMN `answer_id` INT(11)

Rep++?

 

[Flip Hosting]

It has to do with news! Also I tested it and I dont have any table named poll_votes

 

[Havocbringer]

-.- you need to add this querie to database nd anyone just substitute the first with news and the last with whats missing :L

 

[Chris]

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

 

[lollimpo]

ALTER TABLE `z_news_tickers` ADD COLUMN `active` INT(11) DEFAULT 1
así mejor...

 

[Jano]

ALTER TABLE `z_news_tickers` ADD COLUMN `active` INT(11) DEFAULT 1
así mejor...

Jun 23, 2011