maria-developers team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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;