Thanks, Keith.
A coding mistake (software bug on our end) has allowed some data in your "cat_state.sq3" database to be stored in a self-contradictory state.
We'll be working on a general fix, but in the meantime it should be possible to correct the problem manually in the following ways:
(Quit Photo Mechanic Plus before trying either of the following)
1. Surgical approach - delete only the offending record within "cat_state.sq3"
- Requires the SQLite command line shell (sqlite3.exe) which can be downloaded here:
https://sqlite.org/2020/sqlite-tools-win32-x86-3310100.zip The following commands, executed in a cmd.exe window, should correct the problem (assuming sqlite3.exe is available.)
cd /D "%LOCALAPPDATA%\Camera Bits, Inc\Photo Mechanic\catalog\state"
sqlite3 cat_state.sq3 "delete from key_value where key = 'shareid_nodes'"
That should fix the issue without impacting the rest of the Catalog system.
2. Brute-force alternative - delete or rename the whole "cat_state.sq3" database file.
cd /D "%LOCALAPPDATA%\Camera Bits, Inc\Photo Mechanic\catalog\state"
ren cat_state.sq3 cat_state_bad.sq3
- Pros: No SQLite tool needed.
- Cons: Photo Mechanic Plus will forget most of what it knows about the state of your catalogs, and you'll need to use the "Reintegrate" function in the "Manage Catalogs" window on each catalog to reacquaint Photo Mechanic with what's been catalogged.
Hope this helps & sorry for the inconvenience,
-Bill
