Here’s why you’re seeing this error message on your site and how to fix it.
Why am I seeing this message?
This error message displays if your site is missing one or more of the following database permissions:
- ALTER
- INDEX
- DROP
These are basic database commands that Independent Analytics needs to operate. Without the ability to run these commands, it may crash during an update. For this reason, the error message is shown before an actual error occurs so that the permission can be granted and the analytics can resume operating.
How to fix the error
If these steps seem too technical for you to fix on your own, please ask your host to enable these permissions for you, or reach out to us, and we can help.
The first step is to access your site’s database. If you login to your hosting account, you should see a tool called phpMyAdmin that will allow you to view and edit your database. Your host may call it something like “Database access” instead.
Inside phpMyAdmin, start by selecting your site’s database in the left sidebar, and then click on the Privileges tab at the top of the screen.
If your sidebar has numerous databases and you’re not sure which one is for your site, check your site’s wp-config.php file. It will include the database name (DB_NAME) at the top of the file. You’ll find the database username right below it, which you’ll need in the next step.
In the Privileges menu, locate your site’s database user and click the Edit privileges link.
Lastly, check the box next to each privilege Independent Analytics needs, and then press the Go button at the bottom to save your changes.
Most likely, you only need to check the box next to ALTER and/or INDEX and then click the Go button to save. However, the full required permissions are SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, and DROP.
Please do not disable any permissions that are already selected. While they may not be needed for Independent Analytics, your host probably has a good reason for enabling them in the first place.
Once this change is made, visit the Analytics menu in your WP website, and you’ll see the error message has gone away.