[solved]News Module admin problem - upgrade 1.10.3 to 1.11.8

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
lone
Forum Members
Forum Members
Posts: 71
Joined: Mon Feb 27, 2006 1:36 pm

[solved]News Module admin problem - upgrade 1.10.3 to 1.11.8

Post by lone »

Hello - I have some problems in News Module administation, after an upgrade from 1.10.3 to 1.11.9. Suggestions would be very welcome....

I have done the upgrade again on a backup, to pinpoint when to problem occurred. First to 1.11.0 and then in steps. News Module looked fine until the upgrade between 1.11.7 and 1.11.8.

#1
The news items show up as before on the site, and it is possible to create new items, that show up on the site.

But in the admin, it is not possible to see new items in the Articles tab (or edit them) exept for one category. On a clean install of 1.11.8, the option to filter News by category (the Articles tab) is not there - so I assume the option has been removed?

I did not check this before upgrading the site: the category filter was in use before upgrading, showing only one category (yes, stupid). So on the upgraded site only items from this one category is showing (in the articles tab).

Any way I can get all the items to show in the Articles tab?


#2
When I go to Content->News->options, The News Module show this error in the admin, when I save options:

Code: Select all

INSERT INTO cms_routes (term,key1,key2,key3,data,created) VALUES ('/[nN]ews\\/(?P[0-9]+)$/','News',NULL,NULL,'O:8:\"CmsRoute\":2:{s:15:\"\0CmsRoute\0_data\";a:5:{s:4:\"term\";s:33:\"/[nN]ews\\/(?P[0-9]+)$/\";s:8:\"absolute\";b:0;s:4:\"key1\";s:4:\"News\";s:4:\"key2\";N;s:8:\"defaults\";a:1:{s:8:\"returnid\";i:2060;}}s:18:\"\0CmsRoute\0_results\";N;}',NOW()) -- Duplicate entry '/[nN]ews\/(?P[0-9]+)$/-News' for key 'PRIMARY'
Visiting Content->News shows the module without error again.
Saving options shows the error again.
And so on.

Apparently there is a Duplicate entry somewhere?
Any suggestions how to find it, among 300+ newsitems?

regards, Lone

System info:


----------------------------------------------

Cms Version: 1.11.8

Installed Modules:

CMSMailer: 5.2.1
ModuleManager: 1.5.5
MenuManager: 1.8.6
ThemeManager: 1.1.8
Search: 1.7.10
CGExtensions: 1.37.2
NMS: 2.4.3
Gallery: 1.6.1
Search: 1.7.10
CGSimpleSmarty: 1.7
CGFeedback: 1.6.2
News: 2.13
CGBlog: 1.10.3
CGFeedMaker: 1.0.19
FileManager: 1.4.3
CGSmartImage: 1.12.1
OwnersManual: 1.0.3
JQueryTools: 1.2.5
Captcha: 0.4.6
TinyMCE: 2.9.12


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 32000000
url_rewriting: mod_rewrite
page_extension: .htm
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale: da_DK
default_encoding:
admin_encoding: utf-8
set_names: false


Php Information:

phpversion: 5.3.3-7+squeeze9
md5_function: Fra (Sand)
gd_version: 2
tempnam_function: Fra (Sand)
magic_quotes_runtime: Til (Falsk)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 30
output_buffering: 4096
safe_mode: Til (Falsk)
file_uploads: Fra (Sand)
post_max_size: 32M
upload_max_filesize: 32M
session_save_path: /var/lib/php5 (1733)
session_use_cookies: Fra (Sand)
xml_function: Fra (Sand)
xmlreader_class: Fra (Sand)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysql)
Server Db Version: 5.1.61
Server Db Grants: Et "GRANT ALL" statement, som ser ud til at kunne bruges, fundet
Server Time Diff: No filesystem time difference found


----------------------------------------------
Last edited by lone on Thu Oct 17, 2013 11:00 pm, edited 1 time in total.
User avatar
paulbaker
Dev Team Member
Dev Team Member
Posts: 1465
Joined: Sat Apr 18, 2009 10:09 pm
Contact:

Re: News Module admin problem - upgrade 1.10.3 to 1.11.8

Post by paulbaker »

lone
Forum Members
Forum Members
Posts: 71
Joined: Mon Feb 27, 2006 1:36 pm

Re: News Module admin problem - upgrade 1.10.3 to 1.11.8

Post by lone »

Hi Paul

Yes it does look like the same issue, I see there is now a bug-report on this - http://dev.cmsmadesimple.org/bug/view/9571 ....

regards, Lone
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am

Re: News Module admin problem - upgrade 1.10.3 to 1.11.8

Post by Dr.CSS »

Have you tried the System Maintenance > Cache and content > Update Routes button..?
lone
Forum Members
Forum Members
Posts: 71
Joined: Mon Feb 27, 2006 1:36 pm

Re: News Module admin problem - upgrade 1.10.3 to 1.11.8

Post by lone »

Hi, thanks for suggesting this.
The problem has been solved - after a couple of days, I downloaded the core files for 1.11.9 again, upgraded with the new files, and things were sorted out: no missing sort-options, and no mysterious error. The files I were using apparently were not allright. Guess I will be more careful with the checksum in the furture :)

regards, Lone
Locked

Return to “[locked] Installation, Setup and Upgrade”