This object is in archive! 

Error when search term includes parentheses

Archived Chris R. 12 years ago

A user searched for:

credit balance(s)

The () cause a MySQL syntax error:

EXCEPTION: SQLSTATE[42000]: Syntax error or access violation: 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 'credit balance(s) > 0 OR MATCH(m.title,m.description) AGAINST ('credit balance(s' at line 5

Replies (2)

photo
1

Chris,

We are aware of that problem and are working on it. The fix will be provided during next 2-3 days, as we are rewriting search and tweaking it for the new release.

Will post fix here

photo
1

The fix will be provided in 2.1 release that will be live during next 2 days

Replies have been locked on this page!