SQL query:

CREATE TABLE `feeds_item` (
`entity_type` varchar( 64 ) NOT NULL DEFAULT '' COMMENT 'The entity type.',
`entity_id` int( 10 ) unsigned NOT NULL COMMENT 'The imported entity’s serial id.',
`id` varchar( 128 ) NOT NULL DEFAULT '' COMMENT 'The id of the importer that created this item.',
`feed_nid` int( 10 ) unsigned NOT NULL COMMENT 'Node id of the source, if available.',
`imported` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Import date of the feed item, as a Unix timestamp.',
`url` text NOT NULL COMMENT 'Link to the feed item.',
`guid` text NOT NULL COMMENT 'Unique identifier for the feed item.',
`hash` varchar( 32 ) NOT NULL DEFAULT '' COMMENT 'The hash of the source item.',
PRIMARY KEY ( `entity_type` , `entity_id` ) ,
KEY `id` ( `id` ) ,
KEY `feed_nid` ( `feed_nid` ) ,
KEY `lookup_url` ( `entity_type` , `id` , `feed_nid` , `url` ( 255 ) ) ,
KEY `lookup_guid` ( `entity_type` , `id` , `feed_nid` , `guid` ( 255 ) ) ,
KEY `imported` ( `imported` )
);

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

CommentFileSizeAuthor
#3 feeds_node_982980.patch1.03 KBliberatr

Comments

meba’s picture

I have the same...

Canadaka’s picture

I had the same error when trying to install this module.

My server is running MySQL 5.1.34-community and PHP 5.2.13

liberatr’s picture

StatusFileSize
new1.03 KB

This is caused by UTF8 characters. I found this related thread on the MySQL forum: http://bugs.mysql.com/bug.php?id=6604

I changed the last part of both indexes from (255) to (128). I don't know how this will affect the indexing, but hopefully it won't.

mchelen’s picture

Thanks, that fixed the problem! To correct any SQL backups just make the same edits to the line starting with CREATE TABLE `feeds_item`

Niklas Fiekas’s picture

Closed as a duplicate of #1044882: table feeds_item could not be created pdo exception key was too long, which is, of all the issues about this problem, the one chosen by a fair dice roll.

The patch over there is the same, only that it also patches the update functions.

Niklas Fiekas’s picture

Status: Active » Closed (duplicate)