Rebuilding the searchable tag index?

[hardaker]

I have images that I had tagged in the past with various keywords. Lets say "sort". But when I remove the tag from the image, in some cases (I haven't figured out the exact trigger) the images still show up in the metadata browser for the "sort" (or similar) keywords. I was hoping that by retagging them and then removing the tag again that the index would be changed, but no... It appears there is no easy way to fix the corrupted database. Let alone keep it from happening again, as it happens fairly frequently.

So...
1) anyone else have this problem (me: linux and it happened with the latest production release, though I've switched to the beta now and still can't get it to rebuild but haven't been running it long enough yet to determine if the underlying bug is reproducible under it).
2) anyone know how to rebuild the search index to reflect the real corruption that already exists?

[afx]

Ensure all images have XMPs.
Nuke the DB
Create a new one.

cheers
afx

[kaymann]

It happens in Win 7 as well and the fix afx proposes is the only one I have found that works...

[binoyte]

Old bug from Bibble times. No choice to do as afx said.

[ogrizzo]

Old bug from Bibble times. No choice to do as afx said.

Problem with reimporting the whole catalogue — apart from speed — is that often the erroneous keywords are saved in the xmp file!
What I do is modify the sidecar file with sed (the '-i ~' option comes quite handy), nuke the pictures from the catalogue and then reimport them.

I suggest you experiment your regular expression on a copy of the xmp file until you're confident you can do it right.

Of course, you'd better back everything up before proceeding in such a way!

[binoyte]

Usually, the xmp files are ok and the database only is bugged.

Except if you use single quote (apostrophe) ' in your keywords.

Apostrophes cause main bugs in the keywords handling, and then errors are also reproduced in the xmp.

[abrianb]

@binoyte ; 'good info/Thank You'

[hardaker]

Thanks for all the suggestions (vacation for a week took me offline)... I was going to try the "delete just those files after ensuring a fresh xmp export" and see if that worked. I'd really rather not reimport the entire DB as that was way too slow last time (near 24 hours if I recall) when I manually messed with all the xmp files to pull in tags from another program.

[ogrizzo]

I was going to try the "delete just those files after ensuring a fresh xmp export" and see if that worked. I'd really rather not reimport the entire DB as that was way too slow last time (near 24 hours if I recall) when I manually messed with all the xmp files to pull in tags from another program.

That definitively works for me!

Ottavio