Smilies not showing up correctly

[bluidkiti]

Since I have upgraded to VB4 RC2 I am having problems with the smilies. When you go to post a new thread/pms or reply smilies are showing up as BB Code to the right. Shown in images below:

Attachment 107469
Attachment 107470

I have hundreds of smilies and was trying to do this so as not to have to change the path for each one.

Where do I put:

UPDATE smilie set smiliepath=replace(smiliepath, 'http://www.yoursite.com/forums/images/', 'images/')

And how do I do this? I tried putting the code above in admincp in the Execute SQL Query section in the Manuel Query box but that didn't work.

[bluidkiti]

I finally figured out why it was not working. I don't have my forum in a "forums" folder. I have it on the domain itself. So I needed to run it like this:

UPDATE smilie set smiliepath=replace(smiliepath, 'http://www.yoursite.com/images/', 'images/')

I needed to take forums/ out. They are working now.

[JMEWLS`]

What file did you have to edit? I have the same problem.

[Lynne]

He edited the database. There are a couple of threads on vb.com about this - you should look over there for help with this issue.

[JMEWLS`]

Gr, I was stupid enough to do the "yoursite" part of the code and not change it. My images on the right now have a link looking like this;

http://www.nbadimensions.net/forums/http://www.nbadimensions.net/forums/http://www.yoursite.com/images/smilies/iono.gif

I executed a code like follows...

UPDATE smilie set smiliepath=replace(smiliepath, 'http://www.nbadimensions.net/forums/http://www.nbadimensions.net/forums/http://www.yoursite.com/images', 'images/')

That correct?

[Lynne]

That looks OK to me.

[JMEWLS`]

Weird, still coming up with this link:

http://www.nbadimensions.net/forums/http://www.nbadimensions.net/forums/http://www.yoursite.com/images/smilies/Cry.gif

[BBR-APBT]

Originally Posted by JMEWLS`

I executed a code like follows...

UPDATE smilie set smiliepath=replace(smiliepath, 'http://www.nbadimensions.net/forums/http://www.nbadimensions.net/forums/http://www.yoursite.com/images', 'images/')

That correct?

Originally Posted by JMEWLS`

Weird, still coming up with this link:

http://www.nbadimensions.net/forums/http://www.nbadimensions.net/forums/http://www.yoursite.com/images/smilies/Cry.gif

Thats because thats what you told it to do.

Your code should be as follows.

UPDATE smilie set smiliepath=replace(smiliepath, 'http://www.nbadimensions.net/forums/images/', 'images/')

[JMEWLS`]

Interesting still not working.

I can execute the query in vbulletin can't I?

[BBR-APBT]

You sure can long as you have permission in the config.