I had to change many items’ metadata directly in the MySQL database. It was a simple search and replace of a string. The changed values are now correct in the database, but weirdly enough, are not shown when looking at the item on the site or in the admin interface.
I tried to find some cache mechanism or a way to clear a cache, but didn’t find anything helpful. Any tipps on how to get Omeka show the updated property values?
The table metadata_reference is the index to get complex queries about references quicker and can be updated directly after a sql manipulation in admin > settings > reference.