Automated Database Backups not working

[technicalguy]

We have started to have an issue with the Automated Database Backups with our WHMCS. It doesn't work.

 

I have gone to Setup > Other > Database Backups and put in our Email address for the Daily Email Backups, and hit Save Changes.

 

We never get any email with a backup. I've checked the Activity log, and the Cron job is running as normal with no problems. All automated emails and invoices are getting sent as normal.But there isn't even a mention of creating or sending a database backup, as if it's not even trying to do the backup.

 

I also tried a romote FTP location instead of just an email, same issue. Nothing gets uploaded. WHMCS doesn't even try to conect to the FTP location at all, and again nothing in the Activity log about creating or sending a backup.

 

I can manually create the backup with no errors or problems, and it's size is 2.8MB, so I don't think it's the size.

 

Without any kind of error message or anything this is really hard to troubleshoot. It's just doing... nothing.

 

Any help?

[twhiting9275]

Take a look through the system logs (admin -> utilities -> logs -> system activity logs), search through for 'cron'. The last entry should be

 

Cron Job: Done

 

If not, then you'll likely want to contact support

[technicalguy]

Yes there are plenty of "Cron Job: Done" messages. Like I mentioned in my thread, all of the crons are running and completing fine. With no errors.

 

The problem is not that the cron jobs are failing. It's that the cron log has no mention of creating, completing, or sending any kind of database backup.

 

So even though I have the database backups setup, it's not even trying to do them.

[brian!]

try removing the address, saving and then re-enter your address again.

 

also, check the tblconfiguration database table to see if the setting is in the database.

[technicalguy]

try removing the address, saving and then re-enter your address again.

 

also, check the tblconfiguration database table to see if the setting is in the database.

 

I've tried removing, saving, re-adding, saving both the email and ftp details with no fix.

 

I took a look at the tblconfiguration table and the email and ftp detials are filled out properly there, and they update instantly if I remove and add them back in WHMCS.

[brian!]

in the Activity Log, after the cron runs are you seeing a "Cron Completed" entries?

 

after the cron has run and done its tasks, you should get a "Cron Completed" entry and THEN it will attempt to backup the database...

 

 

I suppose a hook could prevent it from running, and 2.8M doesn't seem like it would cause an issue - might be worth having Support take a look - if only to rule out it being a WHMCS issue, rather than a server/php setting.

[technicalguy]

in the Activity Log, after the cron runs are you seeing a "Cron Completed" entries?

 

after the cron has run and done its tasks, you should get a "Cron Completed" entry and THEN it will attempt to backup the database...

 

 

I suppose a hook could prevent it from running, and 2.8M doesn't seem like it would cause an issue - might be worth having Support take a look - if only to rule out it being a WHMCS issue, rather than a server/php setting.

 

I'm definitely seeing the "Cron Complete" lines.

 

I have made a workaround for the issue by creating another cron job to run with the "do_backups" flag. Running that cron job works and creates the backup perfectly.

 

So obviously it can work, but for some reason the general cron job is skipping the backup part.