Author Topic: Browse IPTC Keywords pane does not update after assigning keywords  (Read 677 times)

Offline KeithRJ

  • Full Member
  • ***
  • Posts: 135
    • View Profile
Re: Browse IPTC Keywords pane does not update after assigning keywords
« Reply #15 on: May 21, 2020, 06:24:28 PM »
Hi Kirk,

installed the version you sent and did the test again with the same results.  New log file attached.

Cheers
Keith

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 21205
    • View Profile
    • Camera Bits, Inc.
Re: Browse IPTC Keywords pane does not update after assigning keywords
« Reply #16 on: May 21, 2020, 08:47:29 PM »
Keith,

installed the version you sent and did the test again with the same results.  New log file attached.

Thanks.  Now we're getting somewhere.  We'd like to have access to a file on your system.  Open up a Windows Explorer window and paste the following into the path field:

%LOCALAPPDATA%\Camera Bits, Inc\Photo Mechanic\catalog\state

You should then see a file named cat_state.sq3 (and perhaps a few others).  Make it into a zip file and post it here, please.

Thanks,

-Kirk

Offline KeithRJ

  • Full Member
  • ***
  • Posts: 135
    • View Profile
Re: Browse IPTC Keywords pane does not update after assigning keywords
« Reply #17 on: May 22, 2020, 01:15:47 AM »
Hi Kirk,

here is the cat_state.zip you requested.

Regards
Keith

Offline Bill Kelly

  • Software Developer
  • Camera Bits Staff
  • Member
  • *****
  • Posts: 72
    • View Profile
    • Camera Bits, Inc.
Re: Browse IPTC Keywords pane does not update after assigning keywords
« Reply #18 on: May 22, 2020, 10:34:41 AM »
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


Offline KeithRJ

  • Full Member
  • ***
  • Posts: 135
    • View Profile
Re: Browse IPTC Keywords pane does not update after assigning keywords
« Reply #19 on: May 22, 2020, 05:25:23 PM »
Hi Bill,

Thanks for the update and I am glad we managed to get to the bottom of this issue. I will try some of your suggestions but it is not a major issue with my testing so I can live with it until a fix comes out.

Cheers
Keith