After upgrading to D5, I'm attempting to migrate aggregator2 to aggregation.

After my first attempt, I received many column errors. Here are two examples of the errors:

Column count doesn't match value count at row 1 query: INSERT INTO aggregation_feed VALUES (526, '', 

'http://feed.com/wn/index.xml', '', '', 180, 0, 'no', 'yes', 'no', 'no', 

'no', 'no', 0 ,'no', 'yes', 'a:0:{}', '\"fe248ae3eeb7c61:df0\"', 1154714007, 1217162133) in 

/httpdocs/includes/database.mysql.inc on line 172.

Unknown column 'link_to_original_url' in 'field list' query: INSERT INTO aggregation_item (nid, url, link_to_original_url, original_author, 

story_guid, fid, image_id, image_guid) VALUES (5115, 'http://www.feed.com/Insidious.htm', 'yes', 

'unspecified', 3144924021, 516, 0, 0) in /httpdocs/includes/database.mysql.inc on line 172.

I think this is because the table columns in my database doesn't match up with what aggregation is looking for. Any advice on how to correct this? I'm using the latest release of aggregation for D5, 4.4.

Comments

hadishon’s picture

hadishon commented
Category: support » bug

I found a similar issue that seems like the same problem here: http://drupal.org/node/190552

It seems as thought the 4.4 version of aggregation has expects a different database shema then aggregator2 provided for 4.7.

Any advice on which version of aggregation to use to import my data?

Here is the what my aggregator2 tables look like:

CREATE TABLE `aggregator2_feed` (
  `nid` int(10) NOT NULL default '0',
  `author` varchar(60) NOT NULL default '',
  `freezed` int(4) NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `refresh` int(10) NOT NULL default '0',
  `clear_items` int(10) NOT NULL default '1000000000',
  `update_items` int(4) NOT NULL default '1',
  `guid_items` int(4) NOT NULL default '0',
  `promoted_items` int(10) NOT NULL default '1000000000',
  `checked` int(10) NOT NULL default '0',
  `link` varchar(255) NOT NULL default '',
  `image` longtext NOT NULL,
  `etag` varchar(255) NOT NULL default '',
  `modified` int(10) NOT NULL default '0',
  `item_status` int(4) NOT NULL default '0',
  `item_taxonomy` longtext NOT NULL,
  `item_date_source` tinyint(3) unsigned NOT NULL default '0',
  `item_show_link` tinyint(3) unsigned NOT NULL default '0',
  `item_delete_mode` int(4) NOT NULL default '0',
  PRIMARY KEY  (`nid`),
  UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

and

CREATE TABLE `aggregator2_item` (
  `nid` int(10) NOT NULL default '0',
  `fid` int(10) unsigned NOT NULL default '0',
  `author` varchar(60) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `guid` varchar(255) NOT NULL default '',
  `source_link` varchar(255) NOT NULL default '',
  `source_title` varchar(128) NOT NULL default '',
  `source_xml` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`nid`),
  KEY `fid` (`fid`),
  KEY `link` (`link`),
  KEY `guid` (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
hadishon’s picture

hadishon commented

I uninstalled aggregation 4.4 and installed 3.1 and ran the import.

I received this error for each feed:
Illegal offset type in /var/www/vhosts/activefarming.org/httpdocs/modules/aggregation/aggregation.install on line 264.

I then updated aggregation to 4.4.

So far it seems to be working although, I haven't found out how to view the feed controls yet though...

Ashraf Amayreh’s picture

Ashraf Amayreh commented
Status: Active » Closed (fixed)

Closing...