Column not found: 1054 Unknown column 'photos.title_strict' in 'ORDER BY'

[at0m1sk]

Lychee version

v7.1.1

Did you check the latest Lychee version?

Yes, I did

Which PHP version are you using?

PHP 8.4

Detailed description of the problem

Using the latest version, I noticed that some of my albums were not sorting properly based on the name of the photo(how I usually sort), I configured both sorting_albums_col/sorting_photos_col to be title_strict, via the Settings menu this appears as "Title(Lexicon)". I went around and did something similar to all of my photo albums and made them sort by "Title(Lexicon)". Upon logging back in as "admin" I was presented with the bellow error.

	Error	2026-01-13 16:46:21	production	PDO::prepare:413 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'photos.title_strict' in 'ORDER BY'	

PDO::prepare:413 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'photos.title_strict' in 'ORDER BY'
App\Models\Extensions\Thumb::createFromQueryable:81 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'photos.title_strict' in 'ORDER BY'; caused by
Illuminate\Database\Connection::runQueryCallback:831 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'photos.title_strict' in 'ORDER BY' (Connection: mysql, Host: mariadb, Port: 3306, Database: lychee, SQL: select `photos`.`id`, `photos`.`type` from `photos` left join `photo_album` on `photos`.`id` = `photo_album`.`photo_id` left join `albums` on `albums`.`id` = `photo_album`.`album_id` left join (select `base_album_id`, `is_link_required`, `password` from `access_permissions` as `computed_access_permissions` where `user_id` = 2 or (0 = 1 and `computed_access_permissions`.`base_album_id` not in (select `acc_per`.`base_album_id` from `access_permissions` as `acc_per` where `acc_per`.`user_id` = 2)) or (`user_id` is null and `user_group_id` is null and `computed_access_permissions`.`base_album_id` not in (select `acc_per_group`.`base_album_id` from `access_permissions` as `acc_per_group` where `acc_per_group`.`user_id` = 2 or 0 = 1)) group by `base_album_id`, `is_link_required`, `password`) as `computed_access_permissions` on `computed_access_permissions`.`base_album_id` = `photo_album`.`album_id` where (not exists (select * from `albums` as `outers` left join (select `outers_base_albums`.`id`, `outers_base_albums`.`is_nsfw` from `base_albums` as `outers_base_albums`) as `outers_base_albums` on `outers_base_albums`.`id` = `outers`.`id` where `outers`.`_lft` <= `albums`.`_lft` and `outers`.`_rgt` >= `albums`.`_rgt` and `outers_base_albums`.`is_nsfw` = 1) or (`photo_album`.`album_id` is null and `photos`.`owner_id` = 2)) and (not exists (select * from `albums` as `inner` left join (select `inner_base_albums`.`id`, `inner_base_albums`.`owner_id` from `base_albums` as `inner_base_albums`) as `inner_base_albums` on `inner_base_albums`.`id` = `inner`.`id` left join (select `base_album_id`, `is_link_required`, `password` from `access_permissions` as `computed_access_permissions` where `user_id` = 2 or (0 = 1 and `computed_access_permissions`.`base_album_id` not in (select `acc_per`.`base_album_id` from `access_permissions` as `acc_per` where `acc_per`.`user_id` = 2)) or (`user_id` is null and `user_group_id` is null and `computed_access_permissions`.`base_album_id` not in (select `acc_per_group`.`base_album_id` from `access_permissions` as `acc_per_group` where `acc_per_group`.`user_id` = 2 or 0 = 1)) group by `base_album_id`, `is_link_required`, `password`) as `inner_computed_access_permissions` on `inner_computed_access_permissions`.`base_album_id` = `inner`.`id` where `inner`.`_lft` <= `albums`.`_lft` and `inner`.`_rgt` >= `albums`.`_rgt` and (`inner_computed_access_permissions`.`is_link_required` = 1 or `inner_computed_access_permissions`.`is_link_required` is null or `inner_computed_access_permissions`.`password` is not null) and (`inner_computed_access_permissions`.`is_link_required` = 1 or `inner_computed_access_permissions`.`is_link_required` is null or 1 = 1) and `inner_base_albums`.`owner_id` <> 2) or `photos`.`owner_id` = 2) and (`photo_album`.`album_id` is null) order by `photos`.`is_starred` desc, `photos`.`title_strict` asc limit 1); caused by
App\Models\Extensions\Thumb::createFromQueryable:81 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'photos.title_strict' in 'ORDER BY' (Connection: mysql, Host: mariadb, Port: 3306, Database: lychee, SQL: select `photos`.`id`, `photos`.`type` from `photos` left join `photo_album` on `photos`.`id` = `photo_album`.`photo_id` left join `albums` on `albums`.`id` = `photo_album`.`album_id` left join (select `base_album_id`, `is_link_required`, `password` from `access_permissions` as `computed_access_permissions` where `user_id` = 2 or (0 = 1 and `computed_access_permissions`.`base_album_id` not in (select `acc_per`.`base_album_id` from `access_permissions` as `acc_per` where `acc_per`.`user_id` = 2)) or (`user_id` is null and `user_group_id` is null and `computed_access_permissions`.`base_album_id` not in (select `acc_per_group`.`base_album_id` from `access_permissions` as `acc_per_group` where `acc_per_group`.`user_id` = 2 or 0 = 1)) group by `base_album_id`, `is_link_required`, `password`) as `computed_access_permissions` on `computed_access_permissions`.`base_album_id` = `photo_album`.`album_id` where (not exists (select * from `albums` as `outers` left join (select `outers_base_albums`.`id`, `outers_base_albums`.`is_nsfw` from `base_albums` as `outers_base_albums`) as `outers_base_albums` on `outers_base_albums`.`id` = `outers`.`id` where `outers`.`_lft` <= `albums`.`_lft` and `outers`.`_rgt` >= `albums`.`_rgt` and `outers_base_albums`.`is_nsfw` = 1) or (`photo_album`.`album_id` is null and `photos`.`owner_id` = 2)) and (not exists (select * from `albums` as `inner` left join (select `inner_base_albums`.`id`, `inner_base_albums`.`owner_id` from `base_albums` as `inner_base_albums`) as `inner_base_albums` on `inner_base_albums`.`id` = `inner`.`id` left join (select `base_album_id`, `is_link_required`, `password` from `access_permissions` as `computed_access_permissions` where `user_id` = 2 or (0 = 1 and `computed_access_permissions`.`base_album_id` not in (select `acc_per`.`base_album_id` from `access_permissions` as `acc_per` where `acc_per`.`user_id` = 2)) or (`user_id` is null and `user_group_id` is null and `computed_access_permissions`.`base_album_id` not in (select `acc_per_group`.`base_album_id` from `access_permissions` as `acc_per_group` where `acc_per_group`.`user_id` = 2 or 0 = 1)) group by `base_album_id`, `is_link_required`, `password`) as `inner_computed_access_permissions` on `inner_computed_access_permissions`.`base_album_id` = `inner`.`id` where `inner`.`_lft` <= `albums`.`_lft` and `inner`.`_rgt` >= `albums`.`_rgt` and (`inner_computed_access_permissions`.`is_link_required` = 1 or `inner_computed_access_permissions`.`is_link_required` is null or `inner_computed_access_permissions`.`password` is not null) and (`inner_computed_access_permissions`.`is_link_required` = 1 or `inner_computed_access_permissions`.`is_link_required` is null or 1 = 1) and `inner_base_albums`.`owner_id` <> 2) or `photos`.`owner_id` = 2) and (`photo_album`.`album_id` is null) order by `photos`.`is_starred` desc, `photos`.`title_strict` asc limit 1); caused by

