Cannot create Albums anymore - Error: Numeric value out of range: 1264 Out of range value for column 'legacy_id' at row 1

[navjinder]

Lychee version

5.1.2

Which PHP version are you using?

PHP 8.2

Detailed description of the problem

When I try to create a sub album it gives me 500 ModelDBException Updating album failed error. Previously I have created 4 albums without any issue.

In the logs it shows this error:

2024-02-09 15:30:37 production PDOStatement::execute:580 SQLSTATE: Numeric value out of range: 1264 Out of range value for column 'legacy_id' at row 1

PDOStatement::execute:580 SQLSTATE: Numeric value out of range: 1264 Out of range value for column 'legacy_id' at row 1
App\Models\BaseAlbumImpl::performInsert:105 SQLSTATE: Numeric value out of range: 1264 Out of range value for column 'legacy_id' at row 1; caused by
Illuminate\Database\Connection::runQueryCallback:822 SQLSTATE: Numeric value out of range: 1264 Out of range value for column 'legacy_id' at row 1 (Connection: mysql, SQL: insert into `base_albums` (`id`, `legacy_id`, `created_at`, `updated_at`, `title`, `description`, `owner_id`, `sorting_col`, `sorting_order`, `is_nsfw`) values (UhGPs9p4yip_V43FXgjEWMrK, 17075106376734, 2024-02-09 20:30:37.673066, 2024-02-09 20:30:37.673066, Paragliding, ?, 1, ?, ?, 0)); caused by
App\Models\BaseAlbumImpl::performInsert:105 SQLSTATE: Numeric value out of range: 1264 Out of range value for column 'legacy_id' at row 1 (Connection: mysql, SQL: insert into `base_albums` (`id`, `legacy_id`, `created_at`, `updated_at`, `title`, `description`, `owner_id`, `sorting_col`, `sorting_order`, `is_nsfw`) values (UhGPs9p4yip_V43FXgjEWMrK, 17075106376734, 2024-02-09 20:30:37.673066, 2024-02-09 20:30:37.673066, Paragliding, ?, 1, ?, ?, 0)); caused by
App\Exceptions\ModelDBException::create:50 Updating base album impl failed; caused by
App\Exceptions\ModelDBException::create:50 Updating album failed; caused by
Context:
[
  [
    22003
  ],
  [
    22003
  ],
  [
    22003
  ],
  [
    22003
  ]
]

Steps to reproduce the issue

1. Go to the main album where I want the sub-album to be created
2. Click on the Plus icon on top right -> Click on New Album
3. Fill in the Name and hit Create Album
4. Shows Error

Diagnostics [REQUIRED]

Diagnostics
-----------
Warning: /hom********************************blic/uploads/ has permissions 0755, but should have 2775
Warning: /hom********************************blic/uploads/import has permissions 0755, but should have 2775
Warning: /hom********************************blic/uploads/small has permissions 0775, but should have 2775
Warning: /hom********************************blic/uploads/small/b2 has permissions 0775, but should have 2775
Warning: /hom********************************blic/uploads/small/b2/1a has permissions 0775, but should have 2775
Warning: 6971 more directories with wrong permissions
Warning: Dropbox import not working. dropbox_key is empty.
Warning: You may experience problems when uploading a photo of large size. Take a look in the FAQ for details.
Warning: You may experience problems when uploading a photo of large size. Take a look in the FAQ for details.
Warning: Pictures that are rotated lose their metadata! Please install Imagick to avoid that.
Info: Latest version of PHP is 8.3

System Information
------------------
Lychee Version (release):                5.1.2
DB Version:                              5.1.2

composer install:                        --no-dev
APP_ENV:                                 production
APP_DEBUG:                               false
APP_URL:                                 set
APP_DIR:                                 set
LOG_VIEWER_ENABLED:                      true
LIVEWIRE_ENABLED:                        true

System:                                  Linux
PHP Version:                             8.2.15
PHP User agent:                          Lychee/4 (https://lycheeorg.github.io/)
Timezone:                                America/New_York
Max uploaded file size:                  2M
Max post size:                           8M
Livewire chunk size:                     2.00 MB
Max execution time:                      0
MySQL Version:                           8.0.35-cll-lve

exec() Available:                        yes
Imagick Available:                       -
Imagick Enabled:                         1
Imagick Version:                         -
GD Version:                              2.3.3
Number of foreign key:                   12 found.

Config Information
------------------
version:                                 050102
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:                         reserved
compression_quality:                     90
grants_full_photo_access:                1
delete_imported:                         0
mod_frame_enabled:                       1
mod_frame_refresh:                       10
thumb_2x:                                1
small_2x:                                1
medium_2x:                               1
landing_page_enable:                     0
site_owner:                              John Smith
landing_title:                           John Smith
landing_subtitle:                        Cats, Dogs & Humans Photography
sm_facebook_url:
sm_flickr_url:
sm_twitter_url:
sm_instagram_url:
sm_youtube_url:
landing_background:                      dist/cat.webp
site_title:                              Lychee v5
footer_show_copyright:                   1
site_copyright_begin:                    2019
site_copyright_end:                      2019
footer_additional_text:
footer_show_social_media:                0
search_public:                           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:                       1
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
SA_enabled:                              1
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
ffmpeg_path:
ffprobe_path:
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
back_button_url:                         /

Browser & System [REQUIRED]

Browser: Safari 17.2.1 & Firefox 122.0.1 (64-Bit)
OS: macOS Sonoma v14.2.1
SystemL: MacBook Pro 14inch 2023

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]

Hi, this is a classic error.

Our FAQ describes the solution: https://lycheeorg.github.io/docs/faq_troubleshooting.html#i-get-an-error-sqlstate-numeric-value-out-of-range-1264-out-of-range-value-for-column-legacy_id-what-should-i-do

Go into your Settings then More, find force_32bit_ids in the "config" section and set it to 1.

That should fix it for you. :)

[navjinder]

Thanks...yes it works!