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
Comment #1
rjerome commentedThe problem is opening parenthesis in the search phrase... "Museum of Contemporary Art (Los Angeles". The parenthesis would have to be double escaped like this... \\(
Comment #2
arminm commented