404 event log

Hi,

You can clean up that table sooner by using the following define:

define(‘AIOS_PURGE_EVENTS_RECORDS_AFTER_DAYS’, 30);

That will clean logs older than 30 days, you can change the number to what ever you want by default it’s 90.

The next release which should be out early next week will have a fix in it to stop the message_store table filling up with unused entries.

Best Wishes,

Ashley

This attempt crashed the site.

The wp_aiowps_message_store tabel is now over 170Mb. I need to be able to optimize the tables in the database.

We are now reaching 200Mb. This plugin really bloats your database to the extreme. And your support is non existent.

Hi,

Sorry this thread has been marked as resolved and so I missed your previous messages.

What crashed the site?

Are you running the latest version of the plugin?

As mentioned in my previous message version 5.2.5 will stop the wp_aiowps_message_store table from growing.

You could manually clear all the entries in that table to reduce the size.

Best Wishes,

Ashley

Using this: define(‘AIOS_PURGE_EVENTS_RECORDS_AFTER_DAYS’, 30);
crashed the site.

I am running the latest version of the plugin. And even if the latest version seemed to have stopped the database from growing even bigger, the message_store table is still almost 200Mb.

I don′t know if I am comfortabel roaming around i phpMy admin. Could you provide a step by step on how to manually clear all the entries? And clearing all the entries in that table will not affect the plugin in general?

Regards
Nina

Hi Nina,

It seems the forums have messed up the formatting on that line it has changed the ‘ to ‘ when you copy and paste it.

You either need to manually type it out or change the ‘ back into ‘

As for the table if your not comfortable deleting all records from that table in PHPMyAdmin you can uncomment a line in the plugin that should then move the data from the message store into the audit log.

You will then be able to delete them entries from the audit log via the UI in the plugin.

In the file:

/all-in-one-wp-security-and-firewall/src/classes/wp-security-audit-events.php

On line 58

It looks like this:

// add_action(‘plugins_loaded’, ‘AIOWPSecurity_Audit_Events::rule_event’, 10, 2);

You need to remove the //

So it will then look like this:

add_action(‘plugins_loaded’, ‘AIOWPSecurity_Audit_Events::rule_event’, 10, 2);

If you save the file and then visit the AIOS settings page it should move that data into the audit log.

You can then use the bulk actions on the audit log to delete all the data.

Best Wishes,

Ashley

I will try this solution. How long before you can see the effect of this workaround?

Regards
Nina

Hi Nina,

The data should move from the message store to the audit log straight away.

You then just need to manually remove the data from the audit log.

Best Wishes,

Ashley

aiowps_message_store table in the databae is still almost 200Mb. It does not seem to have moved anything anywhere after revmoing //.

One thing is your file reference /all-in-one-wp-security-and-firewall/src/classes/wp-security-audit-events.php. I do not have a /src/ folder in my files.

Regards
Nina

Hi Nina,

Sorry about the “src” thats from the development copy and doesn’t exist in the full release, so the correct path is:

all-in-one-wp-security-and-firewall/classes/wp-security-audit-events.php

After making the change to that file and saving it did you visit the AIOS plugin page?

Best Wishes,

Ashley

Yes I did. The aiowps_message_store table is still almost 200 Mb. I really need to reduce this.

Regards
Nina

Hi Nina,

Thats odd, ok attached is an mu-plugin:

https://gofile.io/d/yE5VCe

If you upload that to your mu-plugins folder located at:

wp-content/mu-plugins

If the mu-plugins folder doesn’t exist you can create it.

Drop the file in and then visit the backend of your site, that should clear the table for you.

Once the table has been cleared remove the mu-plugin.

Best Wishes,

Ashley

Clicking on the link got me to a webpage that said “the files does not exist”

Regards
Nina

Hi,

I’m not sure why but the link works for me.

How about this one:

https://we.tl/t-OtbH37sw7h

Best Wishes,

Ashley