Answers.Body: <p>Welcome to SE CiviCRM</p>
  <p>You will need the following MySQL server configuration:</p>
  <pre><code>innodb_large_prefix=true 
  innodb_file_format=barracuda 
  innodb_file_per_table=true
  </code></pre>
  <p>add above configuration in your <a href="https://stackoverflow.com/a/2485758">my.cnf</a> file.</p>
  <p>See <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration" rel="nofollow noreferrer">mysql requirement</a> for CiviCRM</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-19T16:39:11.380Z
Answers.LastActivityDate: 2024-02-19T16:39:11.380Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I am trying to install the add-on for Joomla, but I get the following error message:</p>
  <p><code>Cannot execute CREATE TABLE `civicrm_extension` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID', `type` varchar(8) NOT NULL, `full_name` varchar(255) NOT NULL COMMENT 'Fully qualified extension name', `name` varchar(255) COMMENT 'Short name', `label` varchar(255) COMMENT 'Short, printable name', `file` varchar(255) COMMENT 'Primary PHP file', `schema_version` varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined', `is_active` tinyint DEFAULT 1 COMMENT 'Is this extension active?', PRIMARY KEY (`id`), UNIQUE INDEX `UI_extension_full_name`(full_name), INDEX `UI_extension_name`(name) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: Specified key was too long; max key length is 767 bytes</code></p>
  <p>How can I solve this?</p>
  
Tags: <joomla><mysql>
Title: SQL error when installing Joomla add-on
ThreadText: # SQL error when installing Joomla add-on
  
  (Asked by: username_0 on 2024-02-19)
  
  I am trying to install the add-on for Joomla, but I get the following error message:
  
  `Cannot execute CREATE TABLE `civicrm_extension` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID', `type` varchar(8) NOT NULL, `full_name` varchar(255) NOT NULL COMMENT 'Fully qualified extension name', `name` varchar(255) COMMENT 'Short name', `label` varchar(255) COMMENT 'Short, printable name', `file` varchar(255) COMMENT 'Primary PHP file', `schema_version` varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined', `is_active` tinyint DEFAULT 1 COMMENT 'Is this extension active?', PRIMARY KEY (`id`), UNIQUE INDEX `UI_extension_full_name`(full_name), INDEX `UI_extension_name`(name) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: Specified key was too long; max key length is 767 bytes`
  
  How can I solve this?
  
  **Tags:** joomla, mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-02-19. Score: 1
  
  Welcome to SE CiviCRM
  You will need the following MySQL server configuration:
  innodb_large_prefix=true 
  innodb_file_format=barracuda 
  innodb_file_per_table=true
  
  add above configuration in your my.cnf file.
  See mysql requirement for CiviCRM
  
  
  ---
  
  