exec in Configs.php is causing error 500 when disabled

[danieldotnet]

I have migrated from version 3 to version 4 and the migration worked well, but I cannot publish any photos. The photos can be found in the directory, but not in the album, and an error message appears after upload.

[ildyria]

Thank you for opening an issue. As you could see, there is a template. It is here to help us get information to debug what is going wrong in your installations. Please answer the questions in it, especially the DIAGNOSTIC PART.

@ildyria takes note to also add info to request the Network information and add entry in the wiki

[danieldotnet]

Hello,
Thank you for the fast answer. Below I attached more details.
diagnostics.txt
PHP-Version: 7.3.16
The photos I uploaded normal in Web GUI.

    Diagnostics
    -------
    Info: Latest version of PHP is 7.4
    Error: Database is behind file versions. Please apply the migration.
    Warning: Dropbox import not working. dropbox_key is empty.
    Warning: You may experience problems when uploading a large amount of photos. Take a look in the FAQ for details.




    System Information
    --------------
    Lychee-front Version:       4.0.1 (c41683e)
    Lychee Version (release):   4.0.2

    DB Version:                 4.0.2
    System:                     Linux
    PHP Version:                7.3
    MySQL Version:              10.1.44-MariaDB-0+deb9u1
    
    Imagick:                    1
    Imagick Active:             1
    Imagick Version:            1687
    GD Version:                 bundled (2.1.0 compatible)
	
	Config Information
    --------------
    version:                    040002
    check_for_updates:          0
    sorting_Photos_col:         takestamp
    sorting_Photos_order:       ASC
    sorting_Albums_col:         max_takestamp
    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:                       de
    layout:                     1
    image_overlay:              1
    image_overlay_type:         desc
    default_license:            CC-BY-NC-ND
    compression_quality:        90
    full_photo:                 1
    delete_imported:            0
    Mod_Frame:                  1
    Mod_Frame_refresh:          30
    thumb_2x:                   1
    small_2x:                   1
    medium_2x:                  1
    landing_page_enable:        1
    landing_owner:              John Smith
    landing_title:              John Smith
    landing_subtitle:           Cats, Dogs & Humans Photography
    landing_facebook:           https://www.facebook.com/JohnSmith
    landing_flickr:             https://www.flickr.com/JohnSmith
    landing_twitter:            https://www.twitter.com/JohnSmith
    landing_instagram:          https://instagram.com/JohnSmith
    landing_youtube:            https://www.youtube.com/JohnSmith
    landing_background:         dist/cat.jpg
    site_title:                 Lychee v4
    site_copyright_enable:      1
    site_copyright_begin:       2019
    site_copyright_end:         2019
    additional_footer_text:     
    display_social_in_gallery:  0
    public_search:              0
    SL_enable:                  0
    SL_for_admin:               0
    public_recent:              0
    recent_age:                 1
    public_starred:             0
    downloadable:               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:               2
    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

[ildyria]

Nothing wrong in your diagnostics.
Is there anything in your Logs ? Error / Warning / Notice ?

In your browser, press F12 to open the Console, go to the Network tab. Upload a picture, you should see the Request to your server, click on it and open the response part. There should be an error maessage here.

If you just have an error 500 or no real details, edit the .env file and set APP_DEBUG to true,

[danieldotnet]

I use the newest Firefox Browser and get Error 500 (see Screenshot)

APP_DEBUG is set to true.

[ildyria]

Request to your server, click on it and open the response part.

I am interested in what is being shown in the "Antwort" tab. That is where we will see the error message. :)

[danieldotnet]

OK below the screenshot. Thank you for your help.

[ildyria]

Thank you for bringing that one up. This is REALLY helpfull. 👍

We will fix it as soon as possible. Most likely in release 4.0.3.
In the mean time:

1. go to Settings
2. go to More at the bottom of the page
3. Edit the value of has_exiftool to 0

This should fix your problem (simple way). The other way is to allow php to use the exec function.

[danieldotnet]

Now it works well if I set has_exiftool = 0. Thank you!
What does the sentence "Error: Database is behind file versions. Please apply the migration." in my diagnostics file mean? Is there nothing else to do?

[ildyria]

What does the sentence "Error: Database is behind file versions. Please apply the migration." in my diagnostics file mean? Is there nothing else to do?

That was actually surprising. It is supposed to mean that your files version are in front of the database version.

However in your case, we can clearly see they are at the same level which indicated me there is a bug in that place in the software. However this one should already be fixed with #499

[danieldotnet]

OK, thanks for explaining. At this point compliment for this great photo software, looks very good, simple and modern!

[ildyria]

I'm keeping this open until the pull request is merged. :)