Thread Reply Subject!

[Webmasta XT]

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'264','Re: I'm back','','Otaku XT','1','1030443584','0','welcome back and enjoy ur stay!  ;)','1','1','24.102.188.168','0','1')
mysql error: You have an error in your SQL syntax near 'm back','','Otaku XT','1','1030443584','0','welcome back and enjoy ur stay!  ;)'' at line 1

mysql error number: 1064

Date: Tuesday 27th of August 2002 06:19:44 AM
Script: http://www.xtreme-forumz.net/~admin1/newreply.php
Referer: http://62.95.108.21/~admin1/showthread.php?threadid=264

I get that error..... please help!

[Webmasta XT]

nvm, i solved the prob, thnx anywayz

[g-force2k2]

heh i see... bad bad Xenon [ joking of course ]

sorry Webmasta XT didn't see what you had meant before but now i see...

find this code:

PHP Code:

'Re: ".$threadinfo[title]."', 


and replace with:

PHP Code:

'Re: ".'".addslashes(htmlspecialchars($threadinfo[title]))."'."', 


see if that solves your prob man regards...

g-force2k2

[Xyphen]

OK, I did this, and it doesn't work, g-force when i used ur addon, it didn't work -_-

[Boofo]

It doesn't like apostrophes and such. Do this and it will work. I just tested it. I had the same problem with one of my threads.

Find:

'Re: ".$threadinfo[title]."'

and replace it with this:

'Re: ".addslashes(htmlspecialchars($threadinfo[title]))."'

You were close g-force2k2, but no cigar this time.