Cannot install the component
Hello, sorry for my poor english, i'm french.
I buy the component for competitions. In my downloads i have 8 zip. I can install all the plugin or modules but not the component.
I have this alert :
Help me please for install it. thanks you very much.
my configuration : joomla 3.6.5
not on OVH but 1and1
Serveur de base de données
Serveur : db615921850.db.1and1.com via TCP/IP
Type de serveur : MySQL
Version du serveur : 5.5.53-0+deb7u1-log - (Debian)
Version du protocole : 10
Jeu de caractères du serveur : UTF-8 Unicode (utf8)
Version du client de base de données : libmysql - mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
Extension PHP : mysqli Documentation
Version : 22.214.171.124
This looks like a problem related to MySQL Bug #44541, which was fixed in MySQL Server versions 5.1.69, 5.5.31, 5.6.11, and 5.7.1.
We need to fix this in our future version of NorrCompetition, but for now do the following:
The length of internally generated foreign key names was not checked. If internally generated foreign key names were over the 64 character limit, this resulted in invalid DDL from SHOW CREATE TABLE. This fix checks the length of internally generated foreign key names and reports an error message if the limit is exceeded.
1. Download install.mysql.utf8.sql.zip from this post attachment and unzip it. You will have file install.mysql.utf8.sql.
2. Unzip downloaded component archive.
3. Replace file admin/sql/install.mysql.utf8.sql with new file that you have downloaded from this post.
4. Zip component files back to archive and try to install it.
Thank you for getting us know. Glad that you have solved it
You can get our help: Monday - Friday / 09:00 to 17:00 (GMT+2). but not limited. Our staff will be pleased to provide Premium support to every paid subscriber asap, but sometimes you should be ready to wait for our reply for up to 3 days. In case of free extensions we do the best to develop and maintain them either, but their support is not necessary.