Error Deleting video

[tivo_lover]

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

[Casper]

How exactly did you try to delete it?

Please turn on debug mode, and post the full error message here.

[tivo_lover]

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

[Joachim Müller]

Appears you're using an old version, the query fails because of the unescaped single quote in the album name.

Joachim

[Casper]

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.

[tivo_lover]

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

[tivo_lover]

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