My Lightroom (Windows 10) is stuck syncing 1 photo. There are no photos in the "syncing" filter for me to delete. When running the Mini Report, I found the following sync error:
I assume this means the IMG_1101-HDR.dng file is the problem. However, when I search for that file, it does not exist. I cannot find it through the Lightroom interface, nor can I find it going to the local AppData folder where Lightroom stores the photos.
As a side note, I attempted to added a new file named "IMG_1101-HDR.dng". Lightroom reports failure due to file already existing in Lightroom (which at least visually, the file does not exist--the filename must just be in the database).
Is there a console mode to force Lightroom to drop the reference to this file from the database? Any help is appreciated! -Mike
Is there a possibility that that file is in the deleted folder in Lightroom? I had an image in that folder once that kept giving me the message that Lightroom was trying to sync. Might not be the same situation for you.
Thanks for the suggestion. No, there are no files in the deleted folder. I cleaned them all out to make sure.
Actually the file was probably there at some point before I permanently deleted it. Maybe the sync didn't happen before it was deleted last month. Either way, Lightroom *thinks* there is a file there that no longer exists. You can see the references to the old file in the .mcat SQLight database--it just doesn't exist on the file system anymore.
TL;DR: Remove local database and reinstall Lightroom.
So I could not find any way to modify the Lightroom database to remove the invalid reference to the file that was stuck. What I did to resolve the issue was the following:
Since the bad reference was on my local machine and not in the cloud, deleting the entire database and allowing Lightroom to rebuild it from the Cloud was the only way I could figure out how to do it. Yes, overkill.
I would like to see Adobe provide a way to manually edit the local Lightroom database.
OMG, I had to reply to this post just to thank you! I have spent ALL day browsing the internet, checking Classic, Lightroom online, mobile and desktop trying to work out how to fix this. I had two images stuck on syncing after I deleted some to save space... none in the deleted folder and none in the sync status filter... tried so many things and your solution is the first thing that's worked! Thank you!!
Glad it helped. I had the same problem--I searched everywhere and the recommendations just kept saying "find the problem photo in the sync folder or in the cloud". Nothing mentioned anything about how to fix it if the problem wasn't in the cloud yet. Good to hear I wasn't the only one having this issue 🙂