- Posts: 13
COMMUNITY FORUM
Installation impossible sous Joomla 3.922
- Marc
-
Topic Author
- Offline
- New Member
Less
More
4 years 3 months ago #177252
by Marc
Installation impossible sous Joomla 3.922 was created by Marc
Bonjour,
Ancien utilisateur de K2 avec des versions antérieurs de Joomla et K2, j'essaye en vain d'installer le dernier K2 sous Joomla 3.922 ... en vain.
J'ai un Msg d'erreur systématique :
JInstaller: :Install: erreur SQL Index column size too large. The maximum column size is 767 bytes.
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1709
J'ai consulté divers sites pour comprendre le pb, mais ce qui me pose une difficulté est de trouver une SOLUTION SIMPLE pour le résoudre.
Quelqu'un a-t-il connu ce pb et l'aurait résolu? ... ou solution d'un utilisateur compétent?
Belle journée
Ancien utilisateur de K2 avec des versions antérieurs de Joomla et K2, j'essaye en vain d'installer le dernier K2 sous Joomla 3.922 ... en vain.
J'ai un Msg d'erreur systématique :
JInstaller: :Install: erreur SQL Index column size too large. The maximum column size is 767 bytes.
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1709
J'ai consulté divers sites pour comprendre le pb, mais ce qui me pose une difficulté est de trouver une SOLUTION SIMPLE pour le résoudre.
Quelqu'un a-t-il connu ce pb et l'aurait résolu? ... ou solution d'un utilisateur compétent?
Belle journée
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 3 months ago #177256
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
What is your MySQL (or MariaDB) version?
Is this a fresh Joomla/K2 installation?
Is this a fresh Joomla/K2 installation?
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177258
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
Hi Fotis
Version de MySQL 5.6.41-cll-lve
it's a fresh (unsuccessfull ...) installation on a new (fresh) Joomla 3.9.22
Thanks for helping!
Version de MySQL 5.6.41-cll-lve
it's a fresh (unsuccessfull ...) installation on a new (fresh) Joomla 3.9.22
Thanks for helping!
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177259
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
Hi Fortis
Version de MySQL 5.6.41-cll-lve (Fresh)
Joomla 3.9.22
Thanks for helping
Version de MySQL 5.6.41-cll-lve (Fresh)
Joomla 3.9.22
Thanks for helping
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 3 months ago - 4 years 3 months ago #177281
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
What is your database collation? It should at least be "utf8_unicode_ci" or (preferably) "utf8mb4_unicode_ci".
Using phpMyAdmin, you can change that in the database's "Operations" tab (when using the English UI of phpMyAdmin).
Using phpMyAdmin, you can change that in the database's "Operations" tab (when using the English UI of phpMyAdmin).
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Last edit: 4 years 3 months ago by JoomlaWorks.
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177306
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
"utf8mb4_general_ci"
I'll try to change to "utf8mb4_unicode_ci"
I'll try to change to "utf8mb4_unicode_ci"
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177307
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
impossible de changer ... msg erreur "la clé est trop longue"
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177308
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
successfull finally but it seems some interclass were not changed ... I need to check
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177309
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
didn't help
JInstaller: :Install: erreur SQL Index column size too large. The maximum column size is 767 bytes.
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 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;
JInstaller: :Install: erreur SQL Index column size too large. The maximum column size is 767 bytes.
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 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;
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177311
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
undefined
Attachments:
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 3 months ago #177317
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
Can you modify the server's my.cnf? Judging from the screenshots' URLs, you're using cPanel.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177318
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
it's a shared server (using cpanel you're right) and I don't seem to have access to this "my.cnf" ... where should be this file? ... I didn't find any with this naame
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 3 months ago #177319
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
Pass along the SQL error to your hosting company so they can adjust the server's my.cnf configuration accordingly (they probably need to enable innodb_large_prefix).
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177323
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
Thanks Fotis, I'll transmit to my hosting company. Usually they argue that it's a shared server son can't make any individual change ... but I hope they'll agree to do.
Have a nice day ... I'll inform if any progress for solution.
Have a nice day ... I'll inform if any progress for solution.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 3 months ago #177331
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
You'll probably have issues with other extensions as well, so it's good to be prepared :)
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 3 months ago #177357
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
Hi Fotis,
The DB admin had a look and his answer is the following:
"The suggested variable is already ON:
mysql> show session variables like 'innodb_large_prefix';
+
+
+
| Variable_name | Value |
+
+
+
| innodb_large_prefix | ON |
+
+
+
1 row in set (0.00 sec)
Customer must create table with:
ROW_FORMAT=DYNAMIC
E.g.
CREATE TABLE <table_name> (
... field definitions ...
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
This is a common issues when importing from MariaDB or MySQL > 5.6"
SO WHAT CAN I DO AT THIS STAGE?
Really embarrassed not to be able to use K2
The DB admin had a look and his answer is the following:
"The suggested variable is already ON:
mysql> show session variables like 'innodb_large_prefix';
+
+
+
| Variable_name | Value |
+
+
+
| innodb_large_prefix | ON |
+
+
+
1 row in set (0.00 sec)
Customer must create table with:
ROW_FORMAT=DYNAMIC
E.g.
CREATE TABLE <table_name> (
... field definitions ...
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
This is a common issues when importing from MariaDB or MySQL > 5.6"
SO WHAT CAN I DO AT THIS STAGE?
Really embarrassed not to be able to use K2
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 2 months ago #177367
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
This is the first time I hear about this.
Digging around a bit I found this old post (MySQL 5.0 is mentioned!) at the MySQL worklog site: dev.mysql.com/worklog/task/?id=8307
So it's my guess that your webhost has a weird or outdated my.cnf config. And I'm afraid I can't modify K2 for everyone just to suit your webhost.
So grab K2, extract it and edit the SQL installation file to append ROW_FORMAT=DYNAMIC at the end of each CREATE TABLE... definition.
If I were you I would changes webhosts though...
Digging around a bit I found this old post (MySQL 5.0 is mentioned!) at the MySQL worklog site: dev.mysql.com/worklog/task/?id=8307
So it's my guess that your webhost has a weird or outdated my.cnf config. And I'm afraid I can't modify K2 for everyone just to suit your webhost.
So grab K2, extract it and edit the SQL installation file to append ROW_FORMAT=DYNAMIC at the end of each CREATE TABLE... definition.
If I were you I would changes webhosts though...
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 2 months ago #177374
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
OK thanks a lot!
I'll try to do so asap.
Hope it will work ...
Have a nice day.
Marc
I'll try to do so asap.
Hope it will work ...
Have a nice day.
Marc
Please Log in or Create an account to join the conversation.
- Marc
-
- Offline
- New Member
Less
More
- Posts: 13
4 years 2 months ago #177375
by Marc
Replied by Marc on topic Installation impossible sous Joomla 3.922
done ... and works!
MANY THANKS FOTIS !!!!
MANY THANKS FOTIS !!!!
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6225
4 years 2 months ago #177386
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Installation impossible sous Joomla 3.922
Do consider the option of changing webhosts in the near future though. :)
You never know when things will break again...
You never know when things will break again...
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.