table docapi_library: specified key was too long
kriskras - September 16, 2009 - 12:16
| Project: | Document Import API |
| Version: | 6.x-2.0-alpha2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
When trying to enable the docapi module I got this warning.
user warning: Specified key was too long; max key length is [error]
1000 bytes
query: CREATE TABLE docapi_library (
`doc_id` INT unsigned NOT NULL auto_increment,
`plugin_id` INT unsigned NOT NULL,
`uid` INT unsigned NOT NULL,
`filemime` VARCHAR(255) NOT NULL DEFAULT
'text/plain',
`filename` VARCHAR(255) NOT NULL DEFAULT '',
`filepath` VARCHAR(255) NOT NULL,
`filesize` INT unsigned NOT NULL,
`created` DATETIME NOT NULL,
`changed` DATETIME NOT NULL,
PRIMARY KEY (doc_id),
INDEX filepath_name (filepath, filename)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ in
/home/kris/workspace/drupal6/includes/database.inc on line 517.Obviously, there's something wrong with the SQL syntax.

#1
I should add that when I just run the code through mysql, I got no error at all!