Fatal error: Uncaught Exception: Error: Can't find FULLTEXT index matching the column list
Error No: 1191
SELECT p.product_id, MATCH(pd.name,pd.description,pd.meta_title,pd.tag) AGAINST('michael archer') AS pdscore, MATCH(p.isbn) AGAINST('michael archer') AS pscore, MATCH(m.name) AGAINST('michael archer') AS mscore, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = 2) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = 0) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.date_available <= NOW() AND p.status = 1 AND ( MATCH(pd.name,pd.description,pd.meta_title,pd.tag) AGAINST('michael archer') OR MATCH(p.isbn) AGAINST('michael archer') OR MATCH(m.name) AGAINST('michael archer')) ORDER BY (pdscore + pscore + mscore) DESC in /home/flanart3/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/flanart3/public_html/system/storage/modification/system/library/db.php(29) in /home/flanart3/public_html/system/library/db/mysqli.php on line 40