Path problem ???

[bcomeau]

Hi there,

After a bit of playing around I have uploaded EE to my ISP and it sort of works...

The included gallery (D30 photos) seems to work fine. I added a new gallery as a test run and uploaded 21 thumbnails, and 21 photos in two different sizes.

In the 'Exhibition Editor' everthing appears correct ( I can see all 21 thumbnails/microthumbs on the right hand side of the screen)

When I go to the 'Pick A Photo To Edit' editor and then click on 'create a new photo..' I go to another page that displays 8 of the 21 thumbnails and then gives the following error message:

Error performing query checkusage: You have an error in your SQL syntax near 's.jpg' ' at line 11

I have checked and re-checked everything and cannot seem to find what is causing this error.


????


thnx,


brian

[Pekka]

The reason must be that your file (number 8 or so) has a file name which has a ' in it. This possibility has been taken care of in next EE, but for 1.22 you can try to add

$image = addslashes($image);
just before line
$checkusage = mysql_query(

in selectphoto.php

but in 1.22 the correct solution would be rename those files as the aforementioned fix is only a part of the complete fix (even with above fix in 1.22 saving filenames to database with ' s can get you more error messages depending on your PHP's settings).

[bcomeau]

Thank you Pekka...this has fixed the problem ( I renamed the one problem file...)



brian