Can't repair database

Hi folks,
I’ve found similar (but usually unresolved) issues elsewhere so forgive the overlap with other threads. I have a database that is years old and has come through all the versions of DV and DV to go since 2016. I’m currently running 3.6.3 on the Mac.
I’m trying to move to iCloudKit and doing one at a time. This one reports ‘Failed database verification, please repair the database.’
Repair does not solve it, I get ‘1 inconsistency’. The log does not tell me where it is as it does with other errors so I have no idea where it is in the database. I tried rebuilding it, but it didn’t solve the problem.
It last synced successfully in Feb (I use it erratically). Annoyingly, because I rebuilt it, I can’t now look for whatever I added since then as everything reports it was added just now;)

If I did add something, it will be important so I’m loathe to chuck this away and redownload from the cloud (legacy).
This database syncs with my iPhone and iPad too on whatever the latest version is (auto-update, and I went to DTG 3 fairly soon after it was released).
Any suggestions? All help gratefully received…
cheers,
Jason

This has been reported several times on the forums, but here’s the basic steps…

  1. Clear Window > Log.
  2. Do a File > Verify & Repair on the database.
  3. Press Repair when prompted.
  4. Press Ok in the next dialog.
  5. Check Window > Log for zero-byte files.
  6. Control-click a result and choose Reveal if you’d like to see where the file resides in the database. Then use the Move to Trash option.
  7. Empty the database’s Trash to remove the zero-byte files.
  8. Repeat the steps with other databases as needed.

Thanks. What I was missing was having the log open already as it wasn’t showing until I did that.

No problem.

Digging up an older thread on this. After an OS crash a few days ago I had 11 files that were showing missing. Going through re-indexing brought it down to 10 files. The remaining 10 missing files all have the same behavior as far as I can tell. They show that the file is missing, but the preview works fine, the file shows as being it’s original size, it opens in both DEVONThink and external apps, and the path to the source file shows the file in place and opens from that location as well.

What am I missing?

Welcome @GaiusRufus

it opens in both DEVONThink and external apps, and the path to the source file shows the file in place and opens from that location as well.

This would be inconsistent with the file being missing.
Hold the Option key and choose Help > Report bug to start a support ticket.