Active
Project:
Feed Path Publisher
Version:
5.x-1.0-rc
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
26 Apr 2008 at 01:39 UTC
Updated:
19 Apr 2011 at 02:17 UTC
I got this message when I install it and I'm using Drupal 5.7. Is it due to the 1000 character limit of MySQL ?
# ser warning: Specified key was too long; max key length is 1000 bytes query: CREATE TABLE feed_path_publisher ( `fppid` int(10) unsigned NOT NULL auto_increment, `title` varchar(50) NOT NULL, `path_prefix` varchar(200) NOT NULL, `feed` varchar(200) NOT NULL, PRIMARY KEY (`fppid`), UNIQUE KEY `path_prefix` (`path_prefix`,`feed`), KEY `listing` (`path_prefix`,`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; in D:\WWW\includes\database.mysql.inc on line 172.
# user warning: Table 'drupal5.feed_path_publisher' doesn't exist query: SELECT title, feed FROM feed_path_publisher WHERE path_prefix = LEFT("admin/build/modules", LENGTH(path_prefix)) in D:\WWW\includes\database.mysql.inc on line 172.
Comments
Comment #1
david straussWhat version of MySQL are you running?
Comment #2
dennys commentedI'm using 5.0.45-community-nt on Windows XP
Comment #3
david straussI've released an update that should fix this.
Comment #4
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.
Comment #5
greg.harveyGood explanation here, for anyone chasing a similar issue:
http://www.calivia.com/blog/mike/mysql-innodb-specified-key-was-too-long...
Comment #6
a.michael.grant commented