Error Number: 1191
Can't find FULLTEXT index matching the column list
SELECT COUNT(*) count FROM (SELECT i.id FROM justfork_shopsearch.items i LEFT JOIN items on i.internalid = items.internalid LEFT JOIN iteminfo on (items.internalid = iteminfo.item) WHERE MATCH(i.itemid, i.displayname, i.salesdescription, i.searchkeywords, i.storedetaileddescription, i.upccode, i.brand, i.infoname, i.category) AGAINST('5678 Sweatpants' ) AND items.isinactive = 0 and iteminfo.isinactive = 0 and coalesce(iteminfo.isonline, items.isonline) = 1 and iteminfo.site = '4' GROUP BY i.internalid) q
Filename: models/Search_model.php
Line Number: 1431