Error Deleting video Error Deleting video
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Error Deleting video

Started by tivo_lover, November 10, 2004, 03:52:57 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

tivo_lover

November 10, 2004, 03:52:57 PM Last Edit: November 10, 2004, 04:49:20 PM by Casper
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

#1
November 10, 2004, 04:09:15 PM
How exactly did you try to delete it?

Please turn on debug mode, and post the full error message here.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

tivo_lover

#2
November 10, 2004, 04:20:28 PM
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

#3
November 10, 2004, 04:26:32 PM
Appears you're using an old version, the query fails because of the unescaped single quote in the album name.

Joachim

Casper

#4
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.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

tivo_lover

#5
November 10, 2004, 04:44:02 PM
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

tivo_lover

#6
November 10, 2004, 04:46:41 PM
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
Print
Go Up Pages1
User actions