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 installing component
