Too many keys specified; max 64 keys allowed

08.09.2016 10:05
#1
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Too many keys specified; max 64 keys allowed

Trying to get Joomshopping installed on my local host, but running into one database issue after the other.

First everything fails if the default database engine is set to Inoodb. The Joomshopping installer doesn't force MyISAM, but apparently needs this to function.
So only solution (I could find) is o manually change the database tables after a failed install and then try to re-install.

But then the next issue:
Too many keys specified; max 64 keys allowed SQL=ALTER TABLE `#__jshopping_products` ADD INDEX(`delivery_times_id`);


This is because on every re-install, Joomshopping seems to add new indexes to every database table.
Something definitely wrong with the installation procedure!


Joomla: 3.6.2
JoomShopping: 4.14.3
PHP: 7
MySQL: 5.7.13

Letzte Änderung: 08.09.2016 20:23

Regular Labs - Extensions for Joomla!
regularlabs.com
 
08.09.2016 10:09
#2
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Aw: Too many keys specified; max 64 keys allowed

If I delete all tables, reinstall (with failure because of InnoDB), change tables to MyISAM and re-install, I get:
Column count doesn't match value count at row 1 SQL=INSERT INTO `#__jshopping_usergroups` VALUES (1 , 'Default', '0.00', 'Default', 1, 'Default', 'Default');
SQL =
INSERT INTO `#__jshopping_usergroups` VALUES (1 , 'Default', '0.00', 'Default', 1, 'Default', 'Default');


This is caused by all the separate name_xx-XX and description_xx-XX table columns in #__jshopping_usergroups.


Letzte Änderung: 08.09.2016 10:12

Regular Labs - Extensions for Joomla!
regularlabs.com
 
08.09.2016 14:46
#3
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Too many keys specified; max 64 keys allowed

My test site work for database InnoDB

table product only 16 index (no 64)

url?
ftp?
db access?
(private message) for test

 
08.09.2016 20:22
#4
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Aw: Too many keys specified; max 64 keys allowed

I only have this on localhost. I don't plan to use this on my live sites. It is just so that I can test stuff so I can add support for JoomShopping to my extensions, like Advanced Module Manager.

The first time I install it (using InnoDB), I get this error:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `#__jshopping_manufacturers` ADD `name_sk-SK` varchar(255) NOT NULL, ADD `alias_sk-SK` varchar(255) NOT NULL, ADD `short_description_sk-SK` text NOT NULL, ADD `description_sk-SK` text NOT NULL, ADD `meta_title_sk-SK` varchar(255) NOT NULL, ADD `meta_description_sk-SK` text NOT NULL, ADD `meta_keyword_sk-SK` text NOT NULL



Regular Labs - Extensions for Joomla!
regularlabs.com
 
09.09.2016 08:15
#5
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Too many keys specified; max 64 keys allowed

1. joomla languages (count)?

2. ok.
try use MyISAM

Need delete all #__jshopping.... table


Letzte Änderung: 09.09.2016 08:17
 
09.09.2016 09:13
#6
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Aw: Too many keys specified; max 64 keys allowed

1) 37 languages

2) Already tried that, see above errors.


Regular Labs - Extensions for Joomla!
regularlabs.com
 
09.09.2016 15:57
#7
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Too many keys specified; max 64 keys allowed

2.
Not deleted old table #__jshopping_usergroups

delete all table #__jshopping_

 
09.09.2016 16:15
#8
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Aw: Too many keys specified; max 64 keys allowed

As you can read in my earlier replies, I did that.
If I delete all tables...



Regular Labs - Extensions for Joomla!
regularlabs.com
 
09.09.2016 20:20
#9
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Too many keys specified; max 64 keys allowed

install sql.

CREATE TABLE IF NOT EXISTS `#__jshopping_usergroups` (
`usergroup_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`usergroup_name` VARCHAR( 64 ) NOT NULL ,
`usergroup_discount` DECIMAL(12,2) NOT NULL,
`usergroup_description` TEXT NOT NULL ,
`usergroup_is_default` TINYINT(1) NOT NULL,
`name_en-GB` varchar(255) NOT NULL,
`name_de-DE` varchar(255) NOT NULL
);
...
INSERT INTO `#__jshopping_usergroups` VALUES (1 , 'Default', '0.00', 'Default', 1, 'Default', 'Default');

Bug only if table already exist.

I do not see other reasons.

Delete all table and try again.

 
10.09.2016 17:01
#10
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Aw: Too many keys specified; max 64 keys allowed

Looks like we are going around in circles.

Ok, so this happens on a fresh install. So no jshopping tables in database:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `#__jshopping_manufacturers` ADD `name_sk-SK` varchar(255) NOT NULL, ADD `alias_sk-SK` varchar(255) NOT NULL, ADD `short_description_sk-SK` text NOT NULL, ADD `description_sk-SK` text NOT NULL, ADD `meta_title_sk-SK` varchar(255) NOT NULL, ADD `meta_description_sk-SK` text NOT NULL, ADD `meta_keyword_sk-SK` text NOT NULL



Regular Labs - Extensions for Joomla!
regularlabs.com
 
10.09.2016 20:22
#11
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Too many keys specified; max 64 keys allowed

The default setting does not work for you.
a lot of languages.


Letzte Änderung: 10.09.2016 20:22
 
10.09.2016 22:53
#12
regularlabs
User regularlabs
Name: Peter
03.09.2016
Posts: 7
Quote
Aw: Too many keys specified; max 64 keys allowed

So, the issue is that JoomShopping breaks when there are a lot of languages...
Ok, good to know.


Regular Labs - Extensions for Joomla!
regularlabs.com
 
09.11.2016 22:53
#13
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 776
Quote
Aw: Too many keys specified; max 64 keys allowed

Webdesigner, исправлены ли в Joomshopping 4.15.0 проблемы, которые описывал пользователь "regularlabs", или нет?

Из-за вышеописанных проблем невозможно создать компонент "Advanced Module Manager" для Joomshopping, хотя без проблем работает в Virtuemart, Redshop, Hikashop, Mijoshop и т.п.

Webdesigner, можете ли вы внести необходимые исправления в Joomshopping, чтобы пользователь "regularlabs" мог сделать совместимость компонента "Advanced Module Manager" с Joomshopping?


Letzte Änderung: 09.11.2016 23:07
 
Copyrights MAXXmarketing GmbH. All Rights Reserved