Coppermine 1.3.4

[Gail]

Hi All,

 

I had most of this message done and lost it.

 

Anyway, I have gone the route of the Help Desk with this problem and one of the chaps suggested I post the problem in this Forum.

 

I have installed Coppermine 1.3.4 on homegail.com and have configured it to display the EXIF data. I am having a problem with the first album that I uploaded - the Family Album (originally 9 photos - now has 11). The photo titled The Great Grandchildren Today is the only one that will have EXIF data. The other pics are older and not taken with a digital camera. This is one of the errors I am getting when trying to view a picture - the thumbnails work:

 

"While executing query "INSERT INTO cpg134_exif VALUES ('albums/Family/Gail's Family/100-3 Marlene, Dot, and Gail.jpg', 'a:0:{}')" on 0

 

mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Family/100-3 Marlene, Dot, and Gail.jpg', 'a:0:{}')' at line 1."

 

If I configure Coppermine to NOT display the EXIF data, everything works fine.

 

I have no clue as to how to fix this - I have no clue as to what they are talking about! This seems very strange since I have exactly the same album in Coppermine on another Domain Name hosted by TCH (on another server). I have named the album the same and have exactly the same photos in it (the original 9)! The version is 1.3.3 if I remember correctly. I keep thinking I should update it because of the security issue with the EXIF data, but now I am not so sure.

 

 

Here is the link for my album that I am having the problem with:

 

Gail's Online Photo Gallery

 

I have left it configured for EXIF to display so you can see the errors. If you look at the other albums, everything is fine. I keep thinking maybe I set the db up incorrectly but then why would the other albums work fine? I have deleted the files and then uploaded the photos again but this did not make any difference. (this was a suggestion from the Help Desk)

 

If it makes a difference, I always use the 'Batch Add' method to add the photos to Coppermine.

 

If I can't get the problem solved, I will just leave it configured to not display the EXIF data. I like to have the date available for folks to view but it isn't the end of the world.

 

Thanks kindly for any suggestions.

 

Gail

Edited September 16, 2005 by Gail

[TweezerMan]

The apostrophe (single quote) in "Gail's" is breaking the query. The query is trying to pass a string (text) that starts with a quote:

'albums/Family/Gail's Family/100-3 Marlene, Dot, and Gail.jpg'

...and MySQL is seeing the quote in "Gail's" as the end of the string. The text following that apostrophe is causing the error, since it's not valid SQL.

 

The problem appears to stem from the directory name on your server containing an apostrophe, but honestly I'm not sure how you would fix that without breaking your album. I have a Coppermine install with album names that do contain apostrophes, but the directory names on the server do not.

 

Hope this helps...

[Gail]

The apostrophe (single quote) in "Gail's" is breaking the query.  The query is trying to pass a string (text) that starts with a quote:

 

...and MySQL is seeing the quote in "Gail's" as the end of the string.  The text following that apostrophe is causing the error, since it's not valid SQL.

 

The problem appears to stem from the directory name on your server containing an apostrophe, but honestly I'm not sure how you would fix that without breaking your album.  I have a Coppermine install with album names that do contain apostrophes, but the directory names on the server do not.

 

Hope this helps...

<{POST_SNAPBACK}>

 

 

Hi David,

 

Thanks for your quick reply. I thought of that yesterday (the apostrophe) - I did rename the album in Coppermine to My Family but I can't remember if I changed it via FTP or in cPanel's File Manager. Anyway, it did not work.

 

Would it help if I started over with that album - delete the files in the album and then delete the album. I can then change the name to My Family - add the directory via FTP and upload the pics again. Then before I do the 'Batch Add' method, I can create a new album in Coppermine - My Family.

 

Thanks.

 

Gail

[TweezerMan]

Once you've created an album, I don't know that changing the album name would change the directory name on the server.

 

Wiping out the album and recreating it does sound like your best bet to me.

[Gail]

Hi David,

 

It worked!

 

 

the right syntax to use near 's Family

 

Now, if only I had followed through more yesterday - instead of just renaming the album in Coppermine. When I saw the above quote, as I said, I thought it must have something to do with the apostrophe. I should have started fresh - delete the photos and album in not only Coppermine but also delete the directories using the FTP program. It would have saved me a lot of time and fewer tickets to the Help Desk.

 

 

By the way, I couldn't get your fixfiles.php to work on this server (92) either. I was getting error messages that I sent to the Help Desk. The help desk had to do something so it would work (I don't know what action they took). When I decided to start over at one point in this process, the fixfiles.php wouldn't work again so I just left it. I have plenty of space left on this Domain Name, so I am not particularly worried about 'ownership' on this Coppermine installation.

 

Thanks again for your help.

 

 

Gail

[TweezerMan]

Glad you were able to get it all straightened out!

 

I'm sorry the fixfiles.php script isn't working for you. Without knowing what the error messages were, I don't have any idea what could have been wrong.

[Gail]

Hi David,

 

I just checked the Help Desk tickets.

 

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@homegail.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

The above was the error message I got both times I tried to run the script. As I said, the first time - staff at the Help Desk did something? and then the fixfiles.php worked fine. After this, when I was having the problems with the Family Album, I decided at one point to run the Coppermine install.php file again. I again received the same error message when I tried to run the fixfiles.php - I didn't want to ask the Help Desk to fix things a second time. I think this all occurred on Sept. 13 as it was that evening when I submitted the first ticket.

 

Gail