search

LycheeOrg / Lychee

A great looking and easy-to-use photo-management-system you can run on your server, to manage and share photos.
https://lycheeorg.github.io/
MIT License
3.37k stars 298 forks source link

500 error while opening an album and creating a new album #2184

Closed frankcwl closed 9 months ago

frankcwl commented 9 months ago

Detailed description of the problem [REQUIRED]

I installed lychee 5.0.2 from release and noticed it couldn't work well on a sub folder. So I downloaded the newest .zip file in #2150 and replaced the previous files. Though livewire works well but there is another question. When I try to open an album or create a new album, I always meet 500 HttpException.

When opening an album

500 HttpException
Undefined array key "album_sorting_col" (View: C:\Lychee\resources\views\livewire\pages\gallery\album.blade.php)

and the corresponding log shows

Illuminate\Foundation\Bootstrap\HandleExceptions::Illuminate\Foundation\Bootstrap\{closure}:403 Undefined array key "album_sorting_col"
Livewire\Mechanisms\ExtendBlade\ExtendedCompilerEngine::handleViewException:403 Undefined array key "album_sorting_col" (View: C:\Lychee\resources\views\livewire\pages\gallery\album.blade.php); caused by

When creating a new album

500 ModelDBException
Updating album failed

and the corresponding log shows

PDO::prepare:574 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'album_sorting_col' in 'field list'
App\Models\Extensions\BaseAlbum::performInsert:101 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'album_sorting_col' in 'field list'; caused by
Illuminate\Database\Connection::runQueryCallback:822 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'album_sorting_col' in 'field list' (Connection: mysql, SQL: insert into `albums` (`id`, `parent_id`, `license`, `cover_id`, `_lft`, `_rgt`, `album_sorting_col`, `album_sorting_order`) values (SsxpcdR5ngMOQ7QSu6xsFVE3, ?, none, ?, 3, 4, ?, ?)); caused by
App\Models\Extensions\BaseAlbum::performInsert:101 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'album_sorting_col' in 'field list' (Connection: mysql, SQL: insert into `albums` (`id`, `parent_id`, `license`, `cover_id`, `_lft`, `_rgt`, `album_sorting_col`, `album_sorting_order`) values (SsxpcdR5ngMOQ7QSu6xsFVE3, ?, none, ?, 3, 4, ?, ?)); caused by
App\Exceptions\ModelDBException::create:50 Updating album failed; caused by

Steps to reproduce the issue

Steps to reproduce the behavior:

  1. Click any album cover (more specifically any album in Albums not in Smart Albums)
  2. See 500 page

or

  1. Click the plus icon and select New Album
  2. Enter an title and click Create Album
  3. See 500 page

Output of the diagnostics [REQUIRED]

Diagnostics
-----------
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: Pictures that are rotated lose their metadata! Please install Imagick t
o avoid that.
Info: Latest version of PHP is 8.3

System Information
------------------
Lychee Version (release):                5.0.2
DB Version:                              5.0.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:                                  WINNT
PHP Version:                             8.2.10
PHP User agent:                          Lychee/4 (https://lycheeorg.github.io/)

Timezone:                                Asia/Shanghai
Max uploaded file size:                  100M
Max post size:                           8M
Livewire chunk size:                     8.00 MB
Max execution time:                      0
MySQL Version:                           11.1.2-MariaDB

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

Config Information
------------------
version:                                 050002
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:                                    zh_CN
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
site_owner:                              frankcwl
landing_title:                           John Smith
landing_subtitle:                        Cats, Dogs & Humans Photography
sm_facebook_url:                         https://www.facebook.com/JohnSmith
sm_flickr_url:                           https://www.flickr.com/JohnSmith
sm_twitter_url:                          https://www.twitter.com/JohnSmith
sm_instagram_url:                        https://instagram.com/JohnSmith
sm_youtube_url:                          https://www.youtube.com/JohnSmith
landing_background:                      dist/cat.webp
site_title:                              frankcwl album
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:                       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
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

Browser and system

Chrome and Windows Server 2012

ildyria commented 9 months ago

php artisan migrate is your solution I guess O.o

frankcwl commented 9 months ago

Thanks, it works.