2n3055 Posted June 5, 2010 Share Posted June 5, 2010 After upgrading from 439 to 440 the search function from the store's home page returns the following error: MySQL Error Occurred Error Message: 1064: 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 '*) as `count`, MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as' at line 1 SQL: SELECT DISTINCT(I.productId), I.count(*) as `count`, MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as `count`2006count(*) as `count`)' IN BOOLEAN MODE) AS SearchScore FROM apollo_CubeCart_inventory AS I, apollo_CubeCart_category AS C WHERE (MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as `count`2006count(*) as `count`)' IN BOOLEAN MODE)) >= 0.500000 AND C.cat_id > 0 AND C.cat_id = I.cat_id AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND I.disabled = '0' ORDER BY SearchScore DESC Anyone else having this problem or knows a cure? Thanks, Paul Quote Link to comment Share on other sites More sharing options...
Guest thecanfool Posted June 5, 2010 Share Posted June 5, 2010 I am also getting an error when trying to use the search function 1064: 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 '*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_cate' at line 1 the above error is a search fir null below is a search for a string 1064: 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 '*) as `count`, MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as' at line 1 Quote Link to comment Share on other sites More sharing options...
Ausy Posted June 5, 2010 Share Posted June 5, 2010 Same for me, I submitted a bug report. Quote Link to comment Share on other sites More sharing options...
oldman79 Posted June 6, 2010 Share Posted June 6, 2010 Break search and got this error Deprecated: Function split() is deprecated in /home/xxxx/includes/content/viewCat.inc.php on line 185 MySQL Error Occurred Error Message: 1064: 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 '*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_cate' at line 1 SQL: SELECT DISTINCT(I.productId), I.count(*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE (I.name RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]' OR I.description RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]' OR I.productCode RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]') AND C.cat_id > 0 AND C.cat_id = I.cat_id AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND I.disabled = '0' ORDER BY `date_added` DESC, `name` ASC Quote Link to comment Share on other sites More sharing options...
Ausy Posted June 7, 2010 Share Posted June 7, 2010 Now fixed. http://bugs.cubecart.com/view.php?id=2119#c3591 Quote Link to comment Share on other sites More sharing options...
Guest aguser Posted June 7, 2010 Share Posted June 7, 2010 Will this fix be in the current 4.4.0 package or would we have to apply it seperatly? Quote Link to comment Share on other sites More sharing options...
Ausy Posted June 7, 2010 Share Posted June 7, 2010 You would probably need to apply it seperately. Quote Link to comment Share on other sites More sharing options...
Guest aguser Posted June 7, 2010 Share Posted June 7, 2010 Thanks for the update and the fixes. I'll upgrade to 4.4.0 and apply the fixes at same time. Quote Link to comment Share on other sites More sharing options...
2n3055 Posted June 7, 2010 Author Share Posted June 7, 2010 Yes thanks to the team for the prompt replies and fixes - much appreciated. Quote Link to comment Share on other sites More sharing options...
Guest Technocrat Posted June 7, 2010 Share Posted June 7, 2010 Break search and got this error Deprecated: Function split() is deprecated in /home/xxxx/includes/content/viewCat.inc.php on line 185 MySQL Error Occurred Error Message: 1064: 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 '*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_cate' at line 1 SQL: SELECT DISTINCT(I.productId), I.count(*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE (I.name RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]' OR I.description RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]' OR I.productCode RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]') AND C.cat_id > 0 AND C.cat_id = I.cat_id AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND I.disabled = '0' ORDER BY `date_added` DESC, `name` ASC Open that file Find: $searchwords = split ( '[ ,]', sanitizeVar($_REQUEST['searchStr'])); Replace with: $searchwords = preg_split( '/[ ,]/', sanitizeVar($_REQUEST['searchStr'])); Quote Link to comment Share on other sites More sharing options...
oldman79 Posted June 9, 2010 Share Posted June 9, 2010 Break search and got this error Deprecated: Function split() is deprecated in /home/xxxx/includes/content/viewCat.inc.php on line 185 MySQL Error Occurred Error Message: 1064: 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 '*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_cate' at line 1 SQL: SELECT DISTINCT(I.productId), I.count(*) as `count`, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE (I.name RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]' OR I.description RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]' OR I.productCode RLIKE '[[:<:]]chang[[:>:]].count(*) as `count`[[:<:]]trai[[:>:]].count(*) as `count`[[:<:]]da[[:>:]].count(*) as `count`[[:<:]]tai[[:>:]]') AND C.cat_id > 0 AND C.cat_id = I.cat_id AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND I.disabled = '0' ORDER BY `date_added` DESC, `name` ASC Open that file Find: $searchwords = split ( '[ ,]', sanitizeVar($_REQUEST['searchStr'])); Replace with: $searchwords = preg_split( '/[ ,]/', sanitizeVar($_REQUEST['searchStr'])); Many thanks for your great help Technocrat. It is working great. Quote Link to comment Share on other sites More sharing options...
Guest Technocrat Posted June 9, 2010 Share Posted June 9, 2010 I fixed this for the next release Quote Link to comment Share on other sites More sharing options...
oldman79 Posted June 9, 2010 Share Posted June 9, 2010 I fixed this for the next release Also you will need fix file admin/sources/products/index.inc line 390 to: $searchwords = preg_split ( '/[ ,]/', trim($_GET['searchStr'])); Hope this problem will take care of next release. Quote Link to comment Share on other sites More sharing options...
Guest Technocrat Posted June 9, 2010 Share Posted June 9, 2010 I fixed them all already except for PayJunction. I don't want to mess with that one so someone else will have to look at it 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.