HTML5 Slideshow (html5slideshow): v1.4

[sjj1805]

I have PHP 7.1.7 on a 64 bit version of Windows 10 Pro version 1803.
My Coppermine version is 1.6.04
Every time I want to add a new album to my installation I have to remove the HTML5 Slideshow (html5slideshow): v1.4 plug in before the system will let me add a new album, If I do not I simply see a never ending circular wheel (Hour glass). After creating a new album I can re-install the HTML5 Slideshow (html5slideshow): v1.4 plug in and everything works.
Anyone else having this trouble?

Link to my albums: http://stevejjones.co.uk/photo/index.php

Thank you

[ron4mac]

It's likely an issue with strict changes to mySQL 5.7+.

In the plugin's codebase.php file, try changing:
at around line 124 ...

Code Select Expand

cpg_db_query("ALTER TABLE {$CONFIG['TABLE_ALBUMS']} ADD `H5ss_cfg` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
cpg_db_query("ALTER TABLE {$CONFIG['TABLE_USERS']} ADD `H5ss_cfg` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
to:

Code Select Expand

cpg_db_query("ALTER TABLE {$CONFIG['TABLE_ALBUMS']} ADD `H5ss_cfg` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL");
cpg_db_query("ALTER TABLE {$CONFIG['TABLE_USERS']} ADD `H5ss_cfg` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL");


Re-install the plugin.

That could solve it (or change the issue in some way). Let me know either way.

[ updated plugin: http://forum.coppermine-gallery.net/index.php/topic,79126.0.html ]

[sjj1805]

Ron4Mac,
Thank you for your prompt reply. I have replaced the plug in with your new on version 1.4.4 and it now works perfectly.
Thank you