Gallery upgrade to 1.5.2 problem

[paulbaker]

Hi Jos, don't apologise, you're doing all of us a favour!

From phpMyAdmin:
•Server: Localhost via UNIX socket
•Server version: 5.0.95-community-log
•Protocol version: 10
•MySQL charset: UTF-8 Unicode (utf8)

Happy to help provide any other info you need.

Applejack, thanks, I had forgotten about that feature.

[Jos]

•Server version: 5.0.95-community-log

MySQL 5 should be oke.. don't know what else to ask..

[applejack]

No problem I appreciate how hard it can be to find things at times as there can be so many variables involved.

MySQL version 5.0.95
PHP 5.3

I think I upgraded from 1.4.4 to 1.5.2 using the module manager which is when it broke. After rolling back I upgraded one version at a time using the downloaded xml files if that might be of any help.

[paulbaker]

This is still an issue (for me at least). On a CMSMS 1.10.3 site I just upgraded Gallery from 1.4.4 to 1.6 and the cms_module_gallery table got corrupted somehow.

I then upgraded the site from 1.10.3 to 1.11.4 (in one step) which didn't seem to change it.

The only non-core module on this site is Gallery. There are 6 images in the gallery.

Here is the table before upgrade (taken from a backup).

Code: Select all

--
-- Dumping data for table `cms_module_gallery`
--

