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
Comment #1
jeremy commentedThanks, this is fixed in the 3.x development branch.
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.