Critical Error when re-installing the Iscroll plugin

[mfjones]

I recently removed the beautifully working iscroll plug-in from my cpm gallery using the config/general settings/manage plug-ins, delete button. Now I am trying to reinstall it but I get this message. "Critical Error – There was an error while processing a database query." It is followed by this code and a file path to /functions.inc.php – Line 250.

Code Select Expand

While executing query "INSERT INTO config VALUES('iscroll_cfg_meta', '1'), ('iscroll_cfg_count', '24'),('iscroll_cfg_width', '800'), ('iscroll_cfg_height', '250') " on 0

mySQL error: Duplicate entry 'iscroll_cfg_meta' for key 1

It appears the manage plugins delete function has left these files somewhere in my gallery. I have followed the path to /functions.inc.php Line – 250, but have found nothing there that resembles the information above. Even if it did I'm a php novice and would not know what to do with the information anyway. Can someone please help.


http://www.michaelfjones.com

[Joachim Müller]

I guess you're refering to the plugin "Image Scroller - Based on iTunes - Slideshow for Main and Album List Pages v1.1".
Looks like the uninstall routine of that plugin didn't work as expected and left the settings behind. Now the install routine complains about the settings already being present. In an ideal world, both the uninstall as well as the install routines would be better of that plugin (imo they suck, as suggested in another plugin by that author). To fix that issue for you, either manually delete the leftover database records (if you know your way around) or modify codebase.php with a plain text editor, find

Code Select Expand

$sql = "INSERT INTO {$CONFIG['TABLE_CONFIG']} VALUES('iscroll_cfg_meta', '1'), ('iscroll_cfg_count', '24'),('iscroll_cfg_width', '800'), ('iscroll_cfg_height', '250') ";and replace with

Code Select Expand

$sql = "INSERT IGNORE INTO {$CONFIG['TABLE_CONFIG']} VALUES('iscroll_cfg_meta', '1'), ('iscroll_cfg_count', '24'),('iscroll_cfg_width', '800'), ('iscroll_cfg_height', '250') ";

http://www.michaelfjones.com

That page doesn't contain a coppermine-driven gallery. When posting on this forum it's mandatory to post a link to your coppermine-driven gallery and not just to your home page.

[Joe Carver]

New release to address issue

[mfjones]

Thank you Gau Gau for your fast response. As suggested I removed the suspected code and added the replacement code to the codebase.php page. Now when i install iscroll the plugin manager shows install was successful as well as iscroll's configuration. However, when I return to my home page or album page I can see a space where iscroll should load but nothing happens iscroll does not show up?

Also, my link should work now. Sorry, I forgot to set up the redirect.

http://michaelfjones.com

[Joe Carver]

You need to read the thread + instructions for the plugin. iScroll for Coppermine

Security updates implemented in version 1.1 prevent the script from being run by any/all domains. (the short story)

Because you have a redirect, you will need to confirm your settings for "URL of Coppermine" in Config. You might also need to setup/add a file "crossdomain.xml".

It's all in the original thread - so is a newer version with these same instruction.

[mfjones]

Thanks Joe for your response. I assumed the problem with not being able to see  the plugin working on my cpm site was related to the initial problem of re-installing it. I went back and reread the threads and tried the "crossdomian.xml" and now it works beautifully.

Thank you for the plugin and thanks to you and GauGau for the help.

[Joachim Müller]

Board rules: Resolve your threads