Installation Issue - Specified key was too long; max key length is 1000 bytes

Asked by Richard Hunter on 2012-07-16

I have followed the instructions to install PHP DevShell and have created the database to the specification set out however during installation I get the following error:

An error occured trying to send the queries (query 14/527).
The error was: [1071] Specified key was too long; max key length is 1000 bytes
The offending query was: " CREATE TABLE `pds_core_menu_items` ( `menu_id` varchar(64) NOT NULL, `parent_menu_id` varchar(64) DEFAULT NULL, `menu_name` varchar(255) DEFAULT NULL, `menu_link` varchar(255) DEFAULT NULL, `plugin` varchar(255) DEFAULT NULL, `menu_type` int(1) DEFAULT NULL, `extend` varchar(255) DEFAULT NULL, `new_window` int(1) DEFAULT NULL, `rank` int(100) DEFAULT NULL, `hide` int(1) DEFAULT NULL, `template_id` int(32) unsigned DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `layout` varchar(255) DEFAULT NULL, `params` varchar(1024) DEFAULT NULL, PRIMARY KEY (`menu_id`), KEY `index` (`parent_menu_id`,`menu_link`,`plugin`,`alias`), KEY `params` (`params`(255)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8"

Only four tables are created in the database and the installation stops.

Your help would be greatly appreciated!

Thanks
Richard

Question information

Language:
English Edit question
Status:
Answered
For:
PHPDevShell Edit question
Assignee:
No assignee Edit question
Last query:
2012-07-16
Last reply:
2012-08-22
Greg (gregfr) said : #1

can you please check your mysql version?

thanks

greg

Greg (gregfr) said : #2

and also the charset of your database

Hi, the version is 5.0.95 using charset utf8 -- UTF-8 Unicode and collation utf8_general_ci

Thanks
Richard

TitanKing (titan-phpdevshell) said : #4

Hi Richard,

Is this on Windows, Mac or Linux? I do think that your MySQL version might be a bit old... it does not seem to be supporting larger indexes.

Is it on a shared host?

Greg (gregfr) said : #5

Now I'm hit by the same problem... it's really time for us to leave mysql, each new version is a new desaster :-(

Greg (gregfr) said : #6

I have no solution yet

Greg (gregfr) said : #7

This bug has been around since 2004:

http://bugs.mysql.com/bug.php?id=4541

I guess we hit it with the alphanumerical menu ID change.

We probably can work around it by changing the index definition.

TitanKing (titan-phpdevshell) said : #8

Yes I do think this is more of a design problem than just blaming MySQL. I do not think it is our call to move away from MySQL as such, but rather support more core db systems.

TitanKing (titan-phpdevshell) said : #9

Fixing the DB issues will be on my development agenda from the 27th August.

Can you help with this problem?

Provide an answer of your own, or ask Richard Hunter for more information if necessary.

To post a message you must log in.