Server error 500 after docker image upgrade

[tomse]

using the docker :latest, I recently updated, to what appears to be a pre-release? v8.2.2-pre

now my system is effed up with server error 500, which I only deiscovered today

I tried upgrading to v8.3.1 which didn't fix the error

in the laravel.log I see snipeit.maintenances database table or view does not exist.

I believe the prior version I was running was v8.2.1

can anyone advise a fix here

I would believe that :latest would be a production ready tag, if it's mixed with pre-releases etc, which tags should I use to keep my platform stable?

[snipe]

You'll need to run migrations. (See the Docker tab in your case.)

v8.2.2-pre wasn't a pre-release, it was stable on master, just in between releases. The :latest tag will always have what's on the master branch (which is what we deploy from). https://hub.docker.com/r/snipe/snipe-it/tags - if you want to be locked into a specific version, you should pull the tag from that version.

[tomse]

thanks for the clarification that latest is stable.

if anyone sees this with the same error:
unfortunately running php artisan migrate fails with:
column not found: 1054 unknown column 'generation_expression' in 'field list'
which is because of a mysql incompatibility version, so it needs to be upgraded.

[tomse]

thank you very much lady snipe.
and thanks for the quick reply :-)

we're now back up running, and great help/well documented with all the possible errors one can get in your migration page.

[snipe]

Glad you’re sorted!