Too many keys specified; max 64 keys allowed

StartPrev 1 2 NextEnd
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

Last change: 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.


Last change: 08.09.2016 10:12

Regular Labs - Extensions for Joomla!
regularlabs.com
 
08.09.2016 14:46
#3
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
Quote
Aw: Too many keys specified; max 64 keys allowed

1. joomla languages (count)?

2. ok.
try use MyISAM

Need delete all #__jshopping.... table


Last change: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
Quote
Aw: Too many keys specified; max 64 keys allowed

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


Last change: 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: 1927
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?


Last change: 09.11.2016 23:07
 
19.01.2017 08:02
#14
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 1927
Quote
Aw: Too many keys specified; max 64 keys allowed

Webdesigner, существует ли в Joomshopping 4.15.1 проблема, о которой писал в этой теме пользователь regularlabs (see posts #1, 2, 4, 6, 8, 10)? Будет ли устранена эта проблема в новой версии Joomshopping?


Last change: 19.01.2017 08:03
 
24.07.2017 13:44
#15
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 1927
Quote
Aw: Too many keys specified; max 64 keys allowed

Webdesigner, пожалуйста, исправьте проблему, которую описал автор данной темы (regularlabs), чтобы regularlabs (разработчик) мог сделать совместимость компонента "Advanced Module Manager" с компонентом Joomshopping. Очень нужна такая совместимость! Компонент "Advanced Module Manager" сейчас уже совместим с VirtueMart, Hikashop, Redshop и другими популярными компонентами, но из-за проблемы, которую описал автор (regularlabs), разработчик не может сделать совместимость, хотя он не против сделать совместимость с Joomshopping. Пожалуйста, постарайтесь исправить проблему. Webdesigner, вся надежда только на вас!


Last change: 24.07.2017 17:14
 
25.07.2017 12:22
#16
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 1927
Quote
Aw: Too many keys specified; max 64 keys allowed

Webdesigner, will you correct the above errors? PLEASE!


Last change: 25.07.2017 12:22
 
25.07.2017 15:02
#17
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
Quote
Aw: Too many keys specified; max 64 keys allowed

Limit language NOT will be changed. - Main structure multilanguage joomshopping


Last change: 25.07.2017 15:03
 
25.07.2017 15:32
#18
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 1927
Quote
Aw: Too many keys specified; max 64 keys allowed

Можете ли вы, в таком случае, сделать аддон для модулей Joomla (на подобии компонента "Advanced Module Manager", ссылка https://www.regularlabs.com/extensions/advancedmodulemanager), который был бы совместим с Joomshopping? В аддоне должны быть опции: Show modules based on Joomshopping Page types, Categories and Products? Между прочим, хорошая идея для нового аддона.


Last change: 25.07.2017 15:33
 
10.12.2018 01:33
#19
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 1927
Quote
Aw: Too many keys specified; max 64 keys allowed

Здравствуйте, Webdesigner!
Можете ли вы устранить проблему в Joomshopping 5 для Joomla 4, которую пользователь regularlabs выявил ещё в Joomshopping 4.14.3? Читайте все предыдущие сообщения в этой теме.
ОЧЕНЬ НАДЕЮСЬ НА ВАШУ ОТЗЫВЧИВОСТЬ ПО ДАННОМУ ВОПРОСУ!
Сейчас самое время исправить эту проблему перед переходом на Joomla 4 и Joomshopping 5.


Last change: 10.12.2018 01:36
 
06.09.2019 17:54
#20
midiplus
Joomshopping forum user no avatar
Name: Anton
03.07.2013
Posts: 1927
Quote
Aw: Too many keys specified; max 64 keys allowed

Webdesigner, будет ли в Joomshopping 5 устранена проблема, о которой говорил пользователь "regularlabs" в данной теме?


Last change: 06.09.2019 17:55
 
StartPrev 1 2 NextEnd


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.