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.
Quote from: Casper on November 10, 2004, 04:29:43 PM
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