Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

Brackets in search string causes X-Cart to return no results

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #1  
Old 04-22-2015, 01:59 AM
 
xcart-dev xcart-dev is offline
 

Advanced Member
  
Join Date: Jun 2011
Posts: 59
 

Default Brackets in search string causes X-Cart to return no results

I've just come across this - on batteryguy.com if you search allen bradley 1756-l62 it will find results including part of the string ALLEN BRADLEY 1756-L62 (Series A) (in extra fields).

However if I search ALLEN BRADLEY 1756-L62 (Series A) I get no results. Do the brackets foul up the search codes in X-Cart and if so is there a way round this?

Many thanks!
__________________
X-Cart 4.4.3
Reply With Quote
  #2  
Old 04-22-2015, 06:00 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default Re: Brackets in search string causes X-Cart to return no results

look at the log files for sql errors. I suspect the () trigger some sort of syntax error
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #3  
Old 04-22-2015, 06:45 AM
 
xcart-dev xcart-dev is offline
 

Advanced Member
  
Join Date: Jun 2011
Posts: 59
 

Default Re: Brackets in search string causes X-Cart to return no results

You're correct the error message is:
Description : Got error 'parentheses not balanced' from regexp

IF I search with only an opening '(' - e.g. ALLEN BRADLEY 1756-L62 (S

But if I search with both '(' and ')' there is no error message.....
__________________
X-Cart 4.4.3
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 02:38 PM.

   

 
X-Cart forums © 2001-2020