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)*59.6325 ), IF(p.id_currency='EUR', p.price*IF(s.eur<>0, s.eur, (1+s.addpccbrfeur/100)*70.3604 ), p.price))) as price_rur, MATCH (p.name) AGAINST ('+Siemens +CX65' 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 = 79 AND spa.is_shop = 1 AND spa.is_partner = 1 AND spa.is_admin = 1 AND MATCH (p.name) AGAINST ('+Siemens +CX65' IN BOOLEAN MODE) ORDER BY rel DESC LIMIT 20 #; Can't find FULLTEXT index matching the column list in /home/link/st-mobil.ru/htdocs/modules/product/lib/product.inc.php on line 216