I have fixed the above problem by deleting the tables, but it should be noted that the error messages are MIME encoded and not easily read 😉
The tables are created, but I now I receive Error retrieving the list of events from database. Please inform the plugin author about this. on the Enable/Disable Alerts option page, and on the main page I get:
An error occurred while loading data. Please try again in a few moments.
Hi Danhgilmore,
Thank you for showing interest in our plugin.
The first error is related to missing tables, hence since you deleted the tables and the new ones were created, the first part of the issue is solved.
As regards the second part of the issue, we are looking into replicating the issue. Should we need any further information we will get in touch. In the meantime stay tuned since we will release an update as soon as we have a fix.
Hi Danhgilmore,
I’d recommend a total cleanup and a new install by following the below procedure to solve this because unfortunately remotely it is quite difficult to troubleshoot such issues.
1. Uninstall plugin
2. Ensure these two tables are deleted:
2.a. wp_wordpress_auditlog
2.b. wp_wordpress_auditlog_events
(note: the prefix of the tables depends on the prefix you use)
3. Run the below query to return all of the plugin options stored in the wp_options table in the WordPress database (again, the prefix of the table depends on your database prefix):
SELECT * FROM wp_options WHERE option_name like ‘WPPH%’;
Once the values are returned, delete all of them.
4. Download and re-install the plugin.
If the issue persists, if possible we would like to have a look ourselves. This will help us identify the problem and fix your issue as soon as possible.
So if the problem persists, drop us an email on plugins@wpwhitesecurity.com.
Thank you.
I’ve followed all the steps that you listed, but I still get errors.
Audit Log Viewer – An error occurred while loading data. Please try again in a few moments.
Enable/Disable Alerts – Error retrieving the list of events from database. Please inform the plugin author about this.
Unfortunately I’m on a closed network, so I cannot share the URL. Is there some sort of logging that I can turn on to troubleshoot?
Ok no problem. The best next option is to enable debug and send us the log files.
NOTE: Do not post any links to log files here since they might contain sensitive information about your WordPress setup. Please send them to us by email in a password protected zip file on plugins@wpwhitesecurity.com.
To enable Debug
1. first download the latest version of the plugin (we just released versoin 0.6.1 which contains some fixes for debugging).
2. uncomment line 51 and 52 in the plugin file wp-security-audit-log.php
3. Once debug is enabled, 2 files will be created in the plugin directory:
1. debug.log
2. error.log
4. Reproduce the issue, copy the log files and send them to us for analysis.
Looking forward to hearing from you.
My solution was to install 0.5.1 again. 0.6.1 doesn’t work.
Hi Eric,
Thank you for showing interest in our plugin.
We found what is danhgilmore issue and we are working on a fix. Most probably it is not related to the problem you are encountering.
Therefore I would recommend you to open a new ticket here or send us an email on plugins@wpwhitesecurity.com so we can assist you.
Also note that downgrading to 0.5.1 is not recommended since future updates will be using the database structure of 0.6.1 and not of the older version. And you definitely need the fewer versions since the plugin will be monitoring much more activity on WordPress.
Looking forward to hearing from you.
Hi gents,
We finally fixed the issue (thanks to the feedback from danhgilmore) and can confirm that we also now support WordPress multisites that have been upgraded from the old WordPress MU.
Please download the latest version of the plugin to start monitoring activity on your WordPress multisites.
Should you have any queries, do not hesitate to get in touch.
Thank you for your support.
