Print Page - apostophe in filenames?

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

Code Select

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

instead of

Code Select

"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:

Code Select

VALUES (\"$filename\",

in the same file

thanks again

Linh

coppermine-gallery.com/forum

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