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 =
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.