Comments on Search function not working in a new instance

Post

Search function not working in a new instance Question

−0

I have successfully set up QPixel on my local machine, but any attempt to use the "Search" function fails with "Your search syntax is incorrect.".

I found out that this is caused by an exception in app/controllers/search_controller.rb, that contains the message: "Error: Mysql2::Error: Can't find FULLTEXT index matching the column list"

I understand that I need to setup a FULLTEXT index on a table in the database, as it was not done automatically during the installation. How to do that?

database

posted about 17 hours ago

CC BY-SA 4.0

Arnaud‭

11 reputation 1 0 2 0

Raw

Markdown

History

1 comment thread

Just in case - have all migrations run successfully? (1 comment)

Oleg Valter‭ wrote about 10 hours ago · edited about 10 hours ago

copy link

The index is supposed to be created automatically when you run rails db:migrate. What's the output of rails db:migrate:status (its output is quite lengthy, so it'll be easier to run rails db:migrate:status | grep "fulltext")? If the index is supposed to be there, you'll see something along the lines of up 20191207001359 Add search fulltext index to posts. If the migration is present in the output and its status is "up", it's probably a bug of ours.

Communities

Comments on Search function not working in a new instance

Search function not working in a new instance Question

1 comment thread