Row in database full

Hi,

You can just empty the table contents from phpmyadmin, but do not delete the table.

Before you remove all the rows from the table are you able to check what it’s been filled up with?

A few others have reported this and theirs are filled with failed login attempts.

Now you can either look into preventing them brute force attempts which will stop the logging.

Or if you don’t care about the attempts you can either ignore them and change the automatic cleanup time, or prevent them from logging at all.

By default logs older than 90 days are removed, you can change that time by adding this constant to your wp-config:

define(‘AIOWPSEC_PURGE_AUDIT_LOGS_AFTER_DAYS’, 10);

That will remove logs older than 10 days.

Or if you don’t want to log some or all events you can use the following filter:

‘aios_audit_log_record_event’

Best Wishes,

Ashley

Hi @alexisfontana74

Sorry I am not getting line in database means the total table size for the mp_aiowps_audit_log table? If yes and want to delete old records than 1 Aug 2023 as per unix epoch time. you may run below query in database. or change last created value as per you want to delete old records

DELETE from mp_aiowps_audit_log WHERE created < 1690848000

Hello @aporter ,

Thank you for your feedback.

I deleted all the rows from the database and the problem disappeared.

Best regards,