Migration from 7.6.4 to 7.7.x keeps one stuck on the /migrate route

[Anbareth07]

Lychee version

v7.7.0

Did you check the latest Lychee version?

Yes, I did

Which PHP version are you using?

PHP 8.5

Detailed description of the problem

I had v7.6.4 running and due to the security related popups I wanted to migrate to latest version (7.7.1, same for 7.7.0).
After redeploying it keeps going to the /migrate route, which says 200, Nothing to migrate and then I'm stuck.

Had to revert to 7.6.4

Steps to reproduce the issue

Run a v7.6.4 deployment.
Redeploy with latest
Reopen page (any subroute) goes to migrate sub route

Diagnostics [REQUIRED]

No diagnostics page is opening, it redirects to migrate

Browser & System [REQUIRED]

Chrome Version 150.0.7871.186

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I understand my bug report will be removed if I haven't met the criteria above.
• I understand that if I am requested to provide more information, I must do so within 14 days or the bug report will be closed.

[ildyria]

Hi, could you give me more info of your setup ?

Database type?
Is it release or docker? Docker compose if so? which docker image ?

[Anbareth07]

Ok, tried again 7.7.1.

Log is:
🚀 Starting Lychee entrypoint...
🔍 Validating environment variables...
✅ Valid database connection type: sqlite
✅ Core variables validated
🎉 Environment validation complete!
Validating and setting PUID/PGID
User UID: 33
User GID: 33
🔍 Validating permissions...
⏰ Set Permissions for Lychee folders...
✅ Permissions set securely
⏰ Set Permissions for Upload/dist folders (this may take a while)...
✅ Permissions set securely
Checking RUN_AS_ROOT setting
✅ Will drop privileges to www-data user
🧹 Clearing bootstrap cache...
🌐 Starting Lychee in web mode...
🔄 Running database migrations...
INFO Nothing to migrate.
🧹 Optimizing application...
INFO Configuration cache cleared successfully.
INFO Configuration cached successfully.
INFO Route cache cleared successfully.
INFO Routes cached successfully.
INFO Compiled views cleared successfully.
INFO Blade templates cached successfully.
✅ Application ready!
INFO Server running….
Local: http://0.0.0.0:8000
Press Ctrl+C to stop the server
WARN Caddyfile input is not formatted; run 'caddy fmt --overwrite' to fix inconsistencies.
WARN HTTP/2 skipped because it requires TLS.
WARN HTTP/3 skipped because it requires TLS.

Running the proposed command returns
INFO Nothing to migrate.

The image doesn't include migration files in database/migrations/ it seems

So I'm still stuck on the original issue

[ildyria]

The image doesn't include migration files in database/migrations/ it seems

Not possible.
I just checked: https://gist.github.com/ildyria/bb20b1871f5fe197b9f00ba62731cd1c

Because you are using sqlite, what volume mounts did you use for the database ?

[Anbareth07]

My volume mounts are the following

/data/coolify/volumes/lychee/db : /app/database
/data/coolify/volumes/lychee/uploads : /app/public/uploads
/data/coolify/volumes/lychee/logs : /app/storage/logs
/data/coolify/volumes/lychee/tmp : /app/storage/tmp
/data/coolify/volumes/lychee/storage-app : /app/storage/app

I hope to have correctly followed https://lycheeorg.dev/docs/getting-started/docker/#version-7-frankenphp
Regarding empty folder from before, this was misleading from my side. There are files for sure. It seems the last migration is for 7.6.4 but none for newer versions which would (for me) explain the result of the migration call 'INFO Nothing to migrate.'

[ildyria]

That explains!
Here is your issue: /data/coolify/volumes/lychee/db : /app/database

You only need to mount /app/database/database.sqlite if you mount more, then you are overwriting the migrations which are added later. So you need:
/data/coolify/volumes/lychee/db/database.sqlite:/app/database/database.sqlite

[Anbareth07]

Thx @ildyria, this was it. Thx a lot for this sunday support :-)