Plugin issues – login issues, activation, reinstallation

What happens when you load the admin console? Is it completely blank or does some of the menu’s come up?

Have you checked your PHP error logs?

When I try to load the admin area, it remains blank and Firefox tries to load the page infinitely. I have not yet checked the logs as I’m not sure where to find them but will look for them later today.

Initially I suspected a memory issue so I increased memory_limit in my php.ini file from 128 to 256 but that doesn’t seem to have had any effect.

Memory is certainly one area that could cause it, but it sounds like something fundamental has gone wrong. You’ll need to get access to your PHP logs to see what the root cause might be.

I can’t seem to post my log entries here so I’ve uploaded my log to here.

I’m not sure if the ‘not found’ entries occurred because I deleted the entries from the PHP table. The entries prior to July should not be an issue either as this only occurred in the past few days but I have included the entire log anyway.

Can you verify the tables exist in you database?

Also delete the maxmind database, it will be in your wordpress/wp-content/uploads/wp-statistics directory.

I have deleted everything in my database related to wp statistics. I also deleted the wp-statistics directory in wordpress/wp-content/uploads. I then attempted to reinstall the plugin cleanly but it won’t activate properly. After clicking “Activate”, I become unable to access the wp-admin area until I disable the plugin by renaming the folder via ftp.

The following entries are made in the database after unsuccessful activation:

wp_uvyn_statistics_exclusions
wp_uvyn_statistics_historical
wp_uvyn_statistics_pages
wp_uvyn_statistics_useronline
wp_uvyn_statistics_visit
wp_uvyn_statistics_visitor

They have 0, 0, 11, 6, 1, 23 rows respectively.

These are the new entries in my PHP error log:

[11-Jul-2015 15:26:45 UTC] WordPress database error Table ‘zxzxzxin_wo9242.wp_uvyn_statistics_historical’ doesn’t exist for query SHOW COLUMNS FROM wp_uvyn_statistics_historical LIKE ‘key’ made by activate_plugin, include_once(‘/plugins/wp-statistics/wp-statistics.php’), include_once(‘/plugins/wp-statistics/wps-install.php’)
[11-Jul-2015 15:26:45 UTC] WordPress database error Can’t DROP ‘date_ip’; check that column/key exists for query DROP INDEX date_ip ON wp_uvyn_statistics_visitor made by activate_plugin, include_once(‘/plugins/wp-statistics/wp-statistics.php’), include_once(‘/plugins/wp-statistics/wps-install.php’)

Is there any way that I could try a completely clean installation? WP Statistics has been working great for me since I installed it in May this year.

Those are both expected warnings during an install/re-activation.

To completely remove it from your install and try a clean install do the following:

First, delete the plugin files which can be found in your WordPress/wp-content/plugins/wp-statistics folder.

Then Execute the following SQL commands:

DELETE FROM wp_uvyn_options WHERE option_name LIKE 'wp_statistics%'
DELETE FROM wp_uvyn_usermeta WHERE meta_key LIKE 'wp_statistics%'
DROP TABLE IF EXISTS  wp_uvyn_statistics_useronline,  wp_uvyn_statistics_visit,  wp_uvyn_statistics_visitor,  wp_uvyn_statistics_exclusions,  wp_uvyn_statistics_pages,  wp_uvyn_statistics_historical

I have deleted the plugin files, run those SQL commands and verified that those entries are no longer in the database. However, I still have issues in activating the plugin where my browser appears to be loading the page forever and I become unable to access wp-admin. Given that this doesn’t work, I’m not sure what else to try so unfortunately I don’t think I’ll be using WP statistics anymore.

Thanks so much for your swift assistance though, your plugin was excellent while I used it.

Any time, the only other reasons I can think of that it’s having issues is a conflicting plugin or something changed at your service provider (perhaps a new PHP version with a problem).

You could disable all other plugins and see if that helps and also see if your provider has a different version of PHP you could try.