This message is thrown on update from 7.16 to 7.17.

Comments

David_Rothstein’s picture

David_Rothstein commented
Status: Active » Postponed (maintainer needs more info)

This would be related to #218004: Allow aggregator feed URLs longer than 255 characters, but I was unable to reproduce this.

In my Drupal 7.16 installation, I don't see any key defined for the 'link' column in the first place (in either the {aggregator_feed} or {aggregator_item} table) and the Drupal 7.17 update function doesn't try to add one either, so I don't understand how this could occur.

Is it possible someone modified the database tables on this site manually (at some point) to add a key on this column?

mikhailian’s picture

mikhailian commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)

Is it possible someone modified the database tables on this site manually (at some point) to add a key on this column?

The problematic table was defined as follows:

CREATE TABLE `aggregator_item` (
  `iid` int(10) NOT NULL AUTO_INCREMENT,
  `fid` int(10) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `link` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `author` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8_bin NOT NULL,
  `timestamp` int(11) DEFAULT NULL,
  `guid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`iid`),
  KEY `fid_link` (`fid`,`link`),
  KEY `fid` (`fid`)
) ENGINE=MyISAM

I made a quick search on google, and fid_link does not seem to come up, so your explanation is quite plausible. IIRC, the site existed since Drupal 4.7. As none comes up with similar bug report, we should definitely close this one.