-
-
Notifications
You must be signed in to change notification settings - Fork 300
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
After v3 to v4 migration: Albums are there, but photos are missing #703
Comments
Do the albums actually show as empty or do they contain "empty" photos (frame only)? If the latter, did you move the files with the photos from the old uploads directory to the new one, as outlined in the migration instructions? |
The albums show as empty (except for the one album containing only one photo). |
Yeah, that's weird... And that happens even when you are logged in as admin? Do you have a console access to your mysql database? If so, could you run the following two queries and send us their output if it's not too long?
|
The second SQL query probably gives me the one photo I see? |
Yes. So the other photos are indeed completely missing from the v4 photos table. I wonder if the database migration failed in some way? Just to confirm, the following query on the v3 photos table generates the expected output?
What does |
The output of the query on lychee_photo looks ok to me reagrding the kind and number of photos, but otherwise cannot say:
Here the output of
I haven't done any changes to v4 yet, so running |
Yes, the v3 photos table looks good. Your database migrations definitely weren't all done in one batch (see the last column above). I'm not sure why that would be. Under the circumstance, I definitely recommend |
Hmm, running
And accessing the site now gives me a 500 error. |
Ah, I see. Great that there is a fix already. :) |
See https://lycheeorg.github.io/docs/installation.html#installing-lychee and https://lycheeorg.github.io/docs/update.html#update-using-git. Your command is correct and running it somewhere in |
Can you confirm that the current git version fixes it for you and if so, close this issue? Thanks! |
I haven't come to testing that yet unfortunately. I will do so on the weekend and report back here. |
You may also be able to simply replace the |
That simple replacement did the trick, thanks a lot! :D Issue can be closed. |
Detailed description of the problem
After migration from v3 to v4 I see all of my five albums, but four of them are empty and one of them contains only one photo. I followed the migration instructions here.
Steps to reproduce the issue
n.a.
Screenshots
n.a.
Output of the diagnostics
Browser and system
Client: Firefox 78.2.0esr on Fedora 32 Workstation
Server: Debian Buster on armv7l
The text was updated successfully, but these errors were encountered: