Urgent error! Please help. Query failed: You have an error in your SQL syntax

[gabs]

Anyone know how I can fix this problem?
I've no idea how it happened.

Notice: Query failed: 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 'n' roll bassist needed' AND owner='105'' at line 1 SQL: UPDATE class_products SET notified='Y' WHERE title='Rock 'n' roll bassist needed' AND owner='105' in /home/findband/public_html/us/includes/MySQL.php on line 120

It's found on
http://www.findbandmates.com/us/index.php

Appreciate the help.
Many thanks.

[Mike-N-Tosh]

Don't know for sure, but it looks like the 'n' needs to be "escaped"

Try going into your admin and manually editing the title for that ad. Either remove the apostrophes ('), escape them \'n\', or replace them like this:

PHP Code:

#39n#39 


because that is what looks like is causing the error. I couldn't get this post to actually put the apostrophe equivalent in there. It kept replacing it. The equivelent is & # 3 9 ; without the spaces in between each character.

Hope that helps.

-Mike

[Mike-N-Tosh]

Also, since you posted this in the v3.0 support, you might be able to resolve this by downloading and installing the latest version of the tinyMCE.

[Eric Barnes]

Also you may want to turn off the renewal feature because that appears to be the cause.