Modern AAC Site Help. Will Give Rep+

[renots10]

Alright, Once Again i'm Needing help..
tried posting this earlier but it never showed up, yet told me it was posted.
I got another pc, After someone helped me get it running before.
I took all my files, Server, ht docs ect from the old pc, and put on here.
i'm getting a error when trying to get the site to load up -

done some research, but coulden't get a valid answer to the issue.

A Database Error Occurred

Error Number: 1054

Unknown column 'id' in 'order clause'

SELECT * FROM (`news`) ORDER BY `id` desc LIMIT 10

 

[Korrex]

Execute this query:

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT '',
  `body` text,
  `time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[renots10]

Execute this query:

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT '',
  `body` text,
  `time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Still Get The Same error.

 

[storken96]

Try this

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

 

[renots10]

Try this

I'm Still getting the same error -
And when i try to run that i get -

#1060 - Duplicate column name 'active'