upgrade from 7 to 8 or 9

sanwhere

Hi guys, i've been trying to upgrade my forum and database from version beta 7 to 8 or 9.
i couldn't do it, everytime i'm getting errors.

what i am doing is:
-creating new flarum forum,
-copy the config.php file from old forum, to the new one's root.
-then trying to run php flarum migrate (also php flarum info giving me the same error)
i am getting this error:

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum_new.settings' doesn't exist in xxxxxxx\flarum_new\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:61

0 xxxxxxx\flarum_new\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(61): PDO->prepare('select `value`,...', Array)
1 xxxxxxx\flarum_new\vendor\illuminate\database\Connection.php(326): Doctrine\DBAL\Driver\PDOConnection->prepare('select `value`,...')
2 xxxxxxx\flarum_new\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('select `value`,...', Array)
3 xxxxxxx\flarum_new\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `value`,...', Array, Object(Closure))
4 xxxxxxx\flarum_new\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `value`,...', Array, Object(Closure))
5 xxxxxxx\flarum in xxxxxxx\flarum_new\vendor\illuminate\database\Connection.php on line 664

can you guys please help me?

i am on local now, my php version is 7.3.1, my mysql version is 5.7.24

luceos

DId you follow the upgrade instructions from beta 7 to 8?

https://discuss.flarum.org/d/17745

sanwhere

Hi,

I follow the recomended way to update it. Clean install to a new folder, than migrate it. But everytime i am getting the same error.

clarkwinkelmann

sanwhere what does the flarum_new database contains ? Was it your existing database ? Or is it a new database where you imported a backup ? Maybe some tables were not successfully imported when you moved the database manually ?

There should be a settings table on beta 7 as well.

Or maybe you don't have the correct database prefix set in the config file ?

sanwhere

clarkwinkelmann hi clark,

flarum_new database was the old database. after i replace the config.php i got this error. beta 7 was working with the same database on teknikforum.com, actually i was trying to upgrade my website to beta 9, but i couldn't do it. So i am trying to update it on local computer now, but i cant.

there is no prefix set, both configfiles are the same except database information.

maybe because of php versions, what do you think?

sanwhere

Any suggestion? 😒

clarkwinkelmann

sanwhere is there a settings table in your database prior to migration ?

sanwhere

clarkwinkelmann yes there is settings table in the database. (there are settings.frm and settings.ibd files also.

edit: i looked inside the database with PhpMyAdmin and see there is no tables in it.
How can it possible, website is working and there is no table on local with the same database?

clarkwinkelmann

sanwhere does your user has permission to see the tables ? Are you sure it's the correct database name ? Maybe it's not actually a local database, but on another server ?

sanwhere

no problem anymore, thank you guys.

gashmicky

sanwhere Hi sanwhere please share the information that how it works for you i.e upgrade from beta 7 i am getting same issue that you were faced thank you in advance