Impossible to migrate db: nothing to migrate

[JordyProvost]

Lychee version

v7.0.1

Did you check the latest Lychee version?

Yes, I did

Which PHP version are you using?

PHP 8.5

Detailed description of the problem

When i update my docker compose to use a newer image from lycheeorg/lychee:v7.0.1 to an newer version, the database is not migrated.
Logs and interface shows "Nothing to migrate" but it seems the database is not migrated (stays on 070001).

🚀 Starting Lychee entrypoint...
🔍 Validating environment variables...
✅ Valid database connection type: sqlite
⚠️  WARNING: APP_DEBUG is enabled in production - this exposes sensitive information!
✅ Core variables validated
🎉 Environment validation complete!
Validating and setting PUID/PGID
Updating www-data UID to 10866
Updating www-data GID to 10866
  User UID: 10866
  User GID: 10866
🔍 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. 

From container:

root@a6665812c22f:/app# cat /app/version.md 
7.1.2

# php artisan migrate --force

   INFO  Nothing to migrate.

From host:

# sqlite3 <path_to_docker_mount>/database/database.sqlite "SELECT key, value FROM configs WHERE key='version';"
version|070001

if i change version to 070102 in database (with sqlite3 on the host), the interface says configs table is missing some keys.

Steps to reproduce the issue

1. from lycheeorg/lychee:v7.0.1 update compose yml file to use a newer image (say v7.1.2, but v7.4.0 is idem)
2. start the container from the new image
3. docker logs and interface say "Nothing to migrate" but db version stays on 070001

Diagnostics [REQUIRED]

# php artisan lychee:diagnostics


Smart Diagnostics
-----------------
Info: Hash: 5f3b53c16a24ab69—62cf82d204f0cc0a
         2142 files and 13733 vendor files
