Issue with my database/metadata?

[Al_M]

Hi, I recently discovered a glitch in the database which I am hoping is an easy fix.
My catalog has almost 48K images. But when using the details pane to search such details as Camera Make or Camera Model, PSu is missing some or under-reporting counts.

See the below screenshot:

Screenshot 2023-04-18 at 3.10.21 PM.png (583.44 KiB) Viewed 1281 times

Only 3609 are accounted for in the Camera Make and the same number under the Camera Model.
Under Camera Make, I know for a fact there should also be listed a Sony, Olympus at least.
Under Camera Model, I am missing for sure an Canon G1 (my first digital), a Rebel XS, and several iPhones (3G, 4, 5s, 12 Pro Max, 14 Plus) missing.
Additionally, the Canon 30D and the 7D Mkii were my mainstays for many years. At least 20,000 images between those two models are missing.
I can navigate to another tab, for example the Timeline and the counts look more believable.
For example in 2017 alone it shows 6544 images, most of which were shot with the Canon 7D Mkii.

Screenshot 2023-04-18 at 3.24.43 PM.png (210.06 KiB) Viewed 1281 times

Furthermore, the Info and Details pane are missing metadata:

Screenshot 2023-04-18 at 3.32.50 PM.png (56.11 KiB) Viewed 1281 times

I suspect this occurred during an upgrade, but honestly can't pinpoint which it was.
Currently running 2023.1.1.48

Last year when upgrading from 6 to 7 Here had me run this script to clean up/repair search data:

Code: Select all

PublicCatalog.BuildSearchData;
Say('done');                

I have tried doing this again, several times, but still things are not right.

Does anyone have any suggestions?

[Hert]

This didn't happen with some update. This is most likely the result of using a tool that creates half-baked XMP metadata. The first tool that creates the XMP is expected to also convert existing metadata to XMP. Since PSU is fully XMP driven, you will instantly notice tools that fail to do so.
Don't worry...PSU can fix this for you by converting the metadata (exif/iptc) to XMP.

Do this:
1. Select one or more thumbs
2. Right click on a select thumb
3. Select Metadata -> Convert Metadata to XMP