部署时数据库出错

小码同学

我使用的PHP是8.1.11，flarum是V1.7，MySQL是mysql Ver 8.0.33 for Linux on x86_64 (MySQL Community Server - GPL)，没有使用docker，都是使用直接安装的方式，求助，下面是错误日志：
Flarum encountered a boot error (Illuminate\Database\QueryException)
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db_flarum.tb_settings’ doesn’t exist (SQL: select value, key from tb_settings)
thrown in /opt/flarum/vendor/illuminate/database/Connection.php on line 712

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db_flarum.tb_settings’ doesn’t exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(82): PDO->prepare(‘select value,…’, Array)
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare(‘select value,…’)
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select value,…’, Array)
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback(‘select value,…’, Array, Object(Closure))
#4 /opt/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run(‘select value,…’, Array, Object(Closure))
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select(‘select value,…’, Array, true)
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck(‘value’, ‘key’)
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get(‘extensions_enab…’, NULL)
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(393): Flarum\Settings\DefaultSettingsRepository->get(‘extensions_enab…’)
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(363): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(381): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend(Object(Illuminate\Container\Container))
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}(Object(Flarum\Foundation\Application))
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func(Object(Closure), Object(Flarum\Foundation\Application))
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks(Array)
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Http/Server.php(59): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/vendor/flarum/core/src/Http/Server.php(36): Flarum\Http\Server->safelyBootAndGetHandler()
#25 /opt/flarum/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 ‘db_flarum.tb_settings’ doesn’t exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare(‘select value,…’)
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select value,…’, Array)
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback(‘select value,…’, Array, Object(Closure))
#4 /opt/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run(‘select value,…’, Array, Object(Closure))
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select(‘select value,…’, Array, true)
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck(‘value’, ‘key’)
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get(‘extensions_enab…’, NULL)
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(393): Flarum\Settings\DefaultSettingsRepository->get(‘extensions_enab…’)
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(363): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(381): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend(Object(Illuminate\Container\Container))
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}(Object(Flarum\Foundation\Application))
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func(Object(Closure), Object(Flarum\Foundation\Application))
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks(Array)
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Http/Server.php(59): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/vendor/flarum/core/src/Http/Server.php(36): Flarum\Http\Server->safelyBootAndGetHandler()
#25 /opt/flarum/public/index.php(26): Flarum\Http\Server->listen()
#26 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db_flarum.tb_settings’ doesn’t exist (SQL: select value, key from tb_settings) in /opt/flarum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback(‘select value,…’, Array, Object(Closure))
#1 /opt/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run(‘select value,…’, Array, Object(Closure))
#2 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select(‘select value,…’, Array, true)
#3 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck(‘value’, ‘key’)
#7 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#8 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get(‘extensions_enab…’, NULL)
#10 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(393): Flarum\Settings\DefaultSettingsRepository->get(‘extensions_enab…’)
#11 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\Extension\ExtensionManager->getEnabled()
#12 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(363): Flarum\Extension\ExtensionManager->getExtensions()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(381): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend(Object(Illuminate\Container\Container))
#15 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}(Object(Flarum\Foundation\Application))
#16 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func(Object(Closure), Object(Flarum\Foundation\Application))
#17 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks(Array)
#18 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#20 /opt/flarum/vendor/flarum/core/src/Http/Server.php(59): Flarum\Foundation\InstalledSite->bootApp()
#21 /opt/flarum/vendor/flarum/core/src/Http/Server.php(36): Flarum\Http\Server->safelyBootAndGetHandler()
#22 /opt/flarum/public/index.php(26): Flarum\Http\Server->listen()
#23 {main}

Eric_Lian

那就是 flarum 根本就没安装数据库，他连到了一个空的数据库里

小码同学