Error came from: https://github.com/LycheeOrg/Lychee/blob/master/app/Models/Extensions/Thumb.php#L81

Steps to reproduce the issue

1. As admin, go to Settings
2. Set "Default column used for sorting photos"/"Default column used for sorting albums" to "Title(Lexicon)"
3. Log out
4. Log back in, upon hitting /gallery blank page appears w/ a 500 error code

Diagnostics [REQUIRED]

Self-diagnosis
info
Hash: a5fcc43da134e0ad—ca603f56c7ec26e5
2534 files and 14517 vendor files
info
Full directory permission check is disabled
warning
zend.assertions is disabled although Lychee is in debug mode. For easier debugging code generation for assertions should be enabled.
info
Latest version of PHP is 8.5
warning
opcache_get_configuration() is not available.
We are unable to check for performance optimizations.
warning
Default timezone not properly set; you might experience strange results when importing photos without explicit EXIF timezone
info
Foreign key: access_permissions.user_id → users.id : CASCADE
info
Foreign key: albums.parent_id → albums.id : RESTRICT
info
Foreign key: albums.id → base_albums.id : RESTRICT
info
Foreign key: albums.auto_cover_id_least_privilege → photos.id : RESTRICT
info
Foreign key: albums.auto_cover_id_max_privilege → photos.id : RESTRICT
info
Foreign key: albums.cover_id → photos.id : CASCADE
info
Foreign key: album_size_statistics.album_id → albums.id : RESTRICT
info
Foreign key: base_albums.owner_id → users.id : RESTRICT
info
Foreign key: jobs_history.owner_id → users.id : RESTRICT
info
Foreign key: oauth_credentials.user_id → users.id : CASCADE
info
Foreign key: orders.user_id → users.id : RESTRICT
info
Foreign key: order_items.album_id → albums.id : RESTRICT
info
Foreign key: order_items.order_id → orders.id : RESTRICT
info
Foreign key: order_items.photo_id → photos.id : RESTRICT
info
Foreign key: order_items.purchasable_id → purchasables.id : RESTRICT
info
Foreign key: order_items.size_variant_id → size_variants.id : RESTRICT
info
Foreign key: photos.owner_id → users.id : RESTRICT
info
Foreign key: photos_tags.photo_id → photos.id : CASCADE
info
Foreign key: photos_tags.tag_id → tags.id : CASCADE
info
Foreign key: photo_album.album_id → albums.id : RESTRICT
info
Foreign key: photo_album.photo_id → photos.id : RESTRICT
info
Foreign key: photo_ratings.photo_id → photos.id : RESTRICT
info
Foreign key: photo_ratings.user_id → users.id : RESTRICT
info
Foreign key: purchasables.album_id → albums.id : RESTRICT
info
Foreign key: purchasables.photo_id → photos.id : RESTRICT
info
Foreign key: purchasable_prices.purchasable_id → purchasables.id : RESTRICT
info
Foreign key: renamer_rules.owner_id → users.id : RESTRICT
info
Foreign key: size_variants.photo_id → photos.id : RESTRICT
info
Foreign key: tag_albums.id → base_albums.id : RESTRICT
info
Foreign key: tag_albums_tags.tag_id → tags.id : CASCADE
info
Foreign key: tag_albums_tags.album_id → tag_albums.id : CASCADE
info
Foreign key: users_user_groups.user_id → users.id : CASCADE
info
Foreign key: users_user_groups.user_group_id → user_groups.id : CASCADE
info
Found 6 medium that could be generated.
You can use `php artisan lychee:generate_thumbs medium 6` to generate them.
info
Found 2747 placeholders that could be generated.
You can use `php artisan lychee:generate_thumbs placeholder 2747` to generate them.
Info

