FYI - Running PHP 5.3.3, Drupal 6.19
Got this error when enabling the recommended version of Views Data Export (6.x-2.0-beta2):
user warning: BLOB/TEXT column 'sandbox' can't have a default value query: CREATE TABLE views_data_export ( `eid` INT unsigned NOT NULL auto_increment, `view_name` VARCHAR(32) NOT NULL DEFAULT '', `view_display_id` VARCHAR(32) NOT NULL DEFAULT '', `time_stamp` INT unsigned NOT NULL DEFAULT 0, `fid` INT unsigned NOT NULL, `batch_state` VARCHAR(32) NOT NULL DEFAULT 'init', `sandbox` TEXT NOT NULL DEFAULT '', PRIMARY KEY (eid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in database.inc on line 555.
Comments
Comment #1
steven jones commentedComment #2
steven jones commentedPatch attached.
Comment #3
steven jones commentedFixed in http://drupal.org/cvs?commit=462364 and http://drupal.org/cvs?commit=462362.
Many thanks for the bug report.
Comment #4
jcook4now commentedSure! Thanks for the quick patch.