Eric_Lian
这是我的配置信息，MySQL和PHP都是在本地安装的，这样配置应该没问题吧
[root@ECS-4214242469 flarum]# ls
CHANGELOG.md composer.json composer.lock config.php config.yml extend.php flarum LICENSE public README.md site.php storage vendor
[root@ECS-4214242469 flarum]# cat config.php
<?php return array (
‘debug’ => true,
‘offline’ => false,
‘database’ => array (
‘driver’ => ‘mysql’,
‘host’ => ‘127.0.0.1’,
‘port’ => ‘3306’,
‘database’ => ‘db_flarum’,
‘username’ => ‘flarum’,
‘password’ => ‘X7XXXXXXrZfT’,
‘charset’ => ‘utf8mb4’,
‘collation’ => ‘utf8mb4_unicode_ci’,
‘prefix’ => ‘tb’,
‘strict’ => false,
),
‘url’ => ‘https://guangruan.life’,
‘paths’ => array (
‘api’ => ‘api’,
‘admin’ => ‘admin’,
),
);
[root@ECS-4214242469 flarum]# cat config.yml
debug: flase
baseUrl: https://guangruan.life
databaseConfiguration:
driver: mysql
host: 127.0.0.1
database: db_flarum
username: flarum
password: X7XXXZfT
prefix: tb
port: 3306
adminUser:
username: XXX
password: XXXX
email: 134XXX@qq.com
settings:
forum_title: 生活

拜瑞

小码同学你要不试试 php flarum migrate ？

小码同学

拜瑞 php flarum migrate

刚刚试了一下，报错内容还是一样，都不知道怎么回事
[root@ECS-4214242469 flarum]# php flarum migrate

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db_flarum.tb_settings’ doesn’t exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(82): PDO->prepare(‘select value,…’, Array)
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare(‘select value,…’)
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select value,…’, Array)
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback(‘select value,…’, Array, Object(Closure))
#4 /opt/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run(‘select value,…’, Array, Object(Closure))
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select(‘select value,…’, Array, true)
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck(‘value’, ‘key’)
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get(‘extensions_enab…’, NULL)
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(393): Flarum\Settings\DefaultSettingsRepository->get(‘extensions_enab…’)
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(363): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(381): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend(Object(Illuminate\Container\Container))
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}(Object(Flarum\Foundation\Application))
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func(Object(Closure), Object(Flarum\Foundation\Application))
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks(Array)
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#25 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db_flarum.tb_settings’ doesn’t exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare(‘select value,…’)
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select value,…’, Array)
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback(‘select value,…’, Array, Object(Closure))
#4 /opt/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run(‘select value,…’, Array, Object(Closure))
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select(‘select value,…’, Array, true)
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck(‘value’, ‘key’)
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get(‘extensions_enab…’, NULL)
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(393): Flarum\Settings\DefaultSettingsRepository->get(‘extensions_enab…’)
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(363): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(381): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend(Object(Illuminate\Container\Container))
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}(Object(Flarum\Foundation\Application))
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func(Object(Closure), Object(Flarum\Foundation\Application))
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks(Array)
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#25 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db_flarum.tb_settings’ doesn’t exist (SQL: select value, key from tb_settings) in /opt/flarum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback(‘select value,…’, Array, Object(Closure))
#1 /opt/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run(‘select value,…’, Array, Object(Closure))
#2 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select(‘select value,…’, Array, true)
#3 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2628): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck(‘value’, ‘key’)
#7 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#8 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get(‘extensions_enab…’, NULL)
#10 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(393): Flarum\Settings\DefaultSettingsRepository->get(‘extensions_enab…’)
#11 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\Extension\ExtensionManager->getEnabled()
#12 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(363): Flarum\Extension\ExtensionManager->getExtensions()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(381): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend(Object(Illuminate\Container\Container))
#15 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension{closure}(Object(Flarum\Foundation\Application))
#16 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func(Object(Closure), Object(Flarum\Foundation\Application))
#17 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks(Array)
#18 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#20 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#21 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#22 {main}
thrown in /opt/flarum/vendor/illuminate/database/Connection.php on line 712

