Index column size too large. The maximum column size is 767 bytes
Index column size too large. The maximum column size is 767 bytes
- 6 months ago
- Community Quiz
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 =
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