I got this error while installing.

    * user warning: BLOB/TEXT column 'aggregation_feed_options' can't have a default value query: CREATE TABLE IF NOT EXISTS aggregation_feed ( `nid` int(10) unsigned NOT NULL, `original_author` varchar(100) NOT NULL default '', `url` varchar(250) NOT NULL, `username` varchar(50) NOT NULL default '', `password` varchar(50) NOT NULL default '', `refresh_interval` int(10) unsigned NOT NULL, `title_as_guid_interval` int(10) unsigned NOT NULL, `promote_to_frontpage` int(10) NOT NULL default 0, `time_to_live` int(10) NOT NULL default 0, `item_categories` varchar(150) NOT NULL default '', `aggregation_feed_options` text NOT NULL default '', `etag` varchar(255) NOT NULL default '', `last_modified` int(11) NOT NULL default 0, `last_refreshed` int(11) NOT NULL default 0, PRIMARY KEY (`nid`) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in E:\Install\xampp\htdocs\demo1\includes\database.mysqli.inc on line 151.
    * user warning: BLOB/TEXT column 'aggregation_item_options' can't have a default value query: CREATE TABLE IF NOT EXISTS aggregation_item ( `nid` int(10) unsigned NOT NULL, `url` varchar(250) NOT NULL default '', `aggregation_item_options` text NOT NULL default '', `original_author` varchar(100) NOT NULL default '', `original_comments` varchar(250) NOT NULL, `story_guid` int unsigned NOT NULL default 0, `fid` int(10) unsigned NOT NULL default 0, `image_id` int(10) unsigned NOT NULL default 0, `image_guid` int unsigned NOT NULL default 0, PRIMARY KEY (`nid`), INDEX (`story_guid`), INDEX (`image_id`), INDEX (`fid`), INDEX (`image_guid`) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in E:\Install\xampp\htdocs\demo1\includes\database.mysqli.inc on line 151.

I have created these tables manually.
--
Sharique

Comments

ijulie’s picture

ijulie commented

Indeed, I also got errors when trying to run the update. First of all, update.php didn't detect the necessary update automatically. I set it to "1" and got these errors:

* user warning: Duplicate column name 'aggregate_to_moderation_queue' query: ALTER TABLE aggregation_feed ADD aggregate_to_moderation_queue enum('yes', 'no') NOT NULL default 'no' AFTER publish_new_items in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'sticky_items' query: ALTER TABLE aggregation_feed ADD sticky_items enum('yes', 'no') NOT NULL default 'no' AFTER aggregate_to_moderation_queue in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'enable_comments_on_articles' query: ALTER TABLE aggregation_feed ADD enable_comments_on_articles enum('yes','no') NOT NULL default 'no' AFTER sticky_items in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'enable_comments_on_images' query: ALTER TABLE aggregation_feed ADD enable_comments_on_images enum('yes','no') NOT NULL default 'no' AFTER enable_comments_on_articles in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'promote_to_frontpage' query: ALTER TABLE aggregation_feed ADD promote_to_frontpage int(10) NOT NULL default 0 AFTER enable_comments_on_images in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'link_items_to_original_urls' query: ALTER TABLE aggregation_feed ADD link_items_to_original_urls enum('yes', 'no') NOT NULL default 'yes' AFTER delete_old_items in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'link_to_original_url' query: ALTER TABLE aggregation_item ADD link_to_original_url enum('yes', 'no') NOT NULL default 'yes' AFTER url in /home/russoj/public_html/includes/database.mysql.inc on line 121.
* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/russoj/public_html/update.php on line 307.
* warning: Invalid argument supplied for foreach() in /home/russoj/public_html/update.php on line 517.

and below, the corresponding failures:

Update #1

* Failed: ALTER TABLE {aggregation_feed} ADD aggregate_to_moderation_queue enum('yes', 'no') NOT NULL default 'no' AFTER publish_new_items
* Failed: ALTER TABLE {aggregation_feed} ADD sticky_items enum('yes', 'no') NOT NULL default 'no' AFTER aggregate_to_moderation_queue
* Failed: ALTER TABLE {aggregation_feed} ADD enable_comments_on_articles enum('yes','no') NOT NULL default 'no' AFTER sticky_items
* Failed: ALTER TABLE {aggregation_feed} ADD enable_comments_on_images enum('yes','no') NOT NULL default 'no' AFTER enable_comments_on_articles
* Failed: ALTER TABLE {aggregation_feed} ADD promote_to_frontpage int(10) NOT NULL default 0 AFTER enable_comments_on_images

Update #2

* Failed: ALTER TABLE {aggregation_feed} ADD link_items_to_original_urls enum('yes', 'no') NOT NULL default 'yes' AFTER delete_old_items
* Failed: ALTER TABLE {aggregation_item} ADD link_to_original_url enum('yes', 'no') NOT NULL default 'yes' AFTER url

I don't have quite the grasp on mysql to sort this out manually. I tried running these failed queries (um, like ALTER TABLE aggregation_item (ADD link_to_original_url enum('yes', 'no') NOT NULL default 'yes' AFTER url); ?) and keep getting syntax errors.

It seems that my aggregator2 databases have been correctly updated with their contents, but none of the feed items are linked to their feeds (there are no aggregation links on the nodes at all). I'd really appreciate some help!

example feed: http://j-l-r.org/node/27
example feed item: http://j-l-r.org/node/881 (when I edit it, it seems to know that it's part of the correct feed... ?)