Ecco alcune modifiche che ho fatto:
1) Bug con mysql 5.7 che non permette di avere una chiave primaria settata a null
File: homesliderpro.php
Linea: 296
Trovare:
$res &= (bool)Db::getInstance()->execute('
CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'sesliders_slideconf` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(10) unsigned NOT NULL,
`id_hook` varchar(255) NULL,
`conf` text NULL,
PRIMARY KEY (`id`, `id_hook`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;
');
Sostituire con:
$res &= (bool)Db::getInstance()->execute('
CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'sesliders_slideconf` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(10) unsigned NOT NULL,
`id_hook` varchar(255) NULL,
`conf` text NULL,
PRIMARY KEY (`id`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;
');
Linea 1163
Trovare:
if(!$this->tableExists(_DB_PREFIX_.'sesliders_slideconf')) {
$res2 = (bool)Db::getInstance()->execute('
CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'sesliders_slideconf` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(10) unsigned NOT NULL,
`id_hook` varchar(255) NULL,
`conf` text NULL,
PRIMARY KEY (`id`, `id_hook`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;
');
Sostituire con:
if(!$this->tableExists(_DB_PREFIX_.'sesliders_slideconf')) {
$res2 = (bool)Db::getInstance()->execute('
CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'sesliders_slideconf` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(10) unsigned NOT NULL,
`id_hook` varchar(255) NULL,
`conf` text NULL,
PRIMARY KEY (`id`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;
');