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

transhealthaustralia
transhealthaustralia
  • transhealthaustralia
  • 5 months ago

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.

 


Access to viewing replies is restricted.
Showing 8 of 8 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai