Support Forum

Every time that you post a problem, PLEASE add the Joomla and the extension's versions and revisions (for example: Joomla 3.3.6, Contact Enhanced 3.3.5), PHP version and Server's Operating System. If you only manage only one site it is easier if you edit your profile and just add that information to your signature. Don't forget to add a detailed description of the problem. If possible, write down all steps to simulate the problem.

Before submitting a new post, PLEASE make sure you are running the latest version, test in different browsers (IE, FF, Chrome,..) and clear Joomla and browser's cache after every change you make.

Also, most questions are already answered in our FAQ and in iFAQ and Contact Enhanced documentation pages.

× Contact Enhanced is a contact component manager created to replace Joomla! core contacts component and add lots of advantages and new features (see Features ) and it offers many plugins and modules for several different purposes,
Product page | Documentation Page

Problem installing: SQL Index column size too large

6 years 9 months ago #23426 by rtaxerxes
Hi,

I have just purchased CE and tried to install it on latest Joomla 3.7.3 but am getting an error:
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.

Any idea on how to install it?

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

6 years 9 months ago #23427 by support
Dear rtaxerxes,

I've never had this error before.
Which MySQL version are you using?

Best regards,

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

6 years 9 months ago #23428 by rtaxerxes
According to System Information it is: 5.5.5-10.0.31-MariaDB-1~wheezy

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

6 years 9 months ago #23429 by rtaxerxes
Perhaps all the details will help:
Setting Value

PHP Built On Linux www32.cpt2.host-h.net 3.2.0-4-686-pae #1 SMP Debian 3.2.86-1 i686
Database Version 5.5.5-10.0.31-MariaDB-1~wheezy
Database Collation latin1_swedish_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.30-1~dotdeb+7.1
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.7.3 Stable [ Amani ] 4-July-2017 08:03 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4

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

6 years 9 months ago #23430 by support
Dear rtaxerxes,

I've never had this issue before. Please allow us a couple of hours to set up an environment with MariaDB for testing purposes and figure it out what exactly is causing this issue.

Best regards,

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

6 years 9 months ago #23431 by rtaxerxes
Thanks, I will await more info.

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

6 years 9 months ago #23432 by support
Dear rtaxerxes,

Problem is now solved.
I have sent a new file for you to download if needed and the fix will be included in the next version as well.

Best regards,

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

Powered by Kunena Forum

Copyright © 2018 IdealExtensions.com. All Rights Reserved.

This site is not affiliated with or endorsed by the Joomla!™ Project. It is not supported or warranted by the Joomla!™ Project or Open Source Matters™. The Joomla!™ logo is used under a limited license granted by Open Source Matters™, the trademark holder in the United States and other countries.
We may collect your IP address and your browser's User Agent string while using our site for security reasons and deriving aggregate information (analytics). This information is retained for a minimum of 1 and a maximum of 24 months.
Feedback