CMS Made Simple Forums

Hi,

I'm now running CMS 1.2 with News 2.3.0.2. I made an upgrade from 1.1.4.1.

If I try to submit a News I get the following 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) VALUES (27,'1','ttt','Test','tttt','published','2007-10-18 17:35:06','2007-10-18 17:35:06',NULL,'2007-10-18 17:35:38','2007-10-18 17:35:38','1','')
Unknown column 'news_extra' in 'field list'

What's wrong?

Thanks in advance.

Christian

Erich le Ghaz wrote: I'm now running CMS 1.2 with News 2.3.0.2. I made an upgrade from 1.1.4.1.

If I try to submit a News I get the following 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) VALUES (27,'1','ttt','Test','tttt','published','2007-10-18 17:35:06','2007-10-18 17:35:06',NULL,'2007-10-18 17:35:38','2007-10-18 17:35:38','1','')
Unknown column 'news_extra' in 'field list'

You use new News module and old News database.
Why you don't use new News module version with CMSMS 1.2?

Alby

Hi!

I uploaded all the files of the 1.2 version and made an upgrade. And the News 2.3.0.2 is what I found under modules now.

I thought News - as a standard module - would be updated automatically with the upgrade. Am I wrong?

Christian

Erich le Ghaz wrote: I uploaded all the files of the 1.2 version and made an upgrade. And the News 2.3.0.2 is what I found under modules now.

I thought News - as a standard module - would be updated automatically with the upgrade. Am I wrong?

In CMSMS 1.2 News module is 2.5.1
Go in Extensions > Modules and see if there is a link for update
If not, try to uploads to server the News folder and overwrite

Alby

Christian,

did you use the full-package, or the diff. The diff is dumped at the moment, as not all files where present. Use the full package instead.

Ronny

Hi!

Alby, no, there is no link. It just says that 2.3.0.2 is installed. You mean I should upload the nes-module files of the 1.2 package again? Do I have to uninstall nes module before?

Ronny, yes I used the full package.

Christian

Erich le Ghaz wrote: Alby, no, there is no link. It just says that 2.3.0.2 is installed. You mean I should upload the nes-module files of the 1.2 package again? Do I have to uninstall nes module before?

If you don't have news articles (or you have a VERY small number): backup db, have you personal templates? (*), uninstall news module, upload full News module folder of CMSMS 1.2 (and overwrite) and install from Admin.

(*) If you have personal (not standard) detail and/or summary template. COPY the code (and name) on your local computer (notepad?) and create new templates with this code after install

Alby

Hi Alby!

Ah, that worked!!! I could post some news again. Now only one problem is open:

The news aren't shown in the sidebar. In the template I use

  {cms_module module="news" number='3' detailpage='news' category='News'}

Isn't that correct any more?

Christian

Erich le Ghaz wrote: Ah, that worked!!! I could post some news again. Now only one problem is open:

The news aren't shown in the sidebar. In the template I use

  {cms_module module="news" number='3' detailpage='news' category='News'}

Isn't that correct any more?

Check your permission group (User & Group menu)

Alby

Hi,

permissions are all checked, they are fine. I think it's nothing with permissions, because they should be shown even without being loged in.

CHristian

Christian,

make sure that the NEWS-entries are "Published" (status within the entry), you need to have "Approve news for frontend display" set.

Is the Category that is being called, the same. Check what happens with just {news}.

Ronny

Ronny,

*thumbs up* you were right. It was the category, which changed to general. Now News is fine thanks a lot!

Christian