problem with news module after upgrading from 1.0.2 to 1.4.1

[elmarko]

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

[Dr.CSS]

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

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

[faglork]

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

[alby]

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