CMS Made Simple Forums

www.fbcaa.org
CMS 1.9.1, recently upgraded from 1.4.1.
News module 2.11

I just activated the news module. The first article, about the news module being installed, was posted there. I deleted it, then tried to add a new test article, and got this message:

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,news_url) VALUES (5,'1','Test','test','test','published','2010-12-13 09:46:23',NULL,NULL,'2010-12-13 09:46:32','2010-12-13 09:46:32','1','test','test')
Unknown column 'news_url' in 'field list'

I searched the forums and found one article that mentioned news_url, but it was in German, and my translation skills are a bit lacking

Thanks for any help you can provide.

something happened on the upgrade and that column was not added to the database table.

An uninstall and re-install of the news module (2 mouse clicks in "Extensions >> Modules") should take care of it.

An uninstall and re-install of the news module (2 mouse clicks in "Extensions >> Modules") should take care of it.

After a db backup, of course. Uninstalling and reinstalling removes any existing news articles, categories, templates and custom fields associated with the news module.

Same here: CMS 1.9.3, upgraded from 1.4.1.:

I cannot edit older news and get the "Unknown column 'news_url'"-warning on creating a new article.

I did the uninstall/install twice on the news module to no avail. Also WYSIWYG is off by default in the news module only.

bryan wrote:

An uninstall and re-install of the news module (2 mouse clicks in "Extensions >> Modules") should take care of it.

After a db backup, of course. Uninstalling and reinstalling removes any existing news articles, categories, templates and custom fields associated with the news module.

It does NOT work.

What I did:
- made a db backup
- uninstalled news
- re-installed news
- restored database

Same error.

What now?

Cheers,
Alex

calguy1000 wrote:something happened on the upgrade and that column was not added to the database table.

What if I add this column manually?


EDIT: I just added the field "news_url" manually (via phpmyadmin) to the table "myprefix_module_news". Properties are the same as "news_extra".

That apparently did the trick ...

Cheers,
Alex