Keyword

Installation impossible sous Joomla 3.922

More
1 month 3 days ago #177252 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

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
1 month 3 days ago #177256 by Fotis
Replied by Fotis on topic Installation impossible sous Joomla 3.922
What is your MySQL (or MariaDB) version?

Is this a fresh Joomla/K2 installation?

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

More
1 month 3 days ago #177258 by Marc
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!

Please Log in or Create an account to join the conversation.

More
1 month 3 days ago #177259 by Marc
Hi Fortis

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.

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
1 month 1 hour ago - 1 month 1 hour ago #177281 by Fotis
Replied by Fotis 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).

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member
Last edit: 1 month 1 hour ago by Fotis.

Please Log in or Create an account to join the conversation.

More
4 weeks 2 days ago #177306 by Marc
"utf8mb4_general_ci"
I'll try to change to "utf8mb4_unicode_ci"

Please Log in or Create an account to join the conversation.

More
4 weeks 2 days ago #177307 by Marc
impossible de changer ... msg erreur "la clé est trop longue"

Please Log in or Create an account to join the conversation.

More
4 weeks 2 days ago #177308 by Marc
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.

More
4 weeks 2 days ago #177309 by Marc
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;

Please Log in or Create an account to join the conversation.

More
4 weeks 2 days ago #177311 by Marc
undefined
Attachments:

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum