Bug in News updating from 1.0.2 to 1.2

[Dr.CSS]

After updating CMSMS from 1.0.2 to 1.2 the news is giving an error message when trying to add a new News article and the article isn't being added, all old news items can be changed or updated and the changes take the update, all templates are default install templates, all permissions have been checked to make sure it's not them...

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 (29,'1','test1','ttt','ttt','published','2007-12-28 23:55:19','2007-12-28 23:55:19',NULL,'2007-12-28 23:55:34','2007-12-28 23:55:34','3','')
Unknown column 'news_extra' in 'field list'

All items in red are from the title and the summary and content edit boxes...

[RonnyK]

Mark,

I've seen this one before on the board, for some reason the field isnt inserted in the table on update.

Did you try upgrading to 1.2.2 as well. As some state that that solved their problem as well.

Otherwise you could add

Code: Select all

news_extra field varchar(255) to table cms_module_news

Ronny

[hesaa]

Mark,

I've seen this one before on the board, for some reason the field isnt inserted in the table on update.

Did you try upgrading to 1.2.2 as well. As some state that that solved their problem as well.

Otherwise you could add

Code: Select all

news_extra field varchar(255) to table cms_module_news

Ronny

I am a beginner / novice user of CMS and am also experiencing similar difficulty with the News module after an upgrade.  Can you please help show me specifically where to insert that code?  Also, I am having trouble updating the content of existing News articles.  Any help is much appreciated.

Thank you,
John

[hesaa]

Thanks for the quick response.

I do have access to phpMyAdmin.  I can post PHP 4.4.4 and MySQL 5.  I am running CMSMS 1.2.4 and I'm not sure which version of News I am running, but it was upgraded to whatever the latest one was at the time we upgraded CMSMS.