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.

_______________________________________________
Mailing list: https://launchpad.net/~phpdevshell
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~phpdevshell
More help   : https://help.launchpad.net/ListHelp

Reply via email to