flarum.settings table missing

moo1210

During the installation of flarum, after round 3 minutes it will display
Flarum encountered a boot error (Illuminate\Database\QueryException)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.settings' doesn't exist (SQL: select value, key from settings)
thrown in D:\testhtdocs\vendor\illuminate\database\Connection.php on line 664

How can I fix this? I am currently using the newest version of flarum and PHP 7.1.33

tankerkiller125

moo1210 Try running php flarum migrate in the flarum root directory, this may resolve the issue. However, I'm not sure how it will affect the install.

jordanjay29

moo1210 What is your MySQL/MariaDB version?

moo1210

tankerkiller125 Its takes 1 second and prints nothing, Still have the same flarum.settings doesn't exist error.

moo1210

jordanjay29 8.0.18 (MYSQL Community Server- GPL), I have no MYSQL errors in the log.

sergyu91ma

I have this problem too even if i run php flarum migrate

sergiu@yonan:/server/community.yonan.ro % php flarum migrate
PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forum_myco.settings' doesn't exist in /usr/local/www/apache24/data/community.yonan.ro/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61
Stack trace:
#0 /usr/local/www/apache24/data/community.yonan.ro/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(61): PDO->prepare('select value,...', Array)
#1 /usr/local/www/apache24/data/community.yonan.ro/vendor/illuminate/database/Connection.php(326): Doctrine\DBAL\Driver\PDOConnection->prepare('select value,...')
#2 /usr/local/www/apache24/data/community.yonan.ro/vendor/illuminate/database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database{closure}('select value,...', Array)
#3 /usr/local/www/apache24/data/community.yonan.ro/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select value,...', Array, Object(Closure))
#4 /usr/local/www/apache24/data/community.yonan.ro/vendor/illumin in /usr/local/www/apache24/data/community.yonan.ro/vendor/illuminate/database/Connection.php on line 664

sergyu91ma

it`s from php 7.4. i fixed by install the dev version

moo1210

sergyu91ma yeah but I don't recall flarum saying anywhere that a development version of php is required

sergyu91ma

moo1210 https://www.php.net/downloads.php 7.4 was released 10 days ago.

moo1210

sergyu91ma Still have same error, SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.settings' doesn't exist (SQL: selectvalue,keyfromsettings)

sergyu91ma

moo1210 i used the master branch of the flarum so that's why it worked on my side i think.
I saw that some things were fixed in master branch but you can wait for next beta release.

tankerkiller125

sergyu91ma this has been fixed in beta 12 (which is released!)

As far as the database issue unfortunately don't have answers.

sergyu91ma

tankerkiller125 cool. i just saw that after i replied. I`m upgrading now to beta 12.