Mobile Sync stopped working in Windows

[bigtench]

Although LR indicates that it synching with mobile nothing is actually synching. There are several new pictures to download. If I open Preferences->Lightroom Mobile there is an Error under pending activity:

Database "C:\Users\vic\Pictures\Lightroom 4 Catalogue\VGK Photography Catalogue\VGK Photography Catalogue-2-2.lrcat": NOT NULL constraint failed: AgLibraryOzFavoriteIds.ozSpaceId

  Statement: INSERT OR REPLACE INTO AgLibraryOzFavoriteIds

  ( ozCatalogId, ozSpaceId, ozAssetId, ozFavoriteId, timestamp )

  VALUES( ?, ?, ?, ?, ? ) (error code 19)

How do I fix this!

I tried optimising the catalogue - no difference.

[greule · Accepted solution]

Could you try to remove the sync.lrdata file and restart Lr Desktop? This wouldre-sync the metadata from the server-side and fix youthe issue. let me know your result.

You can find the  sync.lrdata file here:

On Mac it's at /Users/<user>/Library/Caches/Adobe/Lightroom/Sync Data/Sync.lrdata

On Win it would be at C:\Users\<user>\AppData\Local\Adobe\Lightroom\Caches\Sync Data\Sync.lrdata

[adrianc94127467]

Great - just worked for me too. Thanks.

[bigtench]

Thanks gruele - that worked a treat.

[greule]

Glad that it helped.