When trying to change the type of indexing from 'string' to 'fulltext' the index completes but when searching the following error appears:

'SearchApiException: Cannot perform fulltext search on field field_death_year of type string. in SearchApiDbService->search() (line 569 of [personal path to sites directory]/sites/all/modules/search_api/contrib/search_api_db/service.inc).'

CommentFileSizeAuthor
#1 search_api_db.field_type_change.patch643 bytesdrunken monkey

Comments

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Title: SearchApiException: Cannot perform fulltext search on field [field name] of type string » Cached types for DB servers aren't correctly updated
Status: Active » Needs review
StatusFileSize
new search_api_db.field_type_change.patch643 bytes

Thanks for creating the issue. The attached patch should fix this problem.

Oh, and did you manage to test the patch in #1155568-9: unable to index historical date fields yet?

sharonknieper’s picture

sharonknieper commented

not yet...sorry. I hope to over the weekend.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Needs review » Fixed

Committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.