CMS MADE SIMPLE FORGE

Gallery

 
Back Back to List

[#7980] Titles, album thumbnails lost on upgrade

avatar
Created By: Paul Baker (paulbaker)
Date Submitted: Tue May 22 20:23:02 -0400 2012

Assigned To: Jos (josvd)
Version: 1.5.3
CMSMS Version: 1.10.3
Severity: Minor
Resolution: None
State: Open
Summary:
Titles, album thumbnails lost on upgrade
Detailed Description:
When upgrading from CMSMS 1.9.4.x to 1.10.3 and Gallery 1.5.3 titles and album
thumbnails are lost.

When table cms_module_gallery is inspected you can see /// has been added to the
end of some paths and some rows have been added with blank title and comment
fields.

It is possible to repair the table and restore the gallery.

All detailed in this forum thread:
http://forum.cmsmadesimple.org/viewtopic.php?f=7&t=60104

Previously raised and closed http://dev.cmsmadesimple.org/bug/view/7951 but I
believe it is a bug based on number of people reporting the issue.


History

Comments
avatar 
Date: 2012-07-16 06:06
Posted By: Ludger Merkens (lume)

same problem here. I'm going from CMSMS 1.9.4.2 Faanui and Gallery 1.4.3 to
1.10.3 Hyacinthe and Gallery 1.5.3. As Jos asked for the database version in the
forementioned thread: OS is Debian squeeze, mysql: 5.1.63

btw. after applying the database fix mentioned in the forum, backend and gallery
thumbnails work fine, but the gallery still ignores the image order.

best regards
Ludger
avatar 
Date: 2012-07-16 17:35
Posted By: Jos (josvd)

Ludger, are you able to check if you have the same problems if you upgrade from
1.4.3 to 1.6?
avatar 
Date: 2012-07-17 13:10
Posted By: Ludger Merkens (lume)

Yes Jos - confirmed. I have the same problems, if I upgrade directly to 1.6.
avatar 
Date: 2012-07-17 13:21
Posted By: Ludger Merkens (lume)

One remark to the image order: I also changed the server, thus the filesystem
file-order may have changed when mirroring via ncftp. I didn't have any explicit
sorting order installed, the backend shows the old image order, the frontend
does not.

Another remark on the update problems. After upgrading, on the templates tab,
all templates are listed 3 times. Deleting one of each triplet, deletes all
three entries.
avatar 
Date: 2012-09-30 16:08
Posted By: Joni Hasanen (hasanen)

Hi

I can confirm this problem, and I think i found the problem. I debugged this
upgrade process with versions 1.4.4 and 1.6.

In method.upgrade.php (on version 1.6) line 215 in sql query, there is missing
"AND filepath NOT LIKE '%/'" (as there is such condition on line 258). After
adding that condition to line 215, I succefully upgraded gallery to version 1.6.

Although, I'm going to keep my production site in version 1.4.4 until there is
official version which include this fix :)