WordPress Backup to Dropbox Error Resolution

I discovered that I had some massive error_log files on my WordPress weblogs today.  One was 111 MB.  All were filled with lines like these:

[05-Mar-2016 11:01:33 UTC] WordPress database error Column ‘offset’ cannot be null for query INSERT INTO `ckhome_wpb2d_processed_files` (`file`, `uploadid`, `offset`) VALUES (‘/home/countryk/public_html/wp/wp-admin/network/update.php’, NULL, NULL) made by do_action_ref_array, call_user_func_array, run_dropbox_backup, WPB2D_BackupController->execute, WPB2D_BackupController->backup_path, WPB2D_Processed_Files->add_files, WPB2D_Processed_Base->upsert

WordPress.com user RichHelms posted a fix for this here that I’ve successfully implemented.  His fix was this:

This is driving me nuts so I decided to look deeper.

The issue is file wordpress-backup-to-dropbox/Classes/Processed/Files.php

Toward the bottom of the program change from

$this->upsert(array(
‘file’ => $file,
‘uploadid’ => null,
‘offset’ => null,
));

to

$this->upsert(array(
‘file’ => $file,
‘uploadid’ => null,
‘offset’ => 0,
));

so change the offset default from null to 0 and the issue goes away

It should not be a problem but it seems some versions of MySQL are not handling defaults right. Hopefully if this is the solution Michael will update and release as 4.4.2

Thanks, Rich.  That seems to have corrected the issue here as well.

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.

Comments

No comments yet.

Leave a comment