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

 

Like it on Facebook, Tweet it or share this topic on other bookmarking websites.
  • Re: Index column size too large. The maximum column size is 767 bytes

    by » one year ago


    This is caused by the index size setting on your database is no more than 191 characters (767 bytes). Please create the table manually in your database by executing below query and then install the component. Please replace PREFIX with your table prefix.

    CREATE TABLE IF NOT EXISTS `PREFIX_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`(191))
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

    Follow me on twitter: https://twitter.com/corejoomla
    If you use our extensions, please post a rating and a review at the Joomla! Extensions Directory.
    CjFitCjForum | Polls | Answers | Quizzes | Quotes | Surveys | GPS Tools | CjBlog


    Thank you said by: Macjoomla

  • Re: Index column size too large. The maximum column size is 767 bytes

    by » one year ago


    Hello Maverick,

    thank you for your fast answer, this works fine now.

    Best regards, macjoomla

     


You do not have permissions to reply to this topic.

Powered by CjForum

Site Search

Trending Topics

Upload Track button not working
  • 9 replies
Hallo, I have a problem uploading new gps tracks. Clicking on the...

Latest questions
  • 1 reply
I am trying to recreate the very slim (just a header and topic...

Owner
  • 1 reply
I only have two questions per survey. Is it possible to place them...

GPS TOOLS v5.1.1 : IMPOSSIBLE TO CREATE TRACK
  • 1 reply
Hi Maverick, IMPORTANT ISSUE : After installing v5.1.1, it's...

Import Wordpress posts
  • 1 reply
Is there a migrator to do this? I have a site with nearly 600 posts...

Subscribe Newsletter