Lightroom Mobile Sync Error + Stuck
I have an issue with Lightroom Classic CC. Lightroom seems to be stuck syncing with Lightroom Mobile.
The status in Preferences is stuck at "0 Uploading, 1 Downloading, 1,284 Pending". I've paused and resumed, and I've quit and relaunched. Neither changes that state.
If I open the URL to asset that is "Downloading" in my web browser, I see an error page indicating "Sync has not finished for file 'IMG_2062.MOV'. Open Lightroom on <phone> to continue syncing. Added <Date>". I no longer have that phone, and the 1284 pending downloads seem to be the entire camera roll of my new phone that replaced it (ugg, why can't Adobe detect that I restored my new phone from a backup of my old one and handle that? Guess I've got some duplicates to remove once sync gets unblocked...)
The "Error" asset has an error detail of "WFSQLiteStatement:bind() - illegal data type used as value". When I open that asset's URL in my browser, I get a valid image.
These issues have not resolved on their own in the past ~48 hours.
All the others are stuck "Pending". All the Pending items were added to Lightroom Mobile last night when I synced my new phone.
How can I resolve these issues?
---
Edit: I quit and removed the sync cache (/Users/<user>/Library/Caches/Adobe/Lightroom/Sync Data/Sync.lrdata) as suggested by another post. This resulted in a fresh sync. After it quiesced, I now have three Sync Type: "Uploading" stuck with "Error" (and no further details) and one Sync Type: "Error" with the same "WFSQLiteStatement:bind() - illegal data type used as value" error as mentioned earlier (although the asset is a different asset).
The pending downloads did complete, so that's a start... and now I have a ton of duplicates to remove because Lightroom can't handle device upgrades well... sigh...
