vidmarc Posted February 2, 2017 Share Posted February 2, 2017 I have two System Error Logs, are these things I should be worried about? 11 Jan 2017, 14:38 File: [catalogue.class.php] Line: [1717] "SELECT I.* 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 (I.name fulltext '%blu%' OR I.description fulltext '%blu%' OR I.product_code fulltext '%blu%') " - 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 'fulltext '%blu%' OR I.description fulltext '%blu%' OR I.product_code fulltext '%' at line 1 11 Jan 2017, 14:38 File: [catalogue.class.php] Line: [1715] "SELECT I.* 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 (I.name fulltext '%blu%' OR I.description fulltext '%blu%' OR I.product_code fulltext '%blu%') LIMIT 12 OFFSET 0 " - 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 'fulltext '%blu%' OR I.description fulltext '%blu%' OR I.product_code fulltext '%' at line 1 Thanks, Quote Link to comment Share on other sites More sharing options...
bsandall Posted February 2, 2017 Share Posted February 2, 2017 Your search code is generating invalid SQL queries - have you modified catalogue.class.php at all? You may consider trying to update CubeCart to the latest version as well. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 2, 2017 Share Posted February 2, 2017 Please make the attempt to edit the file. See this issue in the Github. Quote Link to comment Share on other sites More sharing options...
vidmarc Posted February 3, 2017 Author Share Posted February 3, 2017 I haven't modified catalogue.class.php. I just tried to update via admin, but it said I was already running the latest version - which I'm not. Strange. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 3, 2017 Share Posted February 3, 2017 Take a look in the Store Overview tab on the admin Dashboard and see what version it says you are on. There have been posts of late saying they could not upgrade via Admin - they were told to do the upgrade manually - some bug in earlier versions necessitating manual. Quote Link to comment Share on other sites More sharing options...
vidmarc Posted February 3, 2017 Author Share Posted February 3, 2017 I did a manual upgrade, all is now fine. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.