Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: converting filenames in database  (Read 3384 times)

0 Members and 1 Guest are viewing this topic.

Dillio187

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
converting filenames in database
« on: September 20, 2006, 04:29:35 pm »

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.
Logged

eruss

  • Supporter
  • Coppermine frequent poster
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 105
Re: converting filenames in database
« Reply #1 on: September 21, 2006, 03:42:45 am »

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
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.