converting filenames in database

[Dillio187]

I have an install of 1.4.9 that has been upgraded a few times.  When I first set it up I was a bit of a newbie and was using file names that contained spaces.  Everything worked fine until my last upgrade, when all of the files with spaces were converted to underscores.  Now, when viewing the thumbnail and intermediate images, everything works fine, but when attempting to view the fullsize image, nothing comes up due to the file not existing anymore.  Is there any way to convert all of the links in the database from spaces to underscores?  I've verified it works by changing a couple files back to having spaces in them.  Obviously, going forward I will not use any spaces in my file names, as unfortunately I read the FAQ post above a year or so too late.

Thanks for any help or suggestions.

[eruss]

I have an install of 1.4.9 that has been upgraded a few times.  When I first set it up I was a bit of a newbie and was using file names that contained spaces.  Everything worked fine until my last upgrade, when all of the files with spaces were converted to underscores.  Now, when viewing the thumbnail and intermediate images, everything works fine, but when attempting to view the fullsize image, nothing comes up due to the file not existing anymore.  Is there any way to convert all of the links in the database from spaces to underscores?  I've verified it works by changing a couple files back to having spaces in them.  Obviously, going forward I will not use any spaces in my file names, as unfortunately I read the FAQ post above a year or so too late.

Thanks for any help or suggestions.

Answer here:  http://forum.coppermine-gallery.net/index.php?topic=32507.0