Another 1064 error!

Seen after someobe was trying to register:

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 'S STORTFORD%' OR CB_CITY LIKE '%HERTFORDSHIRE%' OR CB_POSTCODE LIKE '%xx xxx' AT LINE 3 SQL=SELECT * FROM x_COMPROFILER AS A LEFT JOIN x_USERS U ON U.ID = A.USER_ID WHERE U.BLOCK<>1 AND A.USER_ID <> 305 AND A.APPROVED=1 AND A.CONFIRMED=1 AND ( CB_BOROUGHTOWN LIKE '%BISHOP'S STORTFORD%' OR CB_CITY LIKE '%HERTFORDSHIRE%' OR CB_POSTCODE LIKE '%xxx xxx%') AND USER_ID NOT IN (62) LIMIT 5

Could it be the ' in '%BISHOP'S STORTFORD%'

bins wrote: Could it be the ' in '%BISHOP'S STORTFORD%'

yup - could be the unescaped single quote in BISHOP'S

What is triggering this query? CB Query Field? A userlist? A CB Auto Actions? If that's a substitution its escaping is setup incorrectly as it should be passed through the appropriate MYSQL escaping function when substituted in, but that depends entirely on where it's coming from.

Some one is trying to register!!!

Yes, but that query is not a core query. It's coming from something. If you've CB Auto Actions enabled try disabling it and see if issue resolves. If not then disable CB Query Field if it's installed and see if that resolves it.