ChrisColeman Posted August 11, 2019 Share Posted August 11, 2019 I keep on seeing in my error log, is it critical - Quote File: [catalogue.class.php] Line: [1895] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('copper pans' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('copper pans' IN BOOLEAN MODE)) >= 0.5 AND AND `live_from` < UNIX_TIMESTAMP() AND `live_from` < UNIX_TIMESTAMP() ORDER BY `Relevance` DESC LIMIT 15 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `live_from` < UNIX_TIMESTAMP() AND `live_from` < UNIX_TIMESTAMP() ORDER BY' at line 1 Thanks ... Link to comment Share on other sites More sharing options...
bsmither Posted August 11, 2019 Share Posted August 11, 2019 It is a known CubeCart issue and should be fixed in CC626. This query is constructed incorrectly and results in a product search that returns no results. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted August 11, 2019 Share Posted August 11, 2019 Issue was reported and fixed here : https://github.com/cubecart/v6/issues/2320 Link to comment Share on other sites More sharing options...
ChrisColeman Posted August 12, 2019 Author Share Posted August 12, 2019 Hi, Is there a patch ? Chris. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted August 12, 2019 Share Posted August 12, 2019 Yes, from the given github issue url, follow the couple of links to the submits Link to comment Share on other sites More sharing options...
ChrisColeman Posted August 12, 2019 Author Share Posted August 12, 2019 Got it - thank you - Chris. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.