Tomasz Posted November 12, 2016 Share Posted November 12, 2016 When we updated 6.0.12 to the new 6.1.0 and when log in the admin i have some error log. Before it dosent hapend. 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 '%Mk5%' OR I.description fulltext '%Mk5%' OR I.product_code fulltext '%Mk5%') 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 '%Mk5%' OR I.description fulltext '%Mk5%' OR I.product_code fulltext '%' at line 1 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 '%Gti%' OR I.description fulltext '%Gti%' OR I.product_code fulltext '%Gti%') 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 '%Gti%' OR I.description fulltext '%Gti%' OR I.product_code fulltext '%' at line 1 And more errors. I try to update to 6.1.1 and cant. I use automaticy upgrade and manual -> dont work. How i can fix this problem? Thanks a lot Best regard Tomasz Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 12, 2016 Share Posted November 12, 2016 The upgrade to CC611 will not fix the above. These fixes will be in CC612. Unfortunately, CC610 has a problem that causes an automatic upgrade to fail. If you have skill at making edits to code, we invite you to visit the Github and view several bug fixes. If not, we can help you make the edits. Quote Link to comment Share on other sites More sharing options...
Tomasz Posted November 12, 2016 Author Share Posted November 12, 2016 Thx for help. I need change in classes/catalogue.class.php this line: return $this->searchCatalogue($original_search_data, 1, $per_page, 'like'); } } else { $this->_sort_by_relevance = false; $rlike = ''; if (!empty($search_data['keywords'])) { to: return $this->searchCatalogue($original_search_data, 1, $per_page, 'RLIKE'); } } else { $search_mode = in_array($search_mode, array('RLIKE','LIKE')) ? $search_mode : 'RLIKE' $search_mode = in_array($search_mode, array('RLIKE','LIKE')) ? $search_mode : 'RLIKE'; $this->_sort_by_relevance = false; $like = ''; if (!empty($search_data['keywords'])) { Correct? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 12, 2016 Share Posted November 12, 2016 The two lines that you added (the first shown in a reddish color, the second shown in a greenish color), only add the second. The first was replaced by the second because of a missing end-of-line semi-colon. Quote Link to comment Share on other sites More sharing options...
Tomasz Posted November 13, 2016 Author Share Posted November 13, 2016 OK i need add this: return $this->searchCatalogue($original_search_data, 1, $per_page, 'RLIKE'); } } else { $search_mode = in_array($search_mode, array('RLIKE','LIKE')) ? $search_mode : 'RLIKE'; $this->_sort_by_relevance = false; $like = ''; if (!empty($search_data['keywords'])) { Done Thx for help 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.