We're running 5.x-1.1-2 on a windows server and got the following error when installing the module:

user warning: BLOB/TEXT column 'feedback' can't have a default value query: CREATE TABLE spam_reported ( rid int(11) unsigned NOT NULL auto_increment, source varchar(64) NOT NULL default '', # node, comment, trackback, etc... id int(11) unsigned NOT NULL default '0', uid int(10) unsigned NOT NULL default '0', hostname varchar(128) NOT NULL default '', # source IP feedback text NULL default '', timestamp int(11) unsigned default '0', PRIMARY KEY rid (rid), KEY source (source), KEY id (id), KEY uid (uid) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in C:\Inetpub\wwwroot\ontrackeveryday.sean.thedude.tractiv.net\includes\database.mysqli.inc on line 151.

A bit of digging turned up this related post in the video module: http://drupal.org/node/143881

It references this mysql bug: http://bugs.mysql.com/bug.php?id=25520

Seems that (by default) windows and linux are inconsistent with how the text columns work so that windows throws an error when you have a default value. Removing just the default '' on the feedback line made my errors go away. Not sure if this is fixed in future versions or not.

Comments

jeremy’s picture

Status: Active » Fixed

Thanks, this is fixed in the 3.x development branch.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.