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
