We have added a new schema to the MySQL database installed with Connect to store PDI details that are created with the PlanetPress Image plugin.
The purpose of the PlanetPress Search database is to store PDF invoices that are not older than 3 months.
There is a process which inserts details to the Search database at every production run and there is another process which deletes files that are older than 3 months from the archive folders every hour.
When we run a search on the database we often find references to invoices which no longer exist in the archive folders and as such can’t be viewed in PlanetPress Search.
I discovered I have to manually rebuild the Search database to synchronise records in the database with actual files in the archive folders. This operation sometimes take up to 1 hour depending on the number of files\records.