# NousResearch/hermes-agent · Multimodal content incorrectly indexed in FTS tables

## Open now

- 1 issue, 1 PR open on GitHub.
- #69672: messages_fts_trigram indexes the \\x00json: multimodal sentinel, making state.db FTS integrity SQLite-version-dependent (spurious "malformed inverted index") + DB bloat
- PR #87655: fix(state): project multimodal text into trigram/CJK FTS indexes

An issue and two fixes address how multimodal sentinel values are being stored verbatim in full-text search indexes (including trigram and CJK variants), causing SQLite-version-dependent integrity errors and unnecessary database bloat. The fixes project actual text content into the FTS indexes instead.

## TL;DR

- 3 member(s): 1 open issue(s), 0 closed issue(s), 1 open PR(s), 0 merged PR(s), 1 PR(s) closed without merging.
- No fix has been merged to main; one or more PRs were attempted (see below).
- **Recommended:** review the prior/competing PR(s) below. A fix was attempted but not merged; your case may extend or revive that work.

## Maintainer resolution verdict

- Internal-tracker verdict over this cluster's issue members: `unresolved`. This is distinct from the fix status above. Weigh it yourself.

## How this cluster was grouped

- Link evidence (`STRUCTURAL_SPANNING`): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
- Pairwise link density `0.67`: the share of member pairs that carry a link, counting a structural link in full and a relevance-only link at 0.36. `1.00` means every pair is linked.

## Open related issues

- #69672: messages_fts_trigram indexes the \\x00json: multimodal sentinel, making state.db FTS integrity SQLite-version-dependent (spurious "malformed inverted index") + DB bloat

## Prior & competing PRs

- **#69798: fix(state): project multimodal text into FTS indexes**. closed without merge
  - maintainer direction: category `implemented_elsewhere`; implication `superseded`
- **#87655: fix(state): project multimodal text into trigram/CJK FTS indexes**. open
  - maintainer direction: category `implemented_elsewhere`; implication `superseded`
  - files: `hermes_state.py`, `hermes_state_common.py`, `hermes_state_schema.py`, `hermes_state_search.py`, `tests/test_fts_cjk_bigram.py`, `tests/test_hermes_state.py`

## Fix status

- No merged fix on record.
- Subsystem: `agent`