Guest Joff Posted August 25, 2010 Share Posted August 25, 2010 I can't find any mention of this bug but I've discovered it across a number of CubeCart store versions from 4.2.3 up to 4.4.2 Has anyone come across this before and resolved it? In 4.4.2 1139: Got error 'empty (sub)expression' from regexp SELECT DISTINCT(I.productId), I.*, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE (I.name RLIKE '' OR I.description RLIKE '' OR I.productCode RLIKE '') 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 name ASC In 4.3.3 and earlier 1054: Unknown column 'O' in 'where clause' SELECT DISTINCT(I.productId), I.*, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE O 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 name ASC Quote Link to comment Share on other sites More sharing options...
Guest Joff Posted August 31, 2010 Share Posted August 31, 2010 If anyone's reading this, can you please try the search on your own stores and let me know if you're also affected? Quote Link to comment Share on other sites More sharing options...
Homar Posted August 31, 2010 Share Posted August 31, 2010 If anyone's reading this, can you please try the search on your own stores and let me know if you're also affected? I too am receiving this error. Interesting... Have you logged a bug? Quote Link to comment Share on other sites More sharing options...
Guest Joff Posted September 6, 2010 Share Posted September 6, 2010 If anyone's reading this, can you please try the search on your own stores and let me know if you're also affected? I too am receiving this error. Interesting... Have you logged a bug? Not yet, I wanted to make sure it wasn't just me going mad! Quote Link to comment Share on other sites More sharing options...
Guest kumanx Posted October 15, 2010 Share Posted October 15, 2010 I can't find any mention of this bug but I've discovered it across a number of CubeCart store versions from 4.2.3 up to 4.4.2 Has anyone come across this before and resolved it? In 4.4.2 1139: Got error 'empty (sub)expression' from regexp SELECT DISTINCT(I.productId), I.*, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE (I.name RLIKE '' OR I.description RLIKE '' OR I.productCode RLIKE '') 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 name ASC In 4.3.3 and earlier 1054: Unknown column 'O' in 'where clause' SELECT DISTINCT(I.productId), I.*, I.name AS SearchScore FROM CubeCart_inventory AS I, CubeCart_category AS C WHERE O 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 name ASC put this in the search form too ' it is straight quote mark/apostrophe, the sql error will show Quote Link to comment Share on other sites More sharing options...
leeofaccy Posted October 15, 2010 Share Posted October 15, 2010 Yeah, I'm getting this too. Quote Link to comment Share on other sites More sharing options...
Guest Joff Posted October 15, 2010 Share Posted October 15, 2010 Yeah, I'm getting this too. Not in mine, I think it's been resolved by 4.4.2. Also, the original bug I posted above was fixed by following Technocrat's solution: http://bugs.cubecart.com/view.php?id=2228 Quote Link to comment Share on other sites More sharing options...
Guest kumanx Posted October 18, 2010 Share Posted October 18, 2010 Yeah, I'm getting this too. Not in mine, I think it's been resolved by 4.4.2. Also, the original bug I posted above was fixed by following Technocrat's solution: http://bugs.cubecart.com/view.php?id=2228 I have change the code and it works perfect, the sql not error again to search for "or", but if search special character ' (apostrophe) the sql error still shown in CC 4.4.2. 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.