phpdevshell team mailing list archive

[Richard Hunter <question203322@xxxxxxxxxxxxxxxxxxxxx>]

New question #203322 on PHPDevShell:
https://answers.launchpad.net/phpdevshell/+question/203322

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

-- 
You received this question notification because you are a member of
PHPDevShell, which is an answer contact for PHPDevShell.