just wanted to install recent version of community quizz and got following Error. Can you please help.
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