Can't migrate to a VPS to another

miowski

So I tried migrating from one VPS to another, following these instructions.

Installing and restoring the db went fine, but I keep on getting this error when trying to install :

Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'migrations' already exists (SQL: create table `migrations` (`migration` varchar(255) not null, `extension` varchar(255) null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

What do I do ?

Thank you all in advance

luceos

miowski did you run the installer through the web interface?

miowski

Actually, I've managed to install it. I had forgotten this :
cd flarum-dirbkp/ cp -Rv config.php storage/ assets/ /var/www/fresh-new-flarum/

miowski

But my new issue is that

SQLSTATE[HY000] [1045] Access denied for user 'flarumuser'@'localhost' (using password: YES)
thrown in /var/www/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 31

I actually dont have the password for the previous database anymore. Isn't there a way I can fix this ?

luceos

miowski you can modify the database settings in the config.php to reflect those of your new database (or reset the password if you lost it).

miowski

luceos Thanks !

Now it seems like I have a 500 error when trying to load the forum. What can I do to troubleshoot this ?

luceos

miowski set debug to true instead of false and/or check storage/logs for the latest error log triggered by Flarum.

miowski

Okay, I've done that.

However there's no recent logs in config/logs. img

What do I do once I've set debug to true ?

clarkwinkelmann

miowski What do I do once I've set debug to true ?

access the website again. debug makes Flarum show the errors on the page.

If the error comes from apache/nginx, it will be logged in their respective log files or system logs.

miowski

clarkwinkelmann Seems like it was a permission error.

I think I have it fixed, but now all I can see is a reduced version of my site :

https://forum.aper.me/

How can I fix this ?

miowski

Worse, links on that page redirect to the old forum that I was planning on closing soon :/ (see how the domain changes while clicking on a topic link)

askvortsov

miowski Can you check the "url" entry in your config.php and make sure it's pointing towards the right site?

miowski

Okay, the site seems to be working a bit better now ! The UI loads normally, but neither the site logo neither fa icons are loading. What can I do about it ?

clarkwinkelmann

miowski make sure you copy the public/assets folder over to the new website.