Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'arthur'') AS pscore, MATCH(m.name) AGAINST('arthur'') AS mscore, p.sort_order ' at line 1
Error No: 1064
SELECT p.product_id, MATCH(pd.name,pd.meta_title,pd.tag) AGAINST('arthur'') AS pdscore, MATCH(p.isbn) AGAINST('arthur'') AS pscore, MATCH(m.name) AGAINST('arthur'') 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.meta_title,pd.tag) AGAINST('arthur'') OR MATCH(p.isbn) AGAINST('arthur'') OR MATCH(m.name) AGAINST('arthur'')) ORDER BY (pdscore + pscore + mscore) DESC in /home/flanart3/public_html/system/library/db/mysqli in /home/flanart3/public_html/system/library/db/mysqli.php on line 40