I’ve changed the permissions for WP Statistics access and now I’ve lost access to it myself, how to I fix it?

If you have access to phpMyAdmin (or similar tool) you can query the wp_options table:

SELECT * FROM wp_options WHERE option_name = 'wp_statistics';

Then edit the value, inside the string will be something like (note: “edit_plugins” will be whatever permission you selected):

s:15:"read_capability";s:12:"edit_plugins";s:17:"manage_capability";s:12:"edit_plugins";

Replace it with:

s:15:"read_capability";s:14:"manage_options";s:17:"manage_capability";s:14:"manage_options";

I’ve installed WP Statistics for the first time on a site and when I go to the statistics pages I get an error saying like “The following plugin table(s) do not exist in the database”

This is because something has gone wrong during the installation.

At the end of the message will be a list of tables that are missing, you can use the provided link to re-run the installation routine. If that does not resolve the issue and the visitors table is the only table listed, you may want to check your MySQL version. Some older versions of MySQL (in the 5.0.x series) have issues with complex compound indexes, which we use on the visitors table. If this is the case, check with your hosting provider and see if they can upgrade to a newer version of MySQL.

If you still have issues open a new thread on the support forum and we’ll try and resolve it for you.

Requirements

WP Statistics requires a few things to work:

  • WordPress 3.0 or above
  • PHP 5.4 or above
  • MySQL 5.0 or above

WP Statistics might work on older versions of the above software, but then again, it might not (it does NOT function on any PHP versions before 5.3).

The GeoIP support also requires a few additional items to function:

  • the cURL extension for PHP
  • PHP cannot be running in safe mode

WP Statistics requires a significant amount of RAM for the statistics pages, especially the overview page, make sure to set your PHP memory limit high enough to support it. While every site has different memory requirements, a reasonable rule of thumb is at least 36 megabytes and significantly higher is not unreasonable (128-256 megabytes).

Subscribe Newsletter

Sign up with your email address to receive news and updates.