[Ryloth]

Originally Posted by nymyth

so it seems to work on 3.6.7, however when i try to edit a post and put in the media tag im getting an error:

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT `media_info` FROM `vbmediaplayerinfo` WHERE `media_code`='http://www.youtube.com/watch?v=NhNze4lpfPw"]YouTube - Bamboo Shoots on Conan O'Brien' LIMIT 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 'Brien' LIMIT 1' at line 1
Error Number : 1064
Date : Monday, May 21st 2007 @ 05:09:55 PM
Script : http://www.jaydabhi.com/forum/showthread.php?t=12937
Referrer : http://www.jaydabhi.com/forum/lounge/
IP Address : 198.45.19.38
Username : nymyth
Classname : vb_database

any Ideas? Now I cannot access that thread at all, keep getting that error:

that is b/c the title has a " ' " in it. that is a sql restricted character and more than likely same w/ PHP. it signals end of statement. in c# a " / " would have to be put in front of the " ' " to prvent that from happening. not sure how to do it in PHP but the title is ur problem.

wherever it reads and spits it back out on the page, the php would have to be modified to replace anything with " ' " in it with another safe character or w/ a break in front of it.