Warning: /*********c/uploads/ is owned by group www-data, but should be owned by one out of root
Warning: /*********c/uploads/ has permissions 0755, but should have 2775
Warning: /a********ge/tmp/jobs/ is owned by group www-data, but should be owned by one out of root
Warning: /a********ge/tmp/jobs/ has permissions 0750, but should have 2775
Warning: /a********ge/tmp/uploads/ is owned by group www-data, but should be owned by one out of root
Warning: /a********ge/tmp/uploads/ has permissions 0750, but should have 2775
Info: Full directory permission check is disabled
Error: php-intl extension is missing. Cannot validate currency code.
Warning: zend.assertions is disabled although Lychee is in debug mode. For easier debugging code generation for assertions should be enabled.
Warning: APP_URL is still set to default, this will break access to all your images and assets if you are using Lychee behind a sub-domain.
Error: Database is behind file version. Please apply the migrations.
Info: Found 1 medium that could be generated.
         You can use `php artisan lychee:generate_thumbs medium 1` to generate them.
Info: Have you considered supporting Lychee? :)

System Information
------------------
Lychee Version (release):                  7.1.2
DB Version:                                7.0.1

Docker:                                    lycheeorg-frankenphp
composer install:                          --no-dev
APP_ENV:                                   production
APP_DEBUG:                                 true
APP_URL:                                   default
APP_DIR:                                   default
LOG_VIEWER_ENABLED:                        false

System:                                    Linux
PHP Version:                               8.5.1
PHP User agent:                            Lychee/6 (https://lycheeorg.dev/)
Timezone:                                  Europe/Paris
Max uploaded file size:                    128M
Max post size:                             128M
Chunk size:                                102.40 MB
Max execution time:                        0
SQLite Version:                            3.46.1

exec() Available:                          yes
Imagick Available:                         1
Imagick Enabled:                           yes
Imagick Version:                           1809
GD Version:                                bundled (2.1.0 compatible)
Number of foreign key:                     31 found.

Config Information
------------------
version:                                   070001
check_for_updates:                         0
sorting_photos_col:                        taken_at
sorting_photos_order:                      ASC
sorting_albums_col:                        max_taken_at
sorting_albums_order:                      ASC
imagick:                                   1
skip_duplicates:                           0
small_max_width:                           0
small_max_height:                          360
medium_max_width:                          1920
medium_max_height:                         1080
lang:                                      fr
image_overlay_type:                        desc
default_license:                           none
compression_quality:                       90
grants_full_photo_access:                  1
delete_imported:                           0
mod_frame_enabled:                         1
mod_frame_refresh:                         30
thumb_2x:                                  1
small_2x:                                  1
medium_2x:                                 1
landing_page_enable:                       0
search_public:                             0
hide_version_number:                       0
recent_age:                                1
grants_download:                           0
photos_wraparound:                         1
map_display:                               0
zip64:                                     1
map_display_public:                        0
map_provider:                              Wikimedia
map_include_subalbums:                     0
update_check_every_days:                   3
has_exiftool:                              1
share_button_visible:                      0
import_via_symlink:                        0
has_ffmpeg:                                1
location_decoding:                         0
location_decoding_timeout:                 30
location_show:                             1
location_show_public:                      0
rss_enable:                                0
rss_recent_days:                           7
rss_max_items:                             100
prefer_available_xmp_metadata:             0
editor_enabled:                            1
lossless_optimization:                     0
local_takestamp_video_formats:             .avi|.mov
log_max_num_line:                          1000
unlock_password_photos_with_url_param:     0
nsfw_visible:                              1
nsfw_blur:                                 0
nsfw_warning:                              0
nsfw_warning_admin:                        0
nsfw_banner_override:                      
map_display_direction:                     1
album_subtitle_type:                       oldstyle
upload_processing_limit:                   4
new_photos_notification:                   0
zip_deflate_level:                         6
default_album_protection:                  1
album_decoration:                          layers
album_decoration_orientation:              row
allow_username_change:                     1
auto_fix_orientation:                      1
random_album_id:                           starred
use_last_modified_date_when_no_exif_date:  0
layout:                                    justified
date_format_photo_thumb:                   M j, Y, g:i:s A e
date_format_photo_overlay:                 M j, Y, g:i:s A e
date_format_sidebar_uploaded:              M j, Y, g:i:s A e
date_format_sidebar_taken_at:              M j, Y, g:i:s A e
date_format_hero_min_max:                  F Y
date_format_hero_created_at:               M j, Y, g:i:s A T
date_format_album_thumb:                   M Y
upload_chunk_size:                         0
nsfw_banner_blur_backdrop:                 0
search_pagination_limit:                   300
search_minimum_length_required:            4
photo_layout_justified_row_height:         320
photo_layout_masonry_column_width:         300
photo_layout_grid_column_width:            250
photo_layout_square_column_width:          200
photo_layout_gap:                          12
display_thumb_album_overlay:               always
display_thumb_photo_overlay:               hover
default_album_thumb_aspect_ratio:          1/1
use_album_compact_header:                  0
back_button_enabled:                       0
back_button_text:                          Return to Home
SA_random_thumbs:                          0
login_required:                            0
enable_unsorted:                           1
enable_starred:                            1
enable_recent:                             1
enable_on_this_day:                        1
login_required_root_only:                  1
dark_mode_enabled:                         1
low_quality_image_placeholder:             1
show_keybinding_help_popup:                1
show_keybinding_help_button:               1
disable_se_call_for_actions:               0
enable_se_preview:                         0
slideshow_timeout:                         5
keep_original_untouched:                   1
timeline_photos_enabled:                   1
timeline_photos_public:                    0
timeline_photos_granularity:               day
timeline_photos_order:                     taken_at
timeline_photos_layout:                    square
timeline_photos_pagination_limit:          200
timeline_albums_enabled:                   1
timeline_albums_public:                    0
timeline_albums_granularity:               year
timeline_left_border_enabled:              1
timeline_photo_date_format_year:           Y
timeline_photo_date_format_month:          M Y
timeline_photo_date_format_day:            j M Y
timeline_photo_date_format_hour:           g:i
timeline_album_date_format_year:           Y
timeline_album_date_format_month:          M Y
timeline_album_date_format_day:            j M
hide_nsfw_in_smart_albums:                 1
hide_nsfw_in_frame:                        1
hide_nsfw_in_map:                          1
hide_nsfw_in_search:                       1
search_photos_layout:                      square
hide_nsfw_in_rss:                          1
hide_nsfw_in_timeline:                     1
number_albums_per_row_mobile:              3
cache_enabled:                             0
cache_ttl:                                 86400
low_number_of_shoots_per_day:              10
medium_number_of_shoots_per_day:           50
high_number_of_shoots_per_day:             100
maintenance_processing_limit:              5000
disable_recursive_permission_check:        1
exif_disabled_for_all:                     0
file_name_hidden:                          0
default_old_settings:                      0
default_expert_settings:                   0
default_all_settings:                      0
client_side_favourite_enabled:             0
disable_thumb_download:                    1
disable_thumb2x_download:                  1
disable_small_download:                    0
disable_small2x_download:                  0
disable_medium_download:                   0
disable_medium2x_download:                 0
temporary_image_link_enabled:              0
temporary_image_link_when_logged_in:       0
temporary_image_link_when_admin:           0
temporary_image_link_life_in_seconds:      86400
secure_image_link_enabled:                 0
SA_override_visibility:                    0
TA_override_visibility:                    0
enable_colour_extractions:                 0
colour_extraction_driver:                  farzai
home_page_default:                         gallery
timeline_page_enabled:                     1
timeline_quick_access_date_format_year:    Y
timeline_quick_access_date_format_month:   M
timeline_quick_access_date_format_day:     j M
timeline_quick_access_date_format_hour:    h M, g:i
flow_enabled:                              1
flow_public:                               0
flow_base:                                 
flow_max_items:                            10
flow_strategy:                             auto
flow_include_sub_albums:                   0
flow_include_photos_from_children:         0
flow_open_album_on_click:                  0
flow_display_open_album_button:            0
flow_highlight_first_picture:              1
flow_min_max_enabled:                      1
flow_display_statistics:                   1
flow_compact_mode_enabled:                 1
flow_image_header_enabled:                 1
flow_image_header_cover:                   cover
flow_image_header_height:                  24
flow_carousel_enabled:                     1
flow_carousel_height:                      6
date_format_flow_published:                M j, Y, g:i:s A e
date_format_flow_min_max:                  F Y
flow_blur_nsfw_enabled:                    1
hide_nsfw_in_flow:                         1
skip_duplicates_early:                     1
sync_delete_missing_photos:                0
sync_delete_missing_albums:                0
sync_dry_run:                              1
gallery_header_enabled:                    0
gallery_header_logged_in_enabled:          0
gallery_header:                            
gallery_header_bar_transparent:            1
gallery_header_bar_gradient:               1
import_via_url_forbidden_localhost:        1
import_via_url_forbidden_local_ip:         1
import_via_url_require_https:              1
import_via_url_forbidden_ports:            1
details_links_enabled:                     0
details_links_public:                      0
is_scroll_to_navigate_photos_enabled:      1
is_swipe_vertically_to_go_back_enabled:    1
photo_thumb_tags_enabled:                  0
hide_nsfw_in_tag_albums:                   1
hide_nsfw_in_tag_listing:                  1
sorting_pinned_albums_col:                 created_at
sorting_pinned_albums_order:               DESC
copyright_text:                            
watermark_enabled:                         0
watermark_photo_id:                        
watermark_public:                          1
watermark_logged_in_users_enabled:         0
renamer_enabled:                           0
renamer_enforced:                          0
renamer_enforced_before:                   0
renamer_enforced_after:                    0
renamer_photo_title_enabled:               1
renamer_album_title_enabled:               1
extract_zip_on_upload:                     1
webshop_currency:                          EUR
webshop_default_description:               No description provided.
webshop_allow_guest_checkout:              1
webshop_terms_url:                         
webshop_privacy_url:                       
webshop_default_price_cents:               0
webshop_default_license:                   personal
webshop_default_size:                      medium
enable_untagged:                           1
photos_pagination_limit:                   500
deduplicate_pinned_albums:                 0
desktop_dock_full_transparency_enabled:    0
mobile_dock_full_transparency_enabled:     0
import_via_url_block_redirect:             1
enable_smart_album_per_owner:              0
rating_enabled:                            1
rating_public:                             0
rating_show_only_when_user_rated:          0
rating_show_avg_in_details:                1
rating_photo_view_mode:                    hover
rating_show_avg_in_photo_view:             0
rating_album_view_mode:                    hover
rating_show_avg_in_album_view:             1

Thanks in advance !

Browser & System [REQUIRED]

Browser: Chrome/Firefox/Brave
System: docker on Ubuntu 20.04.3 LTS, with Lychee behind a dockerized Nginx reverse proxy (handling TLS)

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.

[JordyProvost]

Ok i was suspecting my installation was at fault.

And indeed i have mounted this in the compose file:

• <path_to_docker_persistent_files>/data/database:/app/database

So /app/database/migrations was hidden by the mount.

Maybe add a check when database version is not matching lychee version and warn if "migrations" folder is missing ?
Or not, you will see.

[ildyria]

Maybe add a check when database version is not matching lychee version and warn if "migrations" folder is missing ?

you mean in the entrypoint of the docker ? That could be done indeed.

[ildyria]

Fixed #4156