拜瑞

小码同学那没事了，重装吧

哦对，你怎么装的 Flarum

小码同学

拜瑞
使用这个命令，composer create-project flarum/flarum .

小码同学

拜瑞
使用这个命令创建的下项目，没有config.php和config.yml的配置，很奇怪

拜瑞

小码同学 Flarum 里是不用 config.yml 的，你重装一个试试吧

Eric_Lian

小码同学是的符合预期，因为你要第一次打开 flarum 的时候，他才会有安装界面。

如果 config.php 存在，他就会用 config.php 里的信息进行加载数据库，如果 config.php 不存在，他就会显示安装界面。

Image description

在 flarum 的安装说明里写的是，当你配置好伪静态后，请打开浏览器进行安装。可没提到要手动编写 config.php

小码同学

拜瑞
在重装了，想看看老哥的nginx怎么配置的啊，这是我的nginx配置文件，安装PHP的时候，需要在php.ini配置什么东西嘛
server {
listen 80;
server_name guangruan.life;
return 301 https://$server_name$request_uri;

}
server {
listen 443 ssl;
server_name guangruan.life;

ssl_certificate cert/guangruan.life/cert.pem;
ssl_certificate_key cert/guangruan.life/key.pem;

client_max_body_size 1024M;
root /wwww/flarum/public; # 改为你的Flarum主目录对应路径
access_log /usr/local/nginx/logs/access.log;
error_log /usr/local/nginx/logs/error.log;
index index.php;
include /www/flarum/.nginx.conf*;

php-fpm

location ~* .php$ {
fastcgi_pass 127.0.0.1:9000; #你在fpm中监听的端口
fastcgi_index index.php;
include /usr/local/nginx/conf/fastcgi.conf;
}
}

拜瑞

小码同学我感觉是你数据库没配好

小码同学

拜瑞
数据库我用MySQL 8.1.11，社区版，已经启动了，数据库的用户也可以正常登陆创建数据库和数据表，也可以查询。难道在flarum配置数据的时候，还需要初始化数据库的嘛？或者要添加上面字段嘛？我看官方文档没有写这

拜瑞

小码同学你把 config.php 备份一遍，然后把数据库相关内容删掉，不出意外的话会进入 Flarum 的初始化界面，你再次初始化试试？

小码同学

拜瑞
按照你说的，进入了，似乎要求我安装gd扩展，老哥帮忙看看？我的网站：https://guangruan.life/
The PHP extension ‘gd’ is required.

小码同学

检查了一下，似乎有。
[root@ECS-4214242469 flarum]# rpm -qa | grep gd
gdb-7.6.1-120.el7.x86_64
gdbm-1.10-8.el7.x86_64
gd-2.0.35-27.el7_9.x86_64
[root@ECS-4214242469 flarum]# yum list | grep php-gd
http://mirror.centos.org/centos/7/PowerTools/x86_64/os/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
To address this issue please refer to the below wiki article

https://wiki.centos.org/yum-errors

If above article doesn’t help to resolve this issue please use https://bugs.centos.org/.

php-gd.x86_64 5.4.16-48.el7 base

拜瑞

小码同学 Flarum 根目录里输入 php flarum info ，输出的内容里有一栏就是关于 PHP 插件的

拜瑞

小码同学 Unknown database ‘flarum’

你数据库呢🤔

小码同学

拜瑞
数据库flarum不是自动创建的嘛？我进去创建了flarum数据库，刷新一下，错误就变成找不到settings数据库之类的了，不知道怎么回事😭

小码同学

小码同学
数据库flarum不是自动创建的嘛？我进去创建了flarum数据库，刷新一下，错误就变成找不到settings数据表之类的了，不知道怎么回事😭

Eric_Lian

摆烂吧，删掉 config.php 重装算了。

小码同学

Eric_Lian
删掉config.php，要怎么重装啊，我在其他地方重装了几遍，都是这样