+1 for the report
3 of my sites are down due to huge server storage (mostly form error_log) within 3 or more days after the last update
+1….
Happy I’m not the only one seeing this, but would love to see it fixed soon.
Files still seem to copy, but the backup eventually fails and then starts again in a few minutes
me too.
[Tue Jan 05 14:24:09 2016] [warn] mod_fcgid: stderr: WordPress database error Column ‘offset’ cannot be null for query INSERT INTO wp_wpb2d_processed_files (file, uploadid, offset) VALUES (‘/home/hairybarsnacks.com/public_html/blog/wp-content/uploads/2014/04/20140409_125304-e1397044830284-150×150.jpg’, 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
Thread Starter
iltrev
(@iltrev)
Same issue on a second site. This is becoming alarming.
I came across this problem as well. Looking at the code I think the issue is that the offset column on the wp_wpb2d_processed_files table should be auto-increment.
I was able to resolve the issue by making this change to that table:
ALTER TABLE wp_wpb2d_processed_files
ADD INDEX 'offset' ('offset'),
CHANGE 'offset' 'offset' INT(11) NOT NULL AUTO_INCREMENT;
I don’t think that this change will be preserved when the plugin is updated, so if there is a future update that doesn’t fix this bug, you’ll need to re-run this statement after the update.
Same thing happened here. Hope the next update will include @gavinbrown’s fix.
Hi everyone,
same issue here – caused my server to crash.
Could you please suggest what I should do to restore my website so I can delete the plugin in the meantime ?
Thanks for your help,
Regards.
Thread Starter
iltrev
(@iltrev)
@robert
As per https://codex.wordpress.org/Managing_Plugins#Uninstalling_Plugins
– log onto your server via ftp or cpanel
– navigate to the plugins folder (should be /wp-content/plugins)
– delete the wpb2db folder, or move it away from the containing folder if you want to put it back in the future
(still waiting for a feedback by the author, btw)
This has been fixed in version 4.4.1. Sorry for the delay.
Sorry but I have 4.4.1 installed and it is still happening
If I execute in PHPMyAdmin
INSERT INTO bt101_wpb2d_processed_files (file, uploadid, offset) VALUES (‘/home/richhelm/public_html/course/wp-content/themes/uber/single-project.php’, NULL, NULL)
I get the error #1048 – Column ‘offset’ cannot be null
If I try
INSERT INTO bt101_wpb2d_processed_files (file, uploadid, offset) VALUES (‘/home/richhelm/public_html/course/wp-content/themes/uber/single-project.php’, NULL, 0)
it works
The table is defined as
CREATE TABLE IF NOT EXISTS bt101_wpb2d_processed_files (
file varchar(255) NOT NULL,
offset int(11) NOT NULL DEFAULT ‘0’,
uploadid varchar(50) DEFAULT NULL,
UNIQUE KEY file (file)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
so it should default to 0 but why not just put in 0
This appears to be a MySQL issue with some version or interface. Problem is I can not change the version of MySQL and it looks like I am not alone.
i have upgraded to 4.4.1 and i am still having the same problems. time to disable until a fix is sorted.
Also having this issue under 4.4.1.
