Support Forums

gabs · 01-28-2008, 06:57 PM

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** · 01-28-2008, 07:41 PM

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** · 01-28-2008, 08:11 PM

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*** · 01-29-2008, 03:18 AM

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

01-28-2008, 06:57 PM	#1
gabs Member Join Date: Apr 2006 Posts: 39 Rep Power: 13	Urgent error! Please help. Query failed: You have an error in your SQL syntax 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.

01-28-2008, 07:41 PM	#2
Mike-N-Tosh Moderator Join Date: Jan 2007 Location: Pennsylvania, USA Posts: 1,285 Rep Power: 37	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 v3.1.10 Developer IndianaPC.org - A community website Sandbox v4.0.9, 4.1 Templates, Mods & Docs for sale \| My blog with much content for 68 Classifieds. Web Hosting \| Web Design & Development \| 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out Last edited by Mike-N-Tosh; 01-28-2008 at 07:46 PM.

01-29-2008, 03:18 AM	#4
*Eric Barnes* 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 4,703 Rep Power: 109	Also you may want to turn off the renewal feature because that appears to be the cause. __________________ Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| Submit a Ticket \| 68 @ Twitter \| My Modules

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error in your SQL syntax; check the manual that corresponds to your MySQL	clairemary	v3.1 Questions & Support	2	05-04-2007 12:03 PM
SQL Errors	wynnen	v3.1 Questions & Support	5	04-03-2007 01:25 PM
SQL Image Error	djm	v3.1 Questions & Support	2	10-23-2006 06:39 PM

01-28-2008, 08:11 PM	#3
Mike-N-Tosh Moderator Join Date: Jan 2007 Location: Pennsylvania, USA Posts: 1,285 Rep Power: 37	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. __________________ Mike-N-Tosh v3.1.10 Developer IndianaPC.org - A community website Sandbox v4.0.9, 4.1 Templates, Mods & Docs for sale \| My blog with much content for 68 Classifieds. Web Hosting \| Web Design & Development \| 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out