JInstaller: :Install: Error SQL Index column size too large.
JInstaller: :Install: Error SQL Index column size too large.
- 7 months ago
- Community Surveys
transhealthaustralia
- transhealthaustralia
- 7 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 =
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