KamoCRM

Create the email search_vector column and its inverted index

FeatureInitializerService
Shipped
5 ஆகஸ்ட், 2026 அன்று 10:55 PM UTC
Author
Kamo
Commit
78bb4b2

**************** never existed. EmailService's own V1__email_metadata_schema.sql declares it, but that migration never ran -- the table came from this service's entity scan, and SearchIndexEntity omits the field because Hibernate cannot map TSVECTOR, so ddl-auto could not add it. **************** therefore failed with SQLSTATE 42703 on every message, and because that UPDATE shares a transaction with the row insert, the insert rolled back too. The table has always been empty and email search has never returned a result.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing