Upgrade + move flarum

adasiek

Hi,

I have flarum in beta2 version on my server. I couldn't upgrade to because my hosting provider disabled żonę functions needed in beta3. Now I have my own vps and I would like to move my Flarum and upgrade it. What is the easiest way of doing it?

My first thought was to install new flarum and then move the db. But I think this cannot be as simple as that. What should I do?

luceos

adasiek move the files, import the backup of the old database to your new location. Run composer update then open the admin page, confirm the database password.

If you encounter issues, leave a reply with detailed information where you got stuck.

Digital

Jean-MarcLegrand This is not the right place to test post. Please do it here.

Davis

I'd say copy all the files and database over and upgrade via composer on the new server.

adasiek

Thanks, but beta2 was installed without composer ? it was introduced in beta3.

Davis

adasiek Follow the instructions for beta2 to beta3 (this will be difficult) then use composer to upgrade to beta5 (hopefully beta6 here soon)

adasiek

Oh, @Davis, I have one more question. Is there any instruction about moving Flarum in beta2? I cannot upgrade it to beta3 on my current server (otherwise I wouldn't have need to move it).

jordanjay29

adasiek You should be able to download and move the files intact, and backup the database to import to the new server. Once you're on the new server, edit your config.php with the credentials of the new database where your Flarum install lives.

adasiek

Ok, sounds simple, thanks! I will try this ?

adasiek

Hi, I finally tried to do this. Moving flarum worked fine, but after updating to newer version I got an error in nginx error log:

Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forum.settings' doesn't exist' in /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php:319

should I create this table manually?

tlalok

adasiek Moving flarum worked fine, but after updating to newer version I got an error in nginx error log:

Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forum.settings' doesn't exist' in /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php:319

adasiek what do you mean by indeed rename table config by settings?

Because in the next version the name of table config change for settings.

So, I think you have to be the only one in this situation...
Me, I will try to install version 6 in this order :

backup my current flarum beta2
disable all extensions
Install beta6 with composer
create file config.php
Navigate to yourforum.com/admin and with luck the page "upgrade" will be displayed

Attention, I do not know if it works

edit : I have doubts that this will work...

jordanjay29

Did you import your database correctly? It looks like you have a prefix forum., make sure your config.php uses the same prefix.

adasiek

It is not prefix, it is database.table notation. I had similar error when I forgot to import db. But then the error was regarding forum.config. I have no table named settings in my db, because I am installing it from beta.2.

tlalok

adasiek you can't because flarum/composer-installer doesn't exist anymore ?

adasiek indeed rename table config by settings

The migration will not easy.

adasiek

And I cannot install beta3 with command:

composer.phar create-project flarum/flarum:v0.1.0-beta-3 . --stability=beta

because I am getting error:

Failed to clone https://github.com/flarum/composer-installer.git via https, ssh protocols, aborting.

tlalok

hum, try to install directly beta6.

adasiek

Ok, but how can I import all the data from beta.2? Is it possible?

adasiek

I understand it does not exist, but maybe there is another way? maybe there is fe. 5 tables to copy or so? I would not like to move it table-by-table and check if something breaks. Are you sure there is no option to upgrade forum from beta.2?

adasiek

what do you mean by indeed rename table config by settings?

adasiek

no, I'm pretty sure it doesn't, because of reasons it does not work now. when I am entering myforum.com/admin it expects me to have table settings. But when I am updating it expects me to have table config (to be precise, it expects I do not have table 'settings'). So, after installing beta.6 and switching database content to my beta.2 content, I will have the same problem.

I am out of ideas, to be honest.

And, just to make everything clear, here is the rest of stacktrace:
Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forum.settings' doesn't exist' in /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php:319 Stack trace: #0 /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php(319): PDO->prepare('selectvalue,...') #1 /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php(655): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'selectvalue,...', Array) #2 /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php(618): Illuminate\Database\Connection->runQueryCallback('selectvalue,...', Array, Object(Closure)) #3 /usr/share/nginx/flarum/vendor/illuminate/database/Connection.php(324): Illuminate\Database\Connection->run('selectvalue,...', Array, Object(Closure)) #4 /usr/share/nginx/flarum/vendor/illuminate/database/Query/Builder.php(1431): Illuminate\Database\Connection->select