Error after migration from version 3.1 - no gallery

[bartm83]

Lychee version

v6.2

Which PHP version are you using?

PHP 8.3

Detailed description of the problem

After migration from version 3.1 to 6.2.0 galleries do not show up. In error log i've:
[2025-01-28 10:05:09] production.ERROR: Illuminate\Foundation\Bootstrap\HandleExceptions::Illuminate\Foundation\Bootstrap\{closure}:74 Attempt to read property "username" on null
..

What am I doing wrong?

Steps to reproduce the issue

Migration from version 3.1 according to documentation https://lycheeorg.dev/docs/upgrade.html After migration, galleries are not visible.

Diagnostics [REQUIRED]

Errors
info
Found 34316 small that could be generated.
info
Found 34242 small2x that could be generated.
info
Found 60 medium that could be generated.
info
Found 19013 medium2x that could be generated.
info
Found 34325 placeholders that could be generated.
info
Found 100011 small images without filesizes.
info
Have you considered supporting Lychee? :)
Info

Lychee Version (release):                  6.2.0
DB Version:                                6.2.0
composer install:                          --no-dev
APP_ENV:                                   production
APP_DEBUG:                                 false
APP_URL:                                   set
APP_DIR:                                   default
LOG_VIEWER_ENABLED:                        true
VUEJS_ENABLED:                             true
PHOTO_PIPES:                               true
System:                                    Linux
PHP Version:                               8.3.16
PHP User agent:                            Lychee/4 (https://lycheeorg.github.io/)
Timezone:                                  Europe/Warsaw
Max uploaded file size:                    30M
Max post size:                             100M
Chunk size:                                30.00 MB
Max execution time:                        200
MySQL Version:                             8.0.37-29
exec() Available:                          yes
Imagick Available:                         1
Imagick Enabled:                           1
Imagick Version:                           1691
GD Version:                                2.3.3
Number of foreign key:                     24 found.

		

Space

Lychee total space:                        132.27 GB
Upload folder space:                       132.18 GB
System total space:                        294.23 GB
System free space:                         57.06 GB (19%)

		

Configuration

version:                                   060200
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:                                      en
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
force_migration_in_production:             0
search_public:                             0
hide_version_number:                       0
SL_enable:                                 0
SL_for_admin:                              0
recent_age:                                1
grants_download:                           0
photos_wraparound:                         1
map_display:                               0
zip64:                                     1
map_display_public:                        0
map_provider:                              Wikimedia
force_32bit_ids:                           0
map_include_subalbums:                     0
update_check_every_days:                   3
has_exiftool:                              0
share_button_visible:                      0
import_via_symlink:                        0
has_ffmpeg:                                0
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
swipe_tolerance_x:                         150
swipe_tolerance_y:                         250
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
legacy_id_redirection:                     1
zip_deflate_level:                         6
default_album_protection:                  1
album_decoration:                          layers
album_decoration_orientation:              row
allow_username_change:                     1
auto_fix_orientation:                      1
use_job_queues:                            0
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:                   1000
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
login_button_position:                     left
back_button_enabled:                       0
back_button_text:                          Return to Home
current_job_processing_visible:            1
SA_random_thumbs:                          0
job_processing_queue_visible:              1
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

Browser & System [REQUIRED]

All (Firefox, Edge)

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.

[ildyria]

That is a damn of an update. It seems that something went wrong at the user creation.
This is going to be a bit painful but we can recover from that.
Do you have access to your database?
You are using MySQL so that should be fine.
Can you do the following queries:

SELECT id, username FROM users;

SELECT DISTINCT owner_id FROM photos;

This should give us the answer of why it is crashing.

[bartm83]

Sure:
SELECT id, username FROM users;`
:

+----+----------+
| id | username |
+----+----------+
|  1 | admin    |
+----+----------+
1 row in set (0,00 sec)

SELECT DISTINCT owner_id FROM photos;

+----------+
| owner_id |
+----------+
|        0 |
+----------+
1 row in set (0,02 sec)

[ildyria]

Perfect.

UPDATE photos SET owner_id = '1' WHERE owner_id = '0'

It seems that for some reasons
this migration: https://github.com/LycheeOrg/Lychee/blob/master/database/migrations/2022_12_10_183251_increment_user_i_ds.php did not run. The query above should fix it.

[bartm83]

Thank you very much, the above SQL helped a bit :) I also had to execute

UPDATE base_albums SET owner_id = '1' WHERE owner_id = '0'

and now everything works :)