coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: lnguyen on June 24, 2004, 10:14:54 PM

Title: apostophe in filenames?
Post by: lnguyen on June 24, 2004, 10:14:54 PM
Ok, have a few things I've noticed.  I have no idea if this was present in 1.2.1 or not, as I never noticed it (never brought to my attention anyway)

what can I do about apostrophe's in filenames?  I got a database error when trying to view the picture (after clickcing the thumbnail) and turned on debug.  basically, the error goes with filename = 'blah's pciture.jpg'" (yes, the last part is an apostrophe and a qoute)

Any ideas?

Thanks
Linh
Title: Re: apostophe in filenames, unassigned albums?
Post by: Joachim Müller on June 25, 2004, 12:33:28 AM
please post only one ossue per thread. Please post deep links to illustrate the issue you're facing.

GauGau
Title: Re: apostophe in filenames?
Post by: lnguyen on June 25, 2004, 04:41:41 AM
what do you mean by deep links? 

this is the ablum in question for the apostrophe problem: http://kineticphoto.net/thumbnails.php?album=25

I think it's apostrophes that are causing the problem.  I turned on debug for all.  If you click on any of the images there, you'll see what I'm talking about. 

Thanks
Linh
Title: Re: apostophe in filenames?
Post by: Tarique Sani on June 25, 2004, 05:14:19 AM
Open the file exif_php.inc.php in the includes directory and change line 33 to

"WHERE filename = \"$filename\"";

instead of

"WHERE filename = '$filename'";

Or the time being turn the read EXIF information off....
Title: Re: apostophe in filenames?
Post by: lnguyen on June 25, 2004, 06:01:58 PM
thank you!

also, for future reference, gotta do the same for the following code:

VALUES (\"$filename\",

in the same file

thanks again

Linh