DEBUG MODE SQL Error : 1064

Message Author
Add to del.icio.us
Add to YahooMyWeb
Add to Simpy
Add to BlinkList
PostPosted: Wed Jun 17, 2009 11:51 am   Post subject: DEBUG MODE SQL Error : 1064  

.
.

When I first tried to Post the Father-in-Law -- Deer Damage Topic it Previewed OK but failed to Post.

But instead returned the Error message below.

Is it something on my end or AMPM's end.
===============================
================================

General Error

Error in posting

DEBUG MODE

SQL Error : 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 ''One of my Pennsylvania customers borrowed his Father-in-Law'', 1998, 1245238095' at line 1

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, FldRefererURL,FldTemplate) VALUES ('One of my Pennsylvania customers borrowed his Father-in-Law'', 1998, 1245238095, 16, 0, 0, 0, '', '')

Line : 258
File : functions_post.php

General Error

Error in posting

DEBUG MODE

SQL Error : 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 ''One of my Pennsylvania customers borrowed his Father-in-Law'', 1998, 1245238095' at line 1

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, FldRefererURL,FldTemplate) VALUES ('One of my Pennsylvania customers borrowed his Father-in-Law'', 1998, 1245238095, 16, 0, 0, 0, '', '')

Line : 258
File : functions_post.php

_________________
.
.

That's my 2¢ worth for now. ( maybe ± a couple ¢ ) Smile

FK,
FK
Senior member
Leave a quick message

FK
Joined: 10 Feb 2008
Posts: 250

Location: Pa.
32.15 Dollars($)

PostPosted: Thu Jun 18, 2009 8:50 am   Post subject:   

Hi FK,

Have you used any special character in the title of the topic, like-apostrophe (')? You might have encountered the problem because of that.
simon
Senior member
Leave a quick message

simon
Joined: 28 Sep 2005
Posts: 525


89.94 Dollars($)

PostPosted: Thu Jun 18, 2009 10:14 am   Post subject:   

Put a back-slash before the apostrophe (') and I guess it would be resolved.
steven
Senior member
Leave a quick message

steven
Joined: 02 Feb 2006
Posts: 760


116.97 Dollars($)

Quick Reply
Your Name
Subject
Message body
All times are GMT
Page 1 of 1

 

Ask Community Experts

flash plugin

Quick Links
Must See
Community
Hot topics in forums

Latest in blogs