Answers.Body: <p>This appears to be an incompatibilty with php 8, even though the message initially suggests a SQL problem.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-19T21:48:02.803Z
Answers.LastActivityDate: 2021-02-19T21:48:02.803Z
Answers.UserDisplayName: Demerit
Body: <p>I'm trying to run CiviCRM v.5.34.0 with Wordpress v.5.6.1 on a local server. Unfortunately the installation of CiviCRM crashes with the following error:</p>
  <p><code>Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE `civicrm_address_format` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Format Id', `format` text [...]</code></p>
  <p><a href="https://i.sstatic.net/HkDAv.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/HkDAv.jpg" alt="enter image description here" /></a></p>
  <p>The server is running via xampp v3.2.4:</p>
  <ul>
  <li>Server-Typ: MariaDB</li>
  <li>Server-Verbindung: SSL wird nicht verwendet Dokumentation</li>
  <li>Server-Version: 10.4.17-MariaDB - mariadb.org binary distribution</li>
  <li>Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/8.0.2</li>
  <li>Datenbank-Client Version: libmysql - mysqlnd 8.0.2</li>
  <li>PHP-Erweiterung: mysqli Dokumentation curl Dokumentation mbstring Dokumentation</li>
  <li>PHP-Version: 8.0.2</li>
  </ul>
  <p>The mysql user has all privileges and GRANT access.</p>
  <p>I really would like to test CiviCRM to see if it satisfies my needs, which it promises to do.</p>
  <p>Hope someone can help me.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-19T19:41:53.927Z
Comments.Text: Even though it looks like a SQL error, it might be a php 8 issue. CiviCRM hasn't been well tested with php 8.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-19T20:47:31.670Z
Comments.Text: Thank you. Although not fixing the problem with the original setup, I was able to set up a running CiviCRM on an xampp version with php 7.3.27. If you can add this as an answer I will mark it accordingly.
Comments.UserDisplayName: ElSorro
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-19T21:48:24.333Z
Comments.Text: Ok thanks. Have added answer.
Comments.UserDisplayName: Demerit
Tags: <wordpress><installation><failure>
Title: Installation on local wordpress server
ThreadText: # Installation on local wordpress server
  
  (Asked by: username_0 on 2021-02-19)
  
  I'm trying to run CiviCRM v.5.34.0 with Wordpress v.5.6.1 on a local server. Unfortunately the installation of CiviCRM crashes with the following error:
  
  `Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE `civicrm_address_format` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Format Id', `format` text [...]`
  
  [![enter image description here](https://i.sstatic.net/HkDAv.jpg)](https://i.sstatic.net/HkDAv.jpg)
  
  The server is running via xampp v3.2.4:
  
  * Server-Typ: MariaDB
  * Server-Verbindung: SSL wird nicht verwendet Dokumentation
  * Server-Version: 10.4.17-MariaDB - mariadb.org binary distribution
  * Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/8.0.2
  * Datenbank-Client Version: libmysql - mysqlnd 8.0.2
  * PHP-Erweiterung: mysqli Dokumentation curl Dokumentation mbstring Dokumentation
  * PHP-Version: 8.0.2
  
  The mysql user has all privileges and GRANT access.
  
  I really would like to test CiviCRM to see if it satisfies my needs, which it promises to do.
  
  Hope someone can help me.
  
  **Tags:** wordpress, installation, failure
  
  > **Comments:**
  > **username_1**: Even though it looks like a SQL error, it might be a php 8 issue. CiviCRM hasn't been well tested with php 8.  
  > **username_0**: Thank you. Although not fixing the problem with the original setup, I was able to set up a running CiviCRM on an xampp version with php 7.3.27. If you can add this as an answer I will mark it accordingly.  
  > **username_1**: Ok thanks. Have added answer.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-02-19. Score: 0 | Accepted answer
  
  This appears to be an incompatibilty with php 8, even though the message initially suggests a SQL problem.
  
  
  ---
  
  