Online Stats Problem

[nowordneeded]

I currently have about ten galleries I'm running CPM on and out of all of them, I only have this problem on one. The URL is: http://stephennichols.org/gallery . I am running 1.5.18 on it having upgraded last week. I didn't see the new version posted back in Jan. The problem is when I update the gallery the Online Stats plugin causes a Critical Error to occur and takes my gallery offline. But only this one. This problem started when I upgraded from 1.14.x to 1.15.x. What happens is that as long as the plug in is part of the package, it takes the gallery offline. When I delete the plugin through my FTP or remove it prior to uploading the upgrade files, it's fine. What could be causing this?

Thanks.

NWN

[Αndré]

I assume you've installed the plugin sometime before the update (so it's not just "there", but you also use it)?

Please enable debug mode and post the extended error message the plugin produces.

[nowordneeded]

Sorry I didn't reply to this before now. I've had personal issues to deal with and haven't been back online until today.

As for the plugin, no I'm not using it on this gallery. I've had to delete it from the plugins folder in order to allow the gallery to become visible. Otherwise it only shows CRITICAL ERROR in the page when I would go to access the index.php page. I should add some other information I'm sorry I omitted from my first post. I was moving the entire website from one account to another on Bravehost. I was able to do this and was also able to download the database from the other server account. However, when I went to view the gallery on the new server, I received the Critical Error page. I contacted my host to find out what I could do and they told me it might be in the plugin. I deactivated it and the gallery was fine. So when I upgraded from 1.15.16 to 1.15.18, the OnlineStats plugin was in the folder and I forgot to clear it. When I upgraded I got the Critical Error message. I went in through my FTP program and deleted the plugin and the gallery was back.

I'm not sure if I could enable debug mode on the plugin since the plugin is no longer in the folder.

NWN

[Αndré]

I'd like investigate that issue. Please enable debug mode and upload the plugin to your plugins directory.

[nowordneeded]

Done. You can find the gallery @ http://stephennichols.org/gallery . Again, I'm running 1.5.18.

Thanks.

NWN

[Αndré]

Error message:

While executing query 'DELETE FROM cpg14x_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE' in plugins/onlinestats/codebase.php on line 122

Obviously the config value "mod_updates_duration" doesn't exist in your database, causing an error in the SQL syntax.

To fix that issue, open codebase.php, find

Code Select Expand

cpg_db_query("DELETE FROM {$CONFIG['TABLE_ONLINE']} WHERE last_action < NOW() - INTERVAL {$CONFIG['mod_updates_duration']} MINUTE");
and replace with

Code Select Expand

//cpg_db_query("DELETE FROM {$CONFIG['TABLE_ONLINE']} WHERE last_action < NOW() - INTERVAL {$CONFIG['mod_updates_duration']} MINUTE");

As that line is just executed when the plugin is installed, go to the plugin manager and uninstall the onlinestats plugin. If you now replace the plugin with the unmodified files, the error shouldn't occur.

[nowordneeded]

The plugin is finally working. Thanks for the help Andre. I'm glad the issue is finally solved.

NWN