Answers.Body: <p>I would try to manually create this missing table. there are only two columns: id (primary key with auto-increment) and name.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-12T09:19:13.243Z
Answers.Text: Thanks, but I'm afraid that there is a more fundamental problem here and new queries will only fail if the problem isn't fixed properly.
Answers.UserDisplayName: SaKa
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-07T09:55:56.003Z
Answers.LastActivityDate: 2022-12-09T16:03:47.483Z
Answers.LastEditDate: 2022-12-09T16:03:47.483Z
Answers.UserDisplayName: Guillaume Sorel
Answers.Body: <p>PHP8 is not recommended, see the System Requirements <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/" rel="nofollow noreferrer">Docs here</a>.</p>
  <p>PLease try again with PHP7.4.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-05T10:41:27.733Z
Answers.Text: I'm running php version 7.4.
  MySQL is version 8
Answers.UserDisplayName: SaKa
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-06T11:21:12.123Z
Answers.Text: Sorry, i have misread your Infos
Answers.UserDisplayName: J.C.
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-09T16:05:14.193Z
Answers.Text: I think those docs are a bit out of date now, CiviCRM itself runs fine with PHP 8.0 however some extensions might not be fully compatible.
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-12T09:17:12.723Z
Answers.Text: I'll try it with php 8. Thanks for your answer.
Answers.UserDisplayName: SaKa
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-12T10:28:13.070Z
Answers.Text: So I've installed XAMPP because it comes with php8 out of the box and now I'm able to install and run Civicrm. Whether the issue is actually caused by an incompatible php version remains unclear.
  Just a note for other people trying to run Civicrm wirh XAMPP or AMPPS. If you get an error about "Unable to load dynamic library "..../php_intl.dll" - The specified module could not be found." Open your xampp/php/php.ini and uncomment 'extension=intl'
  
  Thanks all for helping me out!
Answers.UserDisplayName: SaKa
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-05T07:09:07.820Z
Answers.LastActivityDate: 2022-12-05T07:09:07.820Z
Answers.UserDisplayName: J.C.
Body: <p>Using Ampp version 4.3 with Apache v2.4.54, MySQL v8.0.31, php version 7.4.32, Windows</p>
  <p>Every time I run the CiviCrm installer I get an error &quot;Table 'civicrm.civicrm_worldregion' doesn't exist in ... &quot; I've tried to add the innodb settings in mysql.conf but mysql doesn't know these entries.
  The table is indeed not present in my DB (using the same DB as wordpress).</p>
  <p>I don't know how to continue and I would like to get some help. Thanks</p>
  <p>Whole error message is <code>Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute /******************************************************* * * civicrm_county * *******************************************************/ INSERT INTO civicrm_worldregion (id, name) VALUES(&quot;1&quot;, &quot;Europe and Central Asia&quot;): Table 'civicrm.civicrm_worldregion' doesn't exist in C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\setup\src\Setup\DbUtil.php:206 Stack trace: #0 C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\setup\plugins\installDatabase\InstallSchema.civi-setup.php(85): Civi\Setup\DbUtil::sourceSQL() #1 C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\vendor\symfony\event-dispatcher\EventDispatcher.php(264): InstallSchemaPlugin-&gt;installDatabase() #2 C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\vendor\symfony\event-dispatcher\EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher-&gt;doDispatch() #3 C:\Pro in C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\setup\src\Setup\DbUtil.php on line 206</code></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-05T14:18:26.590Z
Comments.Text: Welcome to SE!  Have a look at your log file - are there errors in there before that one?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-12T09:16:27.813Z
Comments.Text: There are a bunch of warnings but only one fatal error. I've deleted my civicrm upload folder and run the installer again. A similar error is thrown. Now it's about the civicrm_acl table. 
  Cannot execute LOCK TABLES `civicrm_acl` WRITE: Table 'civicrm.civicrm_acl' doesn't exist
Comments.UserDisplayName: SaKa
Tags: <wordpress><database><installation><mysql><issues>
Title: Civicrm on Wordpress installer table doesnt exist
ThreadText: # Civicrm on Wordpress installer table doesnt exist
  
  (Asked by: username_0 on 2022-12-04)
  
  Using Ampp version 4.3 with Apache v2.4.54, MySQL v8.0.31, php version 7.4.32, Windows
  
  Every time I run the CiviCrm installer I get an error "Table 'civicrm.civicrm\_worldregion' doesn't exist in ... " I've tried to add the innodb settings in mysql.conf but mysql doesn't know these entries.
  The table is indeed not present in my DB (using the same DB as wordpress).
  
  I don't know how to continue and I would like to get some help. Thanks
  
  Whole error message is `Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute /******************************************************* * * civicrm_county * *******************************************************/ INSERT INTO civicrm_worldregion (id, name) VALUES("1", "Europe and Central Asia"): Table 'civicrm.civicrm_worldregion' doesn't exist in C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\setup\src\Setup\DbUtil.php:206 Stack trace: #0 C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\setup\plugins\installDatabase\InstallSchema.civi-setup.php(85): Civi\Setup\DbUtil::sourceSQL() #1 C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\vendor\symfony\event-dispatcher\EventDispatcher.php(264): InstallSchemaPlugin->installDatabase() #2 C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\vendor\symfony\event-dispatcher\EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch() #3 C:\Pro in C:\Program Files\Ampps_4_2\www\civicrm.test\wp-content\plugins\civicrm\civicrm\setup\src\Setup\DbUtil.php on line 206`
  
  **Tags:** wordpress, database, installation, mysql, issues
  
  > **Comments:**
  > **username_1**: Welcome to SE!  Have a look at your log file - are there errors in there before that one?  
  > **username_0**: There are a bunch of warnings but only one fatal error. I've deleted my civicrm upload folder and run the installer again. A similar error is thrown. Now it's about the civicrm_acl table.  Cannot execute LOCK TABLES `civicrm_acl` WRITE: Table 'civicrm.civicrm_acl' doesn't exist  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2022-12-07. Score: 0
  
  I would try to manually create this missing table. there are only two columns: id (primary key with auto-increment) and name.
  
  > **Comments:**
  > **username_0**: Thanks, but I'm afraid that there is a more fundamental problem here and new queries will only fail if the problem isn't fixed properly.  
  
  ---
  
  ### Answer by username_3 on 2022-12-05. Score: 0
  
  PHP8 is not recommended, see the System Requirements [Docs here](https://docs.civicrm.org/installation/en/latest/general/requirements/).
  
  PLease try again with PHP7.4.
  
  > **Comments:**
  > **username_0**: I'm running php version 7.4. MySQL is version 8  
  > **username_3**: Sorry, i have misread your Infos  
  > **username_4**: I think those docs are a bit out of date now, CiviCRM itself runs fine with PHP 8.0 however some extensions might not be fully compatible.  
  > **username_0**: I'll try it with php 8. Thanks for your answer.  
  > **username_0**: So I've installed XAMPP because it comes with php8 out of the box and now I'm able to install and run Civicrm. Whether the issue is actually caused by an incompatible php version remains unclear. Just a note for other people trying to run Civicrm wirh XAMPP or AMPPS. If you get an error about "Unable to load dynamic library "..../php_intl.dll" - The specified module could not be found." Open your xampp/php/php.ini and uncomment 'extension=intl'  Thanks all for helping me out!  
  
  ---
  
  