I am not entirely sure if this belongs here, as it may be a mysql issue. I have had problems in the past with SQL injections, so I am watching carefully all error messages from the data base. In recent weeks the site has run stable, yet the only error message which keeps coming up is the following:

Got error 'parentheses not balanced' from regexp query: SELECT DISTINCT n.*, b.*, bt.name as biblio_type_name FROM node n left join biblio b on n.vid=b.vid left join biblio_types bt on b.biblio_type=bt.tid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (b.biblio_authors RLIKE "[[:<:]]Museum of Contemporary Art (Los Angeles[[:>:]]" ) AND (n.type='biblio' ) AND (n.status = 1 ) ) ORDER BY SUBSTRING(LTRIM(b.biblio_authors),1,1) ASC, b.biblio_year DESC LIMIT 0, 25 in

check table and repair table did not help; latest biblio module is installed, version drupal 5.14 (yes I know, slightly slack with upgrading). I am not sure if this a biblio issue, but I am also not sure if this presents a security issue; so maybe someone can take a look.

Comments

rjerome’s picture

The problem is opening parenthesis in the search phrase... "Museum of Contemporary Art (Los Angeles". The parenthesis would have to be double escaped like this... \\(

arminm’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.