[SOLVED] Submiting News not possible

[Erich le Ghaz]

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

[alby]

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

[Erich le Ghaz]

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

[alby]

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

[RonnyK]

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

[Erich le Ghaz]

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

[alby]

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

[Erich le Ghaz]

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

[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?

Check your permission group (User & Group menu)

Alby

[Erich le Ghaz]

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

[RonnyK]

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

[Erich le Ghaz]

Ronny,

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

Christian