Base table or view not found: Table 'database.prefix_settings' doesn't exist

przemekcichon

Hi Team,

I was trying to perform a clean install of Flarum today on the shared hosting with SSH access.

First I have called the command below
composer create-project flarum/flarum . --stability=beta

Then went to the installation screen where I could provide the database details, and once the installation was finished I got the following error notice:

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.prefix_settings' doesn't exist in /home/user/domains/example.com/public_html/vendor/illuminate/database/Connection.php:319 Stack trace: #0 /home/user/domains/example.com/public_html/vendor/illuminate/database/Connection.php(319): PDO->prepare('select `value`,...') #1 /home/user/domains/example.com/public_html/vendor/illuminate/database/Connection.php(655): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select `value`,...', Array) #2 /home/user/domains/example.com/public_html/vendor/illuminate/database/Connection.php(618): Illuminate\Database\Connection->runQueryCallback('select `value`,...', Array, Object(Closure)) #3 /home/user/domains/example.com/public_html/vendor/illuminate/database/Connection.php(324): Illuminate\Database\Connection->run('select `value`,...', Array, Object(Closure)) #4 /home/user/domains/example.com/public_html/vendor/i in /home/user/domains/example.com/public_html/vendor/illuminate/database/Connection.php on line 662

please note that database name, prefix as well as path were changed for the purpose of this post.

I have check the list of table and here there are:

+------------------------+
| Tables_in_database_prefix |
+------------------------+
| prefix_access_tokens      |
| prefix_api_keys           |
| prefix_auth_tokens        |
| prefix_config             |
| prefix_discussions        |
| prefix_email_tokens       |
| prefix_groups             |
| prefix_migrations         |
| prefix_notifications      |
| prefix_password_tokens    |
| prefix_permissions        |
| prefix_posts              |
| prefix_users              |
| prefix_users_discussions  |
| prefix_users_groups       |
+------------------------+
15 rows in set (0.00 sec)

no prefix_settings table at all.

Please note that it was a fresh install not an update and I have performed two attempts with the same results.

Thank you,
Przemek

KazeroG

przemekcichon is that the good path of the forum /home/user/domains/example.com/public_html/ ?

luceos

przemekcichon can you provide the MySQL version and PHP version?

przemekcichon

KazeroG I believe so. public_html/ is where I have run the composer create-project command.

Sorry for delayed response, somehow I did not get an email notification about your comment.

przemekcichon

luceos MySQL is MariaDB 10.1.24 and PHP 5.6.35

checked phpinfo and all these mbstring, pdo_mysql, openssl, json, gd, dom, fileinfo are enabled as well.

can MariaDB be an issue then?

thanks.

Prosperous

Please use the edit function instead of multi posting. ?

przemekcichon

Prosperous I did some cleanings, thanks ?

sammysalter

Hello. Just to say I also have this issue - new install, all those tables created except the settings table

edit: I fixed it by using a different version of PHP (7.1.9 instead of 7.0.23) - I'm using WAMP which makes it easy to switch but I use a totally different php.ini for each version of php which might explain it, maybe there are some config differences between my php versions. I don't know if that gives you or anyone else a head start in working this out!