title: #1071 - Specified key was too long; max key length is 1000 bytes
body: <p>I know questions with this title have been answered before, but please do read on. I've read thoroughly all the other questions/answers on this error before posting.</p>
  
  <p>I am getting the above error for the following query:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `pds_core_menu_items` (
    `menu_id` varchar(32) NOT NULL,
    `parent_menu_id` int(32) unsigned 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,
    PRIMARY KEY (`menu_id`),
    KEY `index` (`parent_menu_id`,`menu_link`,`plugin`,`alias`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>Does anyone have idea why and how to fix it?
  The catch is - this same query works perfectly on my local machine, and worked as well on my previous host. Btw.it's from a mature project - phpdevshell - so I'd guess these guys know what they are doing, although you never know.</p>
  
  <p>Any clue appreciated.</p>
  
  <p>I'm using phpMyAdmin.</p>