Smilies in 2.1.8

[Migrated From Jforum.net]

Smilies are not showing up in admin or forum

Jetty / MySql

Issue is an additional leading / in the url

There is no root.properties file, and the jforum-custom.conf contains no references to smilies.

The top two Configurations options for forum and site URL both contain a / at the end

The Image url given is domain.com//images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif

If you change it manually in the web browser to domain.com/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif it works
(obviously, domain.com isn't my domain, example!)

In SystemGlobals.properties

smilie.image.pattern =

I CHANGED THIS to

smilie.image.pattern =

It STILL doesn't work (that is, there is still a leading /, making two // in the image url), which means it is not being used?

Any ideas why the url has a leading / and how I can remove it? Thanks
[originally posted on jforum.net by jforumapp]

[Migrated From Jforum.net]

You could try checking the smilies table in your database to make sure you have the right URLs for the smilie location ...

Table name: jforum_smilies

Example URL value for one of the smilie entries:
[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

Right, so I see the same thing in the database - #CONTEXT#/images

I changed it to #CONTEXT#images and it all works now.

BUUUUUT...

Question: Is this correct? If so, why is my context suffixed with a /, causing the issue?
If it isn't correct - which step in the installation went wrong to write out #CONTEXT#/images instead of #CONTEXT#images
IMHO, #CONTEXT#/images seems correct, so my guess is the context shouldn't be having a / at the end.

Ideas?

Anyway, if anyone else sees this, run this sql:

update jforum_smilies set url = replace(url, '#/', '#');

[originally posted on jforum.net by jforumapp]

[Migrated From Jforum.net]

sorry, wrong place. Can I delete it?
[originally posted on jforum.net by simon885]