Error 500 - Invalid or not existing database schema - after Update to 2.9.1

[HSoeren]

Describe the bug
After updating to the 2.9.1 (from 2.7.1) everything looks fine, the server info is happy about the update, database info is shown, but as soon as you try to access the items it just gives errors.

To Reproduce
Steps to reproduce the behavior:

1. Stopped Docker-Stack
2. Copied all docker-volumes to another folder as backup (usual backup strategy is a full backup of the host)
3. Pulled newer version
4. Started Docker Stack
5. Executed sudo -u www-data php bin/console cache:clear
6. Opening site, logging in, accessing a category.

Expected behavior
I expected a working update, ready to accept new items and show my stuff.

Screenshots

As you see: the categories are there. I think they are stored inside the DB as well, so it might not be an "oh are the db creds correct" issue. Previous Error messages (that are not shown to me anymore) indicated that as root cause.

but data seems to be existing inside, as the statistics works fine

Server Side

• Part-DB Version: 2.9.1
• Docker Image: jbtronics/part-db1:latest
• PHP Version: 8.4.18
• Database Server MySQL 8.0.45

Desktop (please complete the following information):

• OS: Windows 10
• Browser: Chrome
• Version: 145.0.7632.160

Additional context
I tried all the helping ideas from the error messages, without success unfortunatly. I have a logfile from docker, I don't want to share it publicly tho as my instance URL is everywhere in it.

An error thats often in there

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.eda_visibility' in 'field list' at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)
[stacktrace]

[HSoeren]

2.7.1 was old version, just checked the files.

[jbtronics]

Run the database migrations

[HSoeren]

Error still occurs / same error message

Tried the php bin/console doctrine:migrations:migrate command. Is there another command for a migration?

[d-buchmann]

Did you try php bin/console cache:pool:clear --all yet?
For me it made the difference after the update to 2.9.0.

[HSoeren]

Yep, i tried all the steps in the documentation for "how to upgrade" and also what's shown on the Pop-up of the error.
Also tried restarting the containers not sure if it makes a difference 😅

[jbtronics]

When you are running the command with sudo inside a docker container you have to use sudo -E to preserve the docker env variables. Otherwise partdb apply the migrations potentially to the wrong database.

[HSoeren]

Oh wow. That was it! I was not aware of that parameter. Took a note, might be useful somewhere else.

Everything works now. Thank you very very much!

Could you add that tip also to the documentation..? maybe i'm not the only one running into that.. Also all upgrades before worked without the -e :D