[deverill2010]

Originally Posted by Akyeame Kwame

I get this when i try to reply to a PM from the vbsocial notifications button at the top.
It looks like the mod can't deal with a single quote ' in the message.
The original message I was replying to had "yesterday's accounts backup' and the mysql error is saying there's a syntax error near 's accounts backup. Is there a way for it not to deal with the single quote literally?
:

Database error in vBulletin 4.1.11:

Invalid SQL:
INSERT INTO pmtext
                        (fromuserid,fromusername,title,message,touserarray,dateline,showsignature)
                        VALUES(1,'**************','Re:*******************','Any idea as to why?','a:1:{s:2:\"cc\";a:1:{i:3214;s:5:\"****\";}}','1347369886',1);

MySQL 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 accounts backup','Any idea as to why?','a:1:{s:2:\"cc\";a:1:{i:32' at line 3
Error Number  : 1064
Request Date  : Tuesday, September 11th 2012 @ 09:24:45 AM
Error Date    : Tuesday, September 11th 2012 @ 09:24:46 AM
Script        : http://www.***************.com/forums/misc.php?a=pr&i=28569&t=Any%20idea%20as%20to%20why?&h=230
Referrer      : http://www.************.com/forums/forum.php
IP Address    : *************
Username      : *******************
Classname     : vB_Database
MySQL Version : 5.1.61

I get the same issue.