Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Error Deleting video  (Read 3431 times)

0 Members and 1 Guest are viewing this topic.

tivo_lover

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Error Deleting video
« 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
« Last Edit: November 10, 2004, 04:49:20 pm by Casper »
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Error Deleting video
« Reply #1 on: 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.
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error Deleting video
« Reply #2 on: 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error Deleting video
« Reply #3 on: 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
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Error Deleting video
« Reply #4 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.
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error Deleting video
« Reply #5 on: November 10, 2004, 04:44:02 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
Logged

tivo_lover

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error Deleting video
« Reply #6 on: 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
Logged
Pages: [1]   Go Up
 

Page created in 0.034 seconds with 20 queries.