! SOLVED !
I am having an issue on my forum where i had a problem with an outdated youtube embed plugin which has caused an issue when i updated my forum.
I have about 1200+ posts with youtube links looking like this now : http://www.youtube.com/watch?v=http:...?v=A5Yj6ImVc1k
when they should look like this:
I tried this SQL update code but it hasnt worked for me:
UPDATE post SET pagetext = REPLACE(pagetext, 'http://www.youtube.com/watch?v=http', 'http')
Any help that can be assisted would be GREATLY appreciated !
Edit1:
I also tried this with no luck:
UPDATE
post
SET
pagetext = replace(pagetext,'http://www.youtube.com/watch?v=http', 'http')
WHERE
pagetext LIKE '%http://www.youtube.com/watch?v=http%'
Edit2: heres an example of an affected post : http://www.djtechtools.com/forum/sho...2&postcount=10
Edit3: Yes my member # does have access permissions in config.php
I am having an issue on my forum where i had a problem with an outdated youtube embed plugin which has caused an issue when i updated my forum.
I have about 1200+ posts with youtube links looking like this now : http://www.youtube.com/watch?v=http:...?v=A5Yj6ImVc1k
when they should look like this:
I tried this SQL update code but it hasnt worked for me:
UPDATE post SET pagetext = REPLACE(pagetext, 'http://www.youtube.com/watch?v=http', 'http')
Any help that can be assisted would be GREATLY appreciated !
Edit1:
I also tried this with no luck:
UPDATE
post
SET
pagetext = replace(pagetext,'http://www.youtube.com/watch?v=http', 'http')
WHERE
pagetext LIKE '%http://www.youtube.com/watch?v=http%'
Edit2: heres an example of an affected post : http://www.djtechtools.com/forum/sho...2&postcount=10
Edit3: Yes my member # does have access permissions in config.php
Comment