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.

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. SQL Index column size too large
× 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

SQL Index column size too large

6 years 8 months ago #23474 by teclogix
Tried to install on jomla 3.7 and getting this error can you please help

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 `#__ce_cv` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(255) NOT NULL COMMENT 'Will be removed from future versions... use NAME field now',
`name` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`type` varchar(100) DEFAULT NULL,
`ordering` int(11) NOT NULL,
`catid` int(11) NOT NULL,
`parent` varchar(100) DEFAULT NULL,
`published` tinyint(1) NOT NULL DEFAULT '1',
`access` tinyint(3) unsigned NOT NULL,
`params` mediumtext,
`language` char(7) NOT NULL,
PRIMARY KEY (`id`),
KEY `ce_cv_text_values` (`text`),
KEY `idx_ce_cv_language` (`language`),
KEY `idx_ce_cv_published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
Package Install: There was an error installing an extension: com_contactenhanced_3.7.1__20170627_1218.zip

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

6 years 8 months ago #23475 by support
Greetings,

Are you using MariaDB?

I'm going to create a new package for you and send to your email address right away and will update the download package in a couple of hours.

Best regards,
Douglas Machado
iStoreLocator | iFAQ | Ideal Related Articles | Contact Enhanced

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

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. SQL Index column size too large
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