Just FYI, I confirm Prestashop (at least since 1.6.1.x) is designed to work much better on InnoDB than MyISAM
BR, Jocelyn Fournier > Le 15 janv. 2021 à 10:09, Reindl Harald <h.rei...@thelounge.net> a écrit : > > > > 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-max-key-length-is-1000-bytes >> > > 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; > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-developers > Post to : maria-developers@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp