forum.coppermine-gallery.net

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

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