Lychee Version (release):                  7.1.1
DB Version:                                7.1.1
Docker:                                    linuxserver.io
composer install:                          --no-dev
APP_ENV:                                   production
APP_DEBUG:                                 true
APP_URL:                                   set
APP_DIR:                                   default
LOG_VIEWER_ENABLED:                        true
System:                                    Linux
PHP Version:                               8.4.16
PHP User agent:                            Lychee/6 (https://lycheeorg.dev/)
Timezone:                                  UTC
Max uploaded file size:                    200M
Max post size:                             2000M
Chunk size:                                12.80 MB
Max execution time:                        200
MySQL Version:                             11.4.4-MariaDB-log
exec() Available:                          yes
Imagick Available:                         1
Imagick Enabled:                           yes
Imagick Version:                           1810
GD Version:                                bundled (2.1.0 compatible)
Number of foreign key:                     33 found.

		

Space
Configuration

version:                                   070101
check_for_updates:                         0
sorting_photos_col:                        title_strict
sorting_photos_order:                      ASC
sorting_albums_col:                        title_strict
sorting_albums_order:                      ASC
imagick:                                   1
skip_duplicates:                           1
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
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:                             0
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:                              0
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
show_keybinding_help_popup:                0
show_keybinding_help_button:               1
disable_se_call_for_actions:               1
enable_se_preview:                         1
slideshow_timeout:                         5
keep_original_untouched:                   1
low_quality_image_placeholder:             1
timeline_photos_enabled:                   0
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:                             1
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
client_side_favourite_enabled:             0
default_old_settings:                      0
default_expert_settings:                   0
default_all_settings:                      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
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
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
is_scroll_to_navigate_photos_enabled:      1
is_swipe_vertically_to_go_back_enabled:    1
details_links_enabled:                     0
details_links_public:                      0
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:                            
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
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
album_layout:                              grid
albums_per_page:                           30
albums_pagination_ui_mode:                 infinite_scroll
albums_infinite_scroll_threshold:          10
photos_per_page:                           100
photos_pagination_ui_mode:                 infinite_scroll
photos_infinite_scroll_threshold:          10
enable_propagate_unlock_option:            0

		

Browser & System [REQUIRED]

Lychee runs on linuxserver based docker image.

Browser is latest Firefox(tested OS Mac/Windows): Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko/20100101 Firefox/146.0

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.

[at0m1sk]

FYI: To solve the problem, I had to go into the databases and manually update configs table setting both sorting_albums_col/sorting_photos_col keys to value title

[ildyria]

I just noticed it on my instance too, I haven't had the time to fix it yet.

[ildyria]

PR incomming.

[ildyria]

#3975

[at0m1sk]

Thank you @ildyria ! Thank you for all of your time and effort on this project!