Tag: MySQL

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 […]

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 […]