forum.coppermine-gallery.net
Support => Older/other versions => cpg1.3.x Support => Topic started by: tivo_lover on November 10, 2004, 03:52:57 pm
-
I have been using 1.3.1 for several months without any problems. Today I tried to delete a video that I loaded several days ago and get the error message "There was an error while processing a database query" Can someone point me in the right direction about how to proceed? Thanks
-
How exactly did you try to delete it?
Please turn on debug mode, and post the full error message here.
-
I tried to delete from the Album screen where you can play the video, edit the description, delete the file, or crop and rotate. I chose Delete. Here is the error. Thanks
While executing query "DELETE FROM cpg131_exif WHERE filename='albums/new/MTB - Madison's Stuff - WA Represent.wmv' LIMIT 1" 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 Stuff - WA Represent.wmv' LIMIT 1' at line 1
-
Appears you're using an old version, the query fails because of the unescaped single quote in the album name.
Joachim
-
It's probably caused by the apostrophy in the name 'MTB - Madison's Stuff - WA Represent.wmv'
Try using the 'edit files' page to delete this file. Let us know if that works.
And do as Gaugau suggests, update to the latest version.
-
It's probably caused by the apostrophy in the name 'MTB - Madison's Stuff - WA Represent.wmv'
Try using the 'edit files' page to delete this file. Let us know if that works.
And do as Gaugau suggests, update to the latest version.
Thank
-
Sorry my last post kind of self-destructed. I meant to say that the 'edit files' page worked fine and the video is now gone. Will try to upgrade soom. Thanks again