upgrading problem

Nory

I have an issue with upgrading the extensions; I get this error message. I checked my database, and the tables are indeed in InnoDB. Do you have a solution?

"Update Flarum

Enter your database password to update Flarum.

Before you proceed, you should back up your database. If you have any trouble, get help on the Flarum website.
Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'access_tokens' already exists (SQL: create table access_tokens (id varchar(100) not null, user_id int unsigned not null, created_at timestamp not null, expires_at timestamp not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

clarkwinkelmann

Nory can you explain the history of your forum? Is this a recent installation? Have you previously updated Flarum (like from 1.7 to 1.8?). Have you moved server since Flarum was first installed?

To get this error, there is likely something wrong with your migrations table. But if you have previously installed extensions or updated Flarum on this same server, something must have happened after that time. If you have a manual access to the database, can you check if the migrations table contains anything?

flarum

Your question in theSupport tag seems to be missing the php flarum info output.

Providing this information in your initial request:

reduces back and forth asking for this information
can help us identify the root cause even when they're not apparent from your report
will result in more accurate answers to your request
allows us first-hand to identify the issue in case the Base URL is provided

Please consider editing your post and providing this output, see https://docs.flarum.org/troubleshoot for more information.

Thanks for your understanding.

[bot:require-info-command]

Nory

Hello,
My current version of Flarum is 1.8.3. It has been running for about a year without any server changes. The migration table is not empty and seems to contain the extensions that need to be updated.

This is not the first time I’ve encountered this issue. I usually revert to a previous version of my forum using backups provided by my hosting provider. This time, I tried to update all my extensions at once. To do this, I used Composer with the following command recommended by Luceos:
composer update -W --prefer-dist --no-dev -a.

At the end of the process, Composer reported several deprecated extensions that need to be replaced. Then, when I tried to access the forum in my browser, an error occurred. I attempted to delete the tables mentioned in the error message, but this did not resolve the problem.

Currently, I’ve reverted to an earlier version of my forum, which is working fine. However, I’d like to be able to update it more easily.

RelicSystem

I would advise following https://docs.flarum.org/update/ didn't see you mention you had run

php flarum migrate

It might be worth going over your extensions to find any that may be unsupported and/or abandoned ones and removing any problematic issues before upgrading.

In addition it may also be worth noting that if you do hit issues, before rolling back check

/storage/logs

and your PHP and webserver logs - this will greatly aid in helping debug your problems, ideally do all of this on a staging site if you can to prevent your live site from hitting issues.