Skip to main content
Known Participant
October 22, 2017
Answered

SQLite Database Corrupt

  • October 22, 2017
  • 11 replies
  • 22365 views

It's in the known issues list, with "contact support" as the only suggestion. Despite what I'm paying for a subscription, the only two support options available ON THE WEEKEND OF LAUNCH are apparently Twitter and these Forums.

Does anyone have a suggestion? I literally just spent from day of launch until now uploading files to the cloud, and can presently access NONE of them on my desktop. Spinning wheels for like an hour now.

This topic has been closed for replies.
Correct answer Mohit Goyal

Thanks for the brief information. I have forwarded this information to the concerned team.

Once I will hear from them, I will contact you.

Regards,

Mohit


I have got some steps for you to follow.

  1. Quit Lightroom CC
  2. Navigate to the catalog folder
    1. In Mac Finder, go to Pictures.  Right click on Lightroom library.lrlibrary and choose “Show Package Contents”
    2. In Windows Explorer, go to c:\users\<username>\AppData\Local\Adobe\Lightroom CC\Data
  3. You’ll see a folder with a long string of characters for the name.  Open that.
  4. Select any file that starts with “Managed Catalog” and delete or move the files to the desktop location in one single folder. Note: if you see an error trying to remove any of these files, reboot the computer then try the delete again.  If any of these files are left behind, corruption is almost certain to reoccur. 
  5. Start Lightroom CC. It will sync down your images from the cloud. 

Let us know if the above steps help you fix this issue.

Regards,

Mohit

11 replies

Mohit Goyal
Community Manager
Community Manager
October 23, 2017

Hi miked,

I really apologise for all the trouble caused you. You will receive this error when you migrate your Lightroom CC 2015 catalog directly to Lightroom CC.

You need to first migrate your Lightroom CC 2015 catalog to Lightroom Classic CC and then from Lightroom Classic CC to Lightroom CC.

If your creative cloud plan does not allow you to install the Classic version, I would suggest you to download the trial of Lightroom Classic CC and migrate the older catalog into it and then use the Lightroom classic CC catalog to migrate in Lightroom CC

Let us know if that helps.

Regards,

Mohit

Known Participant
October 23, 2017

The catalog initially migrated from the older version without difficulty. (And if there was an message telling me I needed to update the library first, I did that.) It then spent four days uploading originals to the cloud before giving me that error message.

I have subsequently updated Classic and upgraded the library. But I can't do anything in CC right now - all I get other than that error message is a stuck spinning wheel - I even let it run all night, no go. I can't even start a migration.

Very unhappily yours,

Mike

Mohit Goyal
Community Manager
Community Manager
October 24, 2017

Hi miked,

Lightroom CC uses the SQLite for its databases. We would like to know few more things to find the root cause of this issue.

-What platform are you using(Win/Mac)

-When exactly you see this error

-Please provide the screenshot of this error

-How much disk space you have left(local disk)

-In Lightroom CC, go to Preferences > Account and hold down the Alt key (Win) or Opt key (Mac)

  1. You should see a button appear that says “Full Report”. Click that button to generate a zipped file in the Creative Cloud Files folder on your computer.
  2. From that folder, right click on LrDiagnostics.zip and choose Creative Cloud > Share Link…

        If you don’t see this option, make sure the Adobe Creative Cloud app is running.

   3.This will open a “Send Link” web page. Click the slider to make it Public.

   4.Copy the blue URL and share it with us.

Regards,

Mohit