Skip to main content

JInstaller: :Install: Error SQL Index column size too large.

3K Views
0 Replies
2 min read

Hi,

We just tried to install Community Surveys to our website after installing pkg_cjlib_v2.7.1
and just got the following error. We are also running PHP Version 7.0. Any suggestions?

Thanks in advance.

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 `#__survey_surveys` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`asset_id` INT(10) UNSIGNED NOT NULL,
	`catid` INT(10) UNSIGNED NOT NULL,
	`title` VARCHAR(256) NOT NULL,
	`alias` VARCHAR(256) NOT NULL,
	`description` MEDIUMTEXT NULL,
	`endtext` MEDIUMTEXT NULL,
	`custom_header` MEDIUMTEXT NULL,
	`survey_key` VARCHAR(32) NOT NULL,
	`published` TINYINT(3) NOT NULL DEFAULT '1',
	`created_by` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`private` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	`restrictions` VARCHAR(32) NOT NULL DEFAULT 'cookie',
	`redirect_url` VARCHAR(999) NULL DEFAULT NULL,
	`max_responses` INT(10) NOT NULL DEFAULT '0',
	`ordering` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`responses` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`ip_address` VARCHAR(39) NOT NULL DEFAULT '0.0.0.0',
	`access` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`language` CHAR(7) NOT NULL DEFAULT '*',
	`publish_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`publish_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`modified` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`modified_by` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`checked_out` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`attribs` VARCHAR(5120) NULL DEFAULT NULL,
	`metakey` TEXT NULL,
	`metadesc` TEXT NULL,
	`metadata` TEXT NULL,
	PRIMARY KEY (`id`),
	UNIQUE INDEX `idx_survey_surveys_surveykey` (`survey_key`),
	INDEX `idx_survey_surveys_access` (`access`),
	INDEX `idx_survey_surveys_checkout` (`checked_out`),
	INDEX `idx_survey_surveys_language` (`language`),
	INDEX `idx_survey_surveys_title` (`title`(255)),
	INDEX `idx_survey_surveys_state` (`published`),
	INDEX `idx_survey_surveys_catid` (`catid`),
	INDEX `idx_survey_surveys_created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 Error
Error installing component
 
Community Surveys - A web 2.0 survey component for Joomla.

 

0 Replies

No Replies Yet

Topic Author

Topic Stats

Created Wednesday, 17 January 2018 06:17
Last Updated Wednesday, 17 January 2018 06:17
Replies 0
Views 3K
Likes 0

Share This Topic