Index column size too large. The maximum column size is 767 bytes

Macjoomla
Macjoomla
  • Macjoomla
  • 6 months ago

Hello,

just wanted to install recent version of community quizz and got following Error. Can you please help.

Warnung

JInstaller: :Install: SQL-Fehler Index column size too large. The maximum column size is 767 bytes.
Erweiterung „Installieren“: SQL Fehler beim Ausführen der Abfrage: „DB-Funktion mit Fehlercode 1709 fehlgeschlagen!
Index column size too large. The maximum column size is 767 bytes.
SQL = 
CREATE TABLE IF NOT EXISTS `#__quiz_quizzes` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`asset_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`title` VARCHAR(255) NOT NULL,
	`alias` VARCHAR(255) NOT NULL,
	`description` MEDIUMTEXT NOT NULL,
	`catid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`difficulty_level` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`published` TINYINT(3) NOT NULL DEFAULT '0',
	`quiz_type` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
	`duration` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`cutoff` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`messages` MEDIUMTEXT NULL,
	`certificates` MEDIUMTEXT NULL,
	`secret` VARCHAR(64) NULL DEFAULT NULL,
	`max_questions` INT(10) UNSIGNED NULL DEFAULT NULL,
	`qns_ordering` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
	`max_qns_per_page` INT(10) UNSIGNED NOT NULL DEFAULT '1',
	`badge` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`responses` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`created_by` INT(10) UNSIGNED NOT NULL,
	`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`ip_address` VARCHAR(39) NOT NULL,
	`checked_out` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`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_by` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`attribs` VARCHAR(5120) NULL DEFAULT NULL,
	`ordering` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`metakey` TEXT NULL,
	`metadesc` TEXT NULL,
	`access` INT(10) UNSIGNED NOT NULL DEFAULT '1',
	`metadata` TEXT NULL,
	`language` CHAR(7) NOT NULL DEFAULT '*',
	PRIMARY KEY (`id`),
	INDEX `idx_quiz_quizzes_access` (`access`),
	INDEX `idx_quiz_quizzes_checkout` (`checked_out`),
	INDEX `idx_quiz_quizzes_published` (`published`),
	INDEX `idx_quiz_quizzes_catid` (`catid`),
	INDEX `idx_quiz_quizzes_language` (`language`),
	INDEX `idx_quiz_quizzes_title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
Paket Installieren: Bei der Installation der Erweiterung trat ein Fehler auf: com_communityquiz.zip

 


Access to viewing replies is restricted.
Showing 2 of 2 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