Page 1 of 1

{solved} - Problem with news mod, help needed!!!

Posted: Mon May 19, 2008 4:23 pm
by leet8845
Hi there,

I have the latest version of CMSMS installed but when I try to update the news mod I get the following error:

DEBUG: SQL = INSERT INTO cms_module_news (news_id, news_category_id, news_title, news_data, summary, status, news_date, start_time, end_time, create_date, modified_date,author_id,news_extra) VALUES (5,'3','test','test','','published','2008-05-19 14:08:25','2008-05-19 14:08:25',NULL,'2008-05-19 14:09:20','2008-05-19 14:09:20','1','')
Unknown column 'news_extra' in 'field list'

Does anyone how I could fix this?

Many thanks for looking

and even more thanks if you can helpĀ  ;)

Re: Problem with news mod, help needed!!!

Posted: Mon May 19, 2008 4:55 pm
by Nullig
Did you jump a few updates? or is this a new install?

Nullig

Re: Problem with news mod, help needed!!!

Posted: Mon May 19, 2008 6:29 pm
by leet8845
its a new install but I did use a database from an older install without deleting it

Re: Problem with news mod, help needed!!!

Posted: Mon May 19, 2008 6:33 pm
by Dr.CSS
Why? may I ask....

Of course if you don't have any news items you want you could always uninstall the news mod. then reinstall...

Re: Problem with news mod, help needed!!!

Posted: Mon May 19, 2008 6:34 pm
by RonnyK
If you dont have News in the current install, you could uninstall/remove News and reinstall it. For some reason the upgrade-process didnt modify the News-table which should have the news_extra field, since about 1.2.....

Ronny

{solved} Re: Problem with news mod, help needed!!!

Posted: Mon May 19, 2008 7:09 pm
by leet8845
Thanks for your help thats fixed it!