Skip to content
This repository has been archived by the owner on Jan 9, 2024. It is now read-only.

QueryException #32

Closed
alkhachatryan opened this issue Jul 9, 2017 · 4 comments
Closed

QueryException #32

alkhachatryan opened this issue Jul 9, 2017 · 4 comments

Comments

@alkhachatryan
Copy link

Hello. I use Laravel 5.3 upgraded to 5.4. I have PHP7 version and Mysql. I run my app on Ubuntu, apache2 machine.
I want search users using your package, when I try with only name (or last name) it's ok, but when I write name and last name, for example John Smith, I get issue.

(2/2) QueryExceptionSQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list (SQL: select count(*) as aggregate from ys_users where MATCH(name,last_name,login,password,email,mobile,skype,street,city,file) AGAINST(John Smith IN BOOLEAN MODE))

@msonowal
Copy link
Collaborator

Please mention how to re-produce

@cocochepeau
Copy link

Just to be sure. Did you run the console command as described in README.md?

php artisan scout:mysql-index

@Barcelonczyk
Copy link

I'm pretty sure you didn't create fulltext indexes.

@bilalswiftsolutions
Copy link

Hey I want to index only limited column and that's because I am also getting this error

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants