I created a brand-new, vanilla Drupal site on my Windows box. MySQL 5.0.45, PHP 5.2.0. On the modules page, I enabled FeedAPI, FeedAPI Node, FeedAPI Inherit, and Common syndication parser at the same time and clicked Save configuration. I got this:

user warning: BLOB/TEXT column 'statistics' can't have a default value query: CREATE TABLE if not exists feedapi ( nid int(10) unsigned NOT NULL default '0', url varchar(255) NOT NULL default '', feed_type varchar(50) NOT NULL default '', processors varchar(255) NOT NULL default '', parsers varchar(255) NOT NULL default '', checked int(10) NOT NULL default '0', items_delete int(10) NOT NULL default '-1', update_existing tinyint default '1', link varchar(255) NOT NULL default '', settings LONGTEXT, half_done tinyint, statistics longtext default '', PRIMARY KEY(nid)) in C:\Websites\feedtest\includes\database.mysql.inc on line 172.

The feedapi table was not created. Extracting the create table statement from feedapi.install, it fails per above on MySQL 5.0.45 on my Windows box, but works on MySQL 5.0.27 on my webhost WestHost (hmmm, have to admit I'm not sure what *ix flavor it's running...). Removing the default value from the statistics table allows it to be created.

Comments

aron novak’s picture

Assigned: Unassigned » aron novak
Status: Active » Fixed

Thanks for reporting this. I find out that this is an annoying misleading property of mysql: http://bugs.mysql.com/bug.php?id=25520
At the CVS DRUPAL-5 branch, or the next daily dev build, you'll find the fix.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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