Error: wrong SQL query #SELECT p.id_product, p.name, p.short_name, p.price, p.url, ca.keyword, p.id_shop, s.name as shop, s.direct_link, (IF(p.id_currency='USD', p.price*IF(s.usd<>0, s.usd, (1+s.addpccbrfusd/100)*88.7045 ), IF(p.id_currency='EUR', p.price*IF(s.eur<>0, s.eur, (1+s.addpccbrfeur/100)*97.1594 ), p.price))) as price_rur, MATCH (p.name) AGAINST ('+Samsung +X20 +V05' IN BOOLEAN MODE) as rel FROM price_products p JOIN price_categories ca ON p.id_category = ca.id_category, price_shops s , price_spa as spa WHERE p.id_shop = s.id_shop AND s.public = 1 AND spa.id_shop = s.id_shop AND spa.id_partner = 142 AND spa.is_shop = 1 AND spa.is_partner = 1 AND spa.is_admin = 1 AND MATCH (p.name) AGAINST ('+Samsung +X20 +V05' IN BOOLEAN MODE) ORDER BY rel DESC LIMIT 20 #; Can't find FULLTEXT index matching the column list in /home/link/nbinfo.ru/htdocs/modules/product/lib/product.inc.php on line 215