Moved Forums Directory

[Reece^B]

Moved my forums direcotry to the root tonight but everythings gone smooth apart form the fact that the smileys arnt showing, and when you check them its taking them from the old directory.
Anyone help?

www.pitbikeclub.co.uk

Thanks

[Lats]

You can adjust the Smilie File Path from the Smilie Manager, although that looks a little tedious as it appears you have to move each one manually.

Or, try this query...

UPDATE
    smilie
SET
    smiliepath = replace(smiliepath,'http://www.pitbikeclub.co.uk/vb/images','http://www.pitbikeclub.co.uk/images')
WHERE
    smiliepath 
LIKE '%http://www.pitbikeclub.co.uk/vb/images'

It looks like the post icons will need to be adjusted in a similar manner as well.

[Reece^B]

Thanks, all sorted!

[Silver_2000]

ended up using this recently
disapointed that moving a forum to a new domain or folder requires invention and running a SQL query but I appreciate the help

used a few changes

UPDATE
    smilie
SET
    smiliepath = replace(smiliepath,'http://www.pitbikeclub.co.uk/vb/images','http://www.pitbikeclub.co.uk/images')
WHERE
    smiliepath 
LIKE '%http://www.pitbikeclub.co.uk/vb/images[B][COLOR=red]%[/COLOR][/B]'

dont forget to check the table prefixes
see the red % for an addition that I needed

[Steve Machol]

Please note that this is the major reason that by default these are relative paths and not hard-coded URLs. It is recommended you keep these are relative paths so the same situation does not occur in the future.

[Silver_2000]

Please note that this is the major reason that by default these are relative paths and not hard-coded URLs. It is recommended you keep these are relative paths so the same situation does not occur in the future.

I surely didn't hard code urls in 70 smileys... I dont know how it happened - BUT looking at the number of posts with similar issues - it seems VERY common

[Silver_2000]

after running the SQL script it corrected the smilie path which made the smilies appear in the create thread window
BUT when you click them and click submit the smilies STILL have the OLD path on them in the posted info - Likely getting screwed by the datastore again

need to remember to then go to smilies and edit one and save to update the datastore

[Lats]

Note that after running any manual query, it's generally necessary to update forum information, or counters etc.