[solved] Gallery module gone bananas after upgrade to 1.11.1

[zigge]

Well, everything seems to work except the Gallery module. In the back end it shows each gallery as many times as there are images in the category. Tried several browsers, cleared cache etc. See image attached:



Version info:
CMS-version 1.11.1


Modules:

CMSMailer 5.2.1
FileManager 1.4.0
MenuManager 1.8.3
ModuleManager 1.5.5
News 2.12.8
Search 1.7.7
ThemeManager 1.1.7
TinyMCE 2.9.11
CGFeedMaker 1.0.16
Guestbook 1.3.3.3_betha6
Smileys 0.2.0
Captcha 0.4.5
FrontEndUsers 1.18.1
CustomContent 1.8.3
Uploads 1.14.2
FrontEndUserListing 0.3
SiteMapMadeSimple 1.2.5
NMS 2.4.3
SimpleGoogleMap 1.1
CGExtensions 1.30
Comments 1.9.2
FEUMailer 0.9.4
Statistics 1.1.3
SystemInfo 1.0
JQueryTools 1.1
CGContentUtils 1.3.2
Gallery 1.6
CMSSimplepie 1.0
avplayer 1.3.2
CGCalendar 1.10.0.1
Showtime 3.2
CMSPrinting 1.0.3
MicroTiny 1.2.3

[staartmees]

probably a module that isn't up-to-date for cmsms 1.11.1 and interferes with gallery. I see e.g. your NMS isn't up-to-date and SystemInfo 1.0 is marked as stale since 2010.

[zigge]

Well, I have tried with only the core modules as well, but still the same issue. Frontend works as it should, backend is unusable. Klicking on the links just reloads the page. Very strange.

[zigge]

After a night struggle to get debugging to work, i get the following error in the back end:

Code: Select all

Notice: Undefined index: filepath in /hsphere/local/home/ziggekatten/skanskakustfiskeklubben.se/modules/Gallery/action.editgallery.php on line 74 

Now this is just one row of many with the same error on that file.

[zigge]

Further investigations shows that there must be a serious bug here. Current environment have only core modules, gallery 1.6.

In the front end, klicking on a Gallery to display images, generates an INSERT into the cms_modules_gallery table with a row containing the Gallery just viewed! This is the reason for all the rows I guess, and I can reproduce it all the time.

Tried to upload the Gallery module again, reinstall, but still the same error and problem.

[sjadema]

I got some strange errors after upgrading a 1.10.3 system to 1.11.1. These errors occured in multiple modules but also within Gallery. I deleted the config file (config.php in root) completely and copied one from a fresh 1.11.1 install (changed the DB, user etc ofc.) Everything worked without problems after that except for the front-end of Gallery. To fix this i added the $config[root_url] option to the file and now everything works without problems.

[zigge]

For some reason, the install script does not add the column "editors" to the table "cms_module_gallery_props".

Manually runningng ALTER TABLE ADD COLUMN.... solved the issue.

Further investigation regarding why the upgrade and installscript does not create that column will be done in my sandbox environment. Could be my MySQL that have some issues. At least, my backen now works.