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
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | feeds_node_982980.patch | 1.03 KB | liberatr |
Comments
Comment #1
meba commentedI have the same...
Comment #2
Canadaka commentedI had the same error when trying to install this module.
My server is running MySQL 5.1.34-community and PHP 5.2.13
Comment #3
liberatrThis 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.
Comment #4
mchelenThanks, that fixed the problem! To correct any SQL backups just make the same edits to the line starting with CREATE TABLE `feeds_item`
Comment #5
Niklas Fiekas commentedClosed 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.
Comment #6
Niklas Fiekas commented