Online Stats Problem Online Stats Problem
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Online Stats Problem

Started by nowordneeded, March 12, 2012, 04:38:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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
Sometimes my musings are too confusing for someone not inside my head.

Α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
Sometimes my musings are too confusing for someone not inside my head.

Α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
Sometimes my musings are too confusing for someone not inside my head.

Αndré

Error message:
QuoteWhile 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
cpg_db_query("DELETE FROM {$CONFIG['TABLE_ONLINE']} WHERE last_action < NOW() - INTERVAL {$CONFIG['mod_updates_duration']} MINUTE");
and replace with
//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
Sometimes my musings are too confusing for someone not inside my head.