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: 2021-03-25T18:23:10.580Z
Answers.Text: Thank you so much for your quick response.  I'll try that now.  Much appreciated :)
Answers.UserDisplayName: shibetpc
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-25T15:11:50.127Z
Answers.LastActivityDate: 2021-03-25T15:11:50.127Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I'm having an issue installing civicrm against a WordPress install.  Plugin is installed.  wp-content&gt;uploads&gt;civicrm is present, writable, and empty.  I have specified a separate database to use.  However, I was encountering the same issue when I tried to install against the WP database.  This is the error I am receiving:</p>
  <hr />
  <h2>Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE <code>civicrm_extension</code> ( <code>id</code> int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID', <code>type</code> varchar(8) NOT NULL , <code>full_name</code> varchar(255) NOT NULL COMMENT 'Fully qualified extension name', <code>name</code> varchar(255) COMMENT 'Short name', <code>label</code> varchar(255) COMMENT 'Short, printable name', <code>file</code> varchar(255) COMMENT 'Primary PHP file', <code>schema_version</code> varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined', <code>is_active</code> tinyint DEFAULT 1 COMMENT 'Is this extension active?' , PRIMARY KEY (<code>id</code>) , UNIQUE INDEX <code>UI_extension_full_name</code>( full_name ) , INDEX <code>UI_extension_name</code>( 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 in /var/www/vhosts/<strong><strong><strong>.org/httpdocs/wp-content/plugins/ in /var/www/vhosts/</strong></strong></strong>.org/httpdocs/wp-content/plugins/civicrm/civicrm/setup/src/Setup/DbUtil.php on line 204</h2>
  <p>Any thoughts on where to start? Happy to provide any info needed to help troubleshoot.  Thanks in advance.</p>
  
Tags: <wordpress>
Title: Wordpress install fails : Fatal Error: Uncaught
ThreadText: # Wordpress install fails : Fatal Error: Uncaught
  
  (Asked by: username_0 on 2021-03-25)
  
  I'm having an issue installing civicrm against a WordPress install. Plugin is installed. wp-content>uploads>civicrm is present, writable, and empty. I have specified a separate database to use. However, I was encountering the same issue when I tried to install against the WP database. This is the error I am receiving:
  
  ---
  
  ## Fatal error: Uncaught Civi\Setup\Exception\SqlException: 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 in /var/www/vhosts/******.org/httpdocs/wp-content/plugins/ in /var/www/vhosts/******.org/httpdocs/wp-content/plugins/civicrm/civicrm/setup/src/Setup/DbUtil.php on line 204
  
  Any thoughts on where to start? Happy to provide any info needed to help troubleshoot. Thanks in advance.
  
  **Tags:** wordpress
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-03-25. Score: 0 | Accepted answer
  
  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
  
  > **Comments:**
  > **username_0**: Thank you so much for your quick response.  I'll try that now.  Much appreciated :)  
  
  ---
  
  