DB Backup Not Working

Deactivated all plugins one by one, still no good. Switched to 2014 default wordpress theme and still no good.

Found this error in the error_log file

[12-Oct-2014 20:02:30 UTC] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 213306 bytes) in /home/dcrosbie1/public_html/gymkyds.com/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-backup.php on line 57

So I added this to my config file:
define(‘WP_MEMORY_LIMIT’, ‘256M’);

Solved the error in the error_log, but still a blank screen after the BD Backup tab, and still no backup in the wp-content/aiowps_backups directory.

Hi dcrosbie can you also ask your Host, how much memory has being allocated to your account?

In regards to your comment above….

I run this plugin on many websites across various servers, but never a problem, but just with this website it is not working. I even have this website on the same server as my other websites where it seems to be working fine.

What are the difference between the websites that work and this one that does not work?

Thank you

I am digging through, and honestly I can’t find any differences between this website and the others. I manage 20 different websites and I always install the same plugins etc. Besides, I even tried deactivating all plugins and changing the theme and still no good.

These are the other websites that I am running on this same server:

• another website also on wordpress 4.0, but an older all in one security, version 3.8.3 – this one works for database backups.
• another website running wordpress 3.9.2 and security plugin at 3.7.9.1 – does database backup no problem
• another website running wordpress 3.9.2 security plugin at 3.7.9 – does database backups
• another website running wordpress 3.9.2 security plugin 3.7.6 – does database backups

Only other difference are plugins and theme but I tried deactivating/switching themes and that still did not solve my problem.

Since up’d the memory I no longer get that memory error, but it is still not creating the DB Backups.

I even see the cron job is at least now running, I can see it in plugins/all-in-one-wp-security-and-firewall/logs/wp-security-log-cron-job.txt but it is still not running the backups.

My host says I have 512MB allocated to my account, and so far I am never hitting that.

Hi thank you for all that information.

Can you check to see if there is a difference in the backup path from the sites that work and the site that does not work? Also check the folder and file permissions.

Thank you

Where do I see what the backup path is set to?

As for folder/file permissions I have already checked those and they appear to be same as other websites. 755 for folders and 644 for files.

Hi the backup path will be something like….

/wp-content/aiowps_backups/your backup file.zip

Also what you can try is deactivate and delete the plugin. Then reinstall a fresh copy of the plugin again. That might help.

@dcrosbie,
How many records do you have in the “aiowps_events” table?

124015 rows in the aiowps_events table.

Now looking at the aiowps events table, I see that there are recently TONS of 404’s, every second or two by the same ip, I wonder why the plugin is also not working to block these ips? I double checked I do have 404 detection turned on, but still it is not blocking.

So then I went to the 404 event logs to see if I could see the 404 events on through the website backend, but it seems that this “404 event logs” is not working as expected either, right after the header “404 event logs” all is blank, when I click the header nothing happens.

Yeesh, I am looking faith in this plugin a little. I guess I will log into my other client sites and see if this part is working also.

K, I deleted this plugin all together and reinstalled. Still no good. No DB backups, no 404 detection ip blocking, no backend admin listing of 404 error log.

I would assume all these problems are tied to the same source, but I just can’t figure out what.

Digging deeper, I figured I would try to delete all events in the log table, but on the firewall –> 404 detection tab, nothing was showing after the header “404 Event Logs”, so I couldn’t get down to the button to “Delete All 404 Event Logs”. So I went manually into the aiowps_events through phpmyadmin and delete all records from inside there. Now… everything works! I can see the 404 events logs on the firewall–>404 tab AND DB backups work.

So… what does this mean? Well obviously the aiowps_events table was just to big and was making many of the plugin functions unable to work. How to fix this from happening again? I guess two things need to be looked at:

• Why was my event logs table so big? Why didn’t the plugin stop the 404 ip’s and failed login ip’s before my event table became so full? I guess I will be keeping an eye on the plugin to ensure that ip blocking is working correctly for lockouts on 404 errors or failed login attempts.
• As for preventing the plugin from failing when this table gets to full… that would be up to the plugin author I guess. Maybe it should auto clear after X records, or maybe it should never fail no matter how many records, or maybe email the user a warning message when the table is getting to full?

@wpsolutions any suggestions?

Hi @dcrosbie, there are a few questions I would like to ask you.

In your original question above how long had you had the plugin running before you noticed that it was not backing up?

In regards to your next comment….

So I added this to my config file:
define(‘WP_MEMORY_LIMIT’, ‘256M’);

If the bottled next problem had already occurred the above actioned fixed partially the issue but if the log file was too large then the problem was still there.

Finally when you deleted the plugin, did you delete everything i.e. files, logs files, backup etc from the plugin?

Regards