Am 15.01.21 um 09:01 schrieb Luuk:
On 14-1-2021 21:45, Reindl Harald wrote:
I'm trying to install prestashop-1.7.7.1 on MyISAM
and why does that piece of software don't work with sensible defaults and force you too pacth source code and recompile your database server in a way nobody but you is running?
this is asking for troubles and until someone can prove a *real* benefit i call it bullshit and won't install "prestashop-1.7.7.1 on MyISAM"
the other possibilty is that it's designed to work with innoDB and *not* MyISAM which means: just don't enforce MyISAM, key sizes are your smallest problems in reality
A: It is a MySQL issue. http://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-m...
as expected DO NOT INSTALL IT ON MYISAM jesus christ ENGINE=InnoDB and no it's not a mysql issue when a software is written in a way than even the installer dies 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;