Base table or view not found: 1146 Table 'flarum.settings' doesn't exist

idon69

So i was trying to install Flarum on the first time.

While it's installing, i see this error
"Something went wrong:"

So i check the logs and

[2024-10-24 14:20:30] flarum.ERROR: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.settings' doesn't exist in C:\Apache24\htdocs\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:82
Stack trace:
#0 C:\Apache24\htdocs\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(82): PDO->prepare()
#1 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(359): Illuminate\Database\Connection->run()
#5 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2413): Illuminate\Database\Connection->select()
#6 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#9 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#10 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#13 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#14 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#15 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#16 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}()
#19 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\Application.php(329): call_user_func()
#20 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#21 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 C:\Apache24\htdocs\vendor\flarum\core\src\Http\Server.php(59): Flarum\Foundation\InstalledSite->bootApp()
#24 C:\Apache24\htdocs\vendor\flarum\core\src\Http\Server.php(36): Flarum\Http\Server->safelyBootAndGetHandler()
#25 C:\Apache24\htdocs\public\index.php(26): Flarum\Http\Server->listen()
#26 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'omgskibidis.settings' doesn't exist in C:\Apache24\htdocs\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDO\Exception.php:18
Stack trace:
#0 C:\Apache24\htdocs\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(359): Illuminate\Database\Connection->run()
#5 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2413): Illuminate\Database\Connection->select()
#6 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#9 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#10 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#13 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#14 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#15 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#16 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}()
#19 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\Application.php(329): call_user_func()
#20 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#21 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 C:\Apache24\htdocs\vendor\flarum\core\src\Http\Server.php(59): Flarum\Foundation\InstalledSite->bootApp()
#24 C:\Apache24\htdocs\vendor\flarum\core\src\Http\Server.php(36): Flarum\Http\Server->safelyBootAndGetHandler()
#25 C:\Apache24\htdocs\public\index.php(26): Flarum\Http\Server->listen()
#26 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'omgskibidis.settings' doesn't exist (SQL: select value, key from settings) in C:\Apache24\htdocs\vendor\illuminate\database\Connection.php:712
Stack trace:
#0 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 C:\Apache24\htdocs\vendor\illuminate\database\Connection.php(359): Illuminate\Database\Connection->run()
#2 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2413): Illuminate\Database\Connection->select()
#3 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#4 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 C:\Apache24\htdocs\vendor\illuminate\database\Query\Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#6 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#7 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#8 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#9 C:\Apache24\htdocs\vendor\flarum\core\src\Settings\DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#10 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#11 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#12 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#13 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#14 C:\Apache24\htdocs\vendor\flarum\core\src\Extension\ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#15 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}()
#16 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\Application.php(329): call_user_func()
#17 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#18 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\InstalledSite.php(151): Flarum\Foundation\Application->boot()
#19 C:\Apache24\htdocs\vendor\flarum\core\src\Foundation\InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#20 C:\Apache24\htdocs\vendor\flarum\core\src\Http\Server.php(59): Flarum\Foundation\InstalledSite->bootApp()
#21 C:\Apache24\htdocs\vendor\flarum\core\src\Http\Server.php(36): Flarum\Http\Server->safelyBootAndGetHandler()
#22 C:\Apache24\htdocs\public\index.php(26): Flarum\Http\Server->listen()
#23 {main}

How do i resolve this?
PHP Version : 8.2.25
MySQL Version : 8.0.40

Oshvam

idon69 Delete the data from your installation, create a database, and re-run the Flarum installer.

It would be interesting to know how you are installing Flarum. Do you use it via Composer? It would also be good to know the PHP specs of your server, I have encountered impossible installations due to high max-imput-vars restrictions.

idon69

Oshvam Basically i used composer to installed it too, re-installing 'n stuff won't work

Oshvam

idon69 Could you share some details of your environment, is it a VPS, what PHP configuration do you have? It is complicated to be able to help you without information. Normally Flarum runs and installs without problems in most environments (I manage 9 forums and have had no problems).

idon69

Oshvam Not an VPS. It's self-hosted. The php.ini looks fine to me since it has all the required extensions enabled.

idon69

idon69 It runs Windows 7 Enterprise 64bit too.

luceos

Seems a config.php exists, but the database tables have not yet been created. Delete the config.php if your database is still empty.

idon69

its still happening

luceos

Delete your config.php, recreate the database and run the installer php flarum install. If that doesn't help, then your config.php is probably still existing (cached) or so; without a screenshot of your directory structure and more information on your hosting environment it's hard to tell.

idon69

luceos Problem is solved using php flarum install. Thank you, lifesaver