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

david strauss’s picture

What version of MySQL are you running?

dennys’s picture

I'm using 5.0.45-community-nt on Windows XP

david strauss’s picture

Status: Active » Fixed

I've released an update that should fix this.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

greg.harvey’s picture

Good explanation here, for anyone chasing a similar issue:
http://www.calivia.com/blog/mike/mysql-innodb-specified-key-was-too-long...

a.michael.grant’s picture

Status: Closed (fixed) » Active