search

yabhq / laravel-scout-mysql-driver

Laravel Scout MySQL Driver
MIT License
522 stars 113 forks source link

QueryException #32

Closed alkhachatryan closed 6 years ago

alkhachatryan commented 7 years ago

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 commented 7 years ago

Please mention how to re-produce

cocochepeau commented 7 years ago

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

php artisan scout:mysql-index

Barcelonczyk commented 7 years ago

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

bilalswiftsolutions commented 3 years ago

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