apostophe in filenames?

[lnguyen]

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

[Joachim Müller]

please post only one ossue per thread. Please post deep links to illustrate the issue you're facing.

GauGau

[lnguyen]

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

[Tarique Sani]

Open the file exif_php.inc.php in the includes directory and change line 33 to

Code Select Expand

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

instead of

Code Select Expand

"WHERE filename = '$filename'";

Or the time being turn the read EXIF information off....

[lnguyen]

thank you!

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

Code Select Expand

VALUES (\"$filename\",

in the same file

thanks again

Linh