MySQL Query Syntax Error on escaped string

Question

INSERT INTO `5` VALUES ('photo', 'headline', 'LA Lakers', 'http://facebook.com/NUMBER', 'Here\'s video from the An...', 'NUMBER', 'http://www.facebook.com/NUMBER/posts/NUMBER', 'NUMBER'), 'https://graph.facebook.com/NUMBER/picture?access_token=AAAGGhZBZB1ZCf4BAD1fNpORWVGtWhUI5u**********************&type=normal')

I get this error when I try this query:

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 ''https://graph.facebook.com/NUMBER/picture?access_token=AAAGGhZBZB1ZC' at line 1

after the individual values (NOT the whole query) have been escaped by php function mysql_real_escape_string.

I have changed all profile ids to the string NUMBER and i added the asterisks to the access token to protect my privacy. Those are not usually there.

Your last value is outside the brackets

Vatev
– Vatev

2012-07-26 18:39:48 +00:00
Commented Jul 26, 2012 at 18:39 — Vatev
– Vatev, Commented Jul 26, 2012 at 18:39

Matt · Accepted Answer · 2012-07-26 18:41:39Z

1

Try this; the last parameter was outside of the parenthesis.

INSERT INTO `5` VALUES ('photo', 'headline', 'LA Lakers', 'http://facebook.com/NUMBER', 'Here\'s video from the An...', 'NUMBER', 'http://www.facebook.com/NUMBER/posts/NUMBER', 'NUMBER', 'https://graph.facebook.com/NUMBER/picture?access_token=AAAGGhZBZB1ZCf4BAD1fNpORWVGtWhUI5u**********************&type=normal')

answered Jul 26, 2012 at 18:41

Matt

7,0504 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Quinn Finney Over a year ago

I was missing it could've sworn you were right... Nope! Thats not the problem.

Quinn Finney Over a year ago

Wait... oops. I've been stairing at this for hours. You are correct. Thank you so much!

Vitor Braga · Accepted Answer · 2012-07-26 18:41:43Z

0

You forgot the round brackets in the last value of your insert query...
Further, use apostrophe in the table name...
Like this:

INSERT INTO '5' VALUES ('photo', 'headline', 'LA Lakers', 'http://facebook.com/NUMBER', 'Here\'s video from the An...', 'NUMBER', 'http://www.facebook.com/NUMBER/posts/NUMBER', 'NUMBER', 'https://graph.facebook.com/NUMBER/picture?access_token=AAAGGhZBZB1ZCf4BAD1fNpORWVGtWhUI5u**********************&type=normal')

answered Jul 26, 2012 at 18:41

Vitor Braga

2,2121 gold badge24 silver badges19 bronze badges

Comments

Gyhth · Accepted Answer · 2012-07-26 18:42:01Z

0

INSERT INTO5VALUES (...), 'https://graph.facebook.com/NUMBER/picture?access_token=AAAGGhZBZB1ZCf4BAD1fNpORWVGtWhUI5u**********************&type=normal'

Take a look at your brackets, they end prematurely, which may be the error.

answered Jul 26, 2012 at 18:42

Gyhth

1,1659 silver badges22 bronze badges

Collectives™ on Stack Overflow

MySQL Query Syntax Error on escaped string

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related