Search is currently unavailable - Unknown MySQL error

Sharetribe Go Community Edition
1

Hello!

I’m trying to run a Sharetribe on CentOS 7 and everything looks good. But if I try to search i get
“Search is currently unavailable. Try searching again soon”

And my server tells me:
" {“marketplace_id”:1,“tag”:“listing_index_service”,“free”:“Unknown MySQL error - SELECT * FROM listing_core , listing_delta WHERE MATCH(’ searchtest ') AND community_id = 1 AND sphinx_deleted = 0 ORDER BY sort_date DESC LIMIT 0, 24 OPTION field_weights=(title=10, category=8, description=3), max_query_time=1000; SHOW META”} "

I tried the rake ts:rebuild and index commands.
Starting and stopping with ts:start / ts:stop doesn’t help either.

MySQL Version is 8, but same error with 5.7.

Anyone know how to fix this?

2

I fixed it by upgrading sphinxsearch to version 3.2.1.

For that i downloaded the tar.gz from http://sphinxsearch.com/ and copied the 4 files from the bin/ folder to /usr/bin/

After that, it works :slight_smile:

1 Like