CMS Made Simple Forums

Hi, how's it going, I have a problem with news module after upgrading from 1.0.2 to 1.4.1. When I try to submit a new article I'm met with an error message that reads:

DEBUG: SQL = INSERT INTO markcms_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 (82,'1','testtest','test','test','published','2008-08-20 23:42:14','2008-08-20 23:42:14',NULL,'2008-08-20 23:42:30','2008-08-20 23:42:30','1','xxxx')
Unknown column 'news_extra' in 'field list'

I'm assuming (and i hope I'm correct) that 82 not being in apostrophes is why it is returning that there is an unknown column, can anyone tell me which file i need to amend and to what to correct the issue?

Thanks for your time
Mark

Re upload the News module from your unpacked CMSMS in the modules folder, overwrite every thing...

And run /install/upgrade.php again...

mark wrote: Re upload the News module from your unpacked CMSMS in the modules folder, overwrite every thing...

And run /install/upgrade.php again...

Can you elaborate on that?

a) Why first upload the news module - isn't it part of the install package anyway?
b) wouldn't it suffice to manually  add the 'news_extra' field  in the database?

Cheers,
Alex

faglork wrote: b) wouldn't it suffice to manually  add the 'news_extra' field  in the database?

yes, the problem is missing new field in table 'news_extra', try to add with a sql tool

Alby