- Posts: 2
COMMUNITY FORUM
Error installing component K2 in joomla 3.9.15
- zombla
- Topic Author
- Offline
- New Member
Less
More
4 years 9 months ago - 4 years 9 months ago #174664
by zombla
Error installing component K2 in joomla 3.9.15 was created by zombla
Hi there
I cant install K2 extension in my joomla website
Joomla 3.9.15
PHP version 7.3.14
Database Type mysql
Database Version 5.6.47-cll-lve
Error message
Warning
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension Install: SQL error processing query: DB function failed with error number 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =
CREATE TABLE IF NOT EXISTS `#__k2_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`published` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_name` (`name`),
KEY `idx_published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
Error
Error installing component
Any idea ?
Thank you
I cant install K2 extension in my joomla website
Joomla 3.9.15
PHP version 7.3.14
Database Type mysql
Database Version 5.6.47-cll-lve
Error message
Warning
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension Install: SQL error processing query: DB function failed with error number 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =
CREATE TABLE IF NOT EXISTS `#__k2_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`published` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_name` (`name`),
KEY `idx_published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
Error
Error installing component
Any idea ?
Thank you
Last edit: 4 years 9 months ago by zombla.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 9 months ago #174667
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Error installing component K2 in joomla 3.9.15
The problem is probably related to your MySQL (or MariaDB) configuration. To be exact and as described here dev.mysql.com/doc/refman/5.7/en/innodb-limits.html if "innodb_large_prefix" is set to false, this limit is imposed to databases with utf8mb4_unicode_ci collation.
Your hosting company may have set this option explicitly for backwards compatibility reasons (the default is enabled).
The other option is to download and extract the K2 zip file and edit the file /administrator/components/com_k2/install.mysql.sql replacing all instances of "CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci" with "CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci". Then repackage the contents you extracted into a new zip file and finally install that file in Joomla.
Your hosting company may have set this option explicitly for backwards compatibility reasons (the default is enabled).
The other option is to download and extract the K2 zip file and edit the file /administrator/components/com_k2/install.mysql.sql replacing all instances of "CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci" with "CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci". Then repackage the contents you extracted into a new zip file and finally install that file in Joomla.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- zombla
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
4 years 9 months ago #174679
by zombla
Replied by zombla on topic Error installing component K2 in joomla 3.9.15
Hi
Thank you for your reply
I used "the other option" and it's ok :)
Message
Installation of the component was successful.
Thank you for your reply
I used "the other option" and it's ok :)
Message
Installation of the component was successful.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 9 months ago #174683
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Error installing component K2 in joomla 3.9.15
Cool :)
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.