SpielByWeb Forum Index SpielByWeb
http://www.spielbyweb.com/
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   Find a UserFind a User   UsergroupsUsergroups   RegisterRegister 
 Your GamesYour Games   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Using apostrophes causes SQL Syntax error

 
Post new topic   Reply to topic    SpielByWeb Forum Index -> Bug Reports
View previous topic :: View next topic  
Author Message
rebhuhn



Joined: 21 Apr 09
Posts: 2


PostPosted: Wed Jan 06, 2016 6:14 pm    Post subject: Using apostrophes causes SQL Syntax error Reply with quote

Posting the following text as a message:

hmm, if that's a strong second, what does it make the 1 point back third? Not sure, but it's not first, that would be Brad again. Well done once more.

Caused this error:

SQL ERROR: 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 a strong second, what does it make the 1 point back third? Not sure, but it's' at line 1 [INSERT INTO pbw_messages (messages_id, messages_games_id, messages_users_id, messages_text, messages_date) VALUES (NULL, 106156, 47737, 'mm, if that's a strong second, what does it make the 1 point back third? Not sure, but it's not first, that would be Brad again. Well done once more.', 1452121983)]
Back to top
View user's profile Send private message
milksheikh
Site Admin


Joined: 24 Sep 03
Posts: 399

Location: Brooklyn, New York, USA

PostPosted: Sat Jan 09, 2016 9:21 pm    Post subject: Reply with quote

Should be fixed now!

(a side effect of a software upgrade)
Back to top
View user's profile BoardGameGeek Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SpielByWeb Forum Index -> Bug Reports All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group