LOCK TABLES `cms_module_gallery` WRITE;
/*!40000 ALTER TABLE `cms_module_gallery` DISABLE KEYS */;
INSERT INTO `cms_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES 
(1,'Gallery/','','2012-01-17 00:10:48',-1,1,0,0,'Gallery','Thank you for installing the Gallery module. If you have uploaded some images to the \'uploads/images/Gallery\' folder, you will see them below. You can edit titles, descriptions and thumbnail sizes in the admin section. Check out all the other features this module offers in the Module Help.'),
(2,'Slider/','','2012-01-17 00:52:54',0,1,0,1,'Slider','Slider images - please do not add/edit images here'),
(4,'SlidePolarpark2.jpg','Slider','2012-01-17 01:09:59',5,1,0,2,'','XXXX are third party accredited within the FIRAS scheme. All our operatives have a minimum certification of NVQ Level 2 in passive fire protection and are CSCS registered. XXXX are also CHAS, SMAS and Achillies (Building Confidence) accredited.'),
(6,'SlideGardenerrd19.jpg','Slider','2012-01-17 01:09:58',4,1,0,2,'','As a company, we pride ourselves on providing a first class service from initial consultation to completion of a contract, whilst ensuring that the most cost effective work ethos and professional working relationship is maintained for our clients.'),
(7,'SlideGreenzoneP7050020.jpg','Slider','2012-01-17 01:09:59',3,1,0,2,'','As we are members of some of the leading UK construction company supply chains, we have completed works throughout the UK. As these relationships continue, XXXX are now receiving ever increasing repeat contracts.'),
(8,'SlideThehubatHatfield1.jpg','Slider','2012-01-17 01:10:00',1,1,0,2,'','XXXX was founded in 2005. We specialise in all aspects of passive fire protection including intumescent coatings to structural steelwork, service penetrations and all types of fire barriers. Our head office is based in Marlow, Buckinghamshire and our staff have over 30 years of combined experience and commitment.'),
(9,'SlideWork043.jpg','Slider','2012-01-17 01:10:03',2,1,0,2,'','Within the construction industry, XXXX are recognised as one of the leading specialists in passive fire protection. Included in our repertoire we also specialise in all aspects of air sealing works, industrial painting and thermal soffit insulation.'),
(11,'Westfield_5715660714_3883592392_b.jpg','Slider','2012-10-03 10:43:53',7,1,0,2,'','Explore our website to find out more.');
/*!40000 ALTER TABLE `cms_module_gallery` ENABLE KEYS */;
UNLOCK TABLES;

Here is the table after corruption.

Code: Select all

--
-- Dumping data for table `cms_module_gallery`
--

LOCK TABLES `cms_module_gallery` WRITE;
/*!40000 ALTER TABLE `cms_module_gallery` DISABLE KEYS */;
INSERT INTO `cms_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES 
(1,'','','2012-01-17 00:10:48',-1,1,0,0,'Gallery','Thank you for installing the Gallery module. If you have uploaded some images to the \'uploads/images/Gallery\' folder, you will see them below. You can edit titles, descriptions and thumbnail sizes in the admin section. Check out all the other features this module offers in the Module Help.'),
(2,'Slider/','','2012-01-17 00:52:54',0,1,0,1,'Slider','Slider images - please do not add/edit images here'),
(4,'SlidePolarpark2.jpg','Slider///','2012-01-17 01:09:59',5,1,0,2,'','XXXX are third party accredited within the FIRAS scheme. All our operatives have a minimum certification of NVQ Level 2 in passive fire protection and are CSCS registered. XXXX are also CHAS, SMAS and Achillies (Building Confidence) accredited.'),
(6,'SlideGardenerrd19.jpg','Slider///','2012-01-17 01:09:58',4,1,0,2,'','As a company, we pride ourselves on providing a first class service from initial consultation to completion of a contract, whilst ensuring that the most cost effective work ethos and professional working relationship is maintained for our clients.'),
(7,'SlideGreenzoneP7050020.jpg','Slider///','2012-01-17 01:09:59',3,1,0,2,'','As we are members of some of the leading UK construction company supply chains, we have completed works throughout the UK. As these relationships continue, XXXX are now receiving ever increasing repeat contracts.'),
(8,'SlideThehubatHatfield1.jpg','Slider///','2012-01-17 01:10:00',1,1,0,2,'','XXXX was founded in 2005. We specialise in all aspects of passive fire protection including intumescent coatings to structural steelwork, service penetrations and all types of fire barriers. Our head office is based in Marlow, Buckinghamshire and our staff have over 30 years of combined experience and commitment.'),
(9,'SlideWork043.jpg','Slider///','2012-01-17 01:10:03',2,1,0,2,'','Within the construction industry, XXXX are recognised as one of the leading specialists in passive fire protection. Included in our repertoire we also specialise in all aspects of air sealing works, industrial painting and thermal soffit insulation.'),
(11,'Westfield_5715660714_3883592392_b.jpg','Slider///','2012-10-03 10:43:53',7,1,0,2,'','Explore our website to find out more.'),
(12,'SlidePolarpark2.jpg','Slider/','2012-01-17 01:09:59',6,1,0,2,'',''),
(13,'SlideGardenerrd19.jpg','Slider/','2012-01-17 01:09:58',5,1,0,2,'',''),
(14,'SlideGreenzoneP7050020.jpg','Slider/','2012-01-17 01:09:59',3,1,0,2,'',''),
(15,'SlideThehubatHatfield1.jpg','Slider/','2012-10-03 09:47:45',4,1,0,2,'',''),
(16,'SlideWork043.jpg','Slider/','2012-01-17 01:10:03',1,1,0,2,'',''),
(17,'Westfield_5715660714_3883592392_b.jpg','Slider/','2012-10-03 10:43:53',2,1,0,2,'','');
/*!40000 ALTER TABLE `cms_module_gallery` ENABLE KEYS */;
UNLOCK TABLES;

Upgrade process seems to have:

- Removed "Gallery/" from filename in ID 1
- Left ID 2 alone (the sub-directory name)
- Appended /// to the filepath in the 6 image rows
- Repeated the images, adding 6 new rows (12 to 17), using Slider/ as the filepath (note original filepath was just Slider), changing the fileorder and dropping the comment

So, editing the database I did this to get back to exactly how the table was in Gallery 1.4.4:

- Removed the 6 new repeated rows
- Removed /// from filepath

Then I went to Content -> Gallery -> Slider/ and then I inspected the database again - the system had repeated all rows again as above So it seems it's not the upgrade itself corrupting but the action of viewing the gallery setup in the admin area?

Anyway, it is now working - what I did was removed the 6 new repeated rows and removed just 2 / from /// in filepath, leaving "Slider/" just like the solution described earlier in this thread.

I hope that helps the diagnosis? I've probably just confused the situation more...

[sniek]

This is also still a problem for me, any solutions yet? Besides going to edit the database?

Upgrading version to version is a solution?