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: Can't delete an image.  (Read 8059 times)

0 Members and 1 Guest are viewing this topic.

Fredda66

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Can't delete an image.
« on: September 01, 2005, 05:08:10 pm »

I get the following messages when trying to delete a picture through coppermine

"While executing query "DELETE FROM cpg11d_exif WHERE filename='albums/test/139.jpg' LIMIT 1" on 0
mySQL error: Table 'fredda_se.cpg11d_exif' doesn't exist"

I've ran the update.php file again and it says,

"CREATE TABLE cpg11d_exif ( `filename` text NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAM Already Done "

But hell no, it's not done. It doesnt exist in my database.
When turning on "Read EXIF data in JPEG files" I can't even view my pictures!

Solution?

//F
« Last Edit: October 21, 2005, 11:17:00 pm by GauGau »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Can't delete an image.
« Reply #1 on: September 01, 2005, 08:02:33 pm »

What does this have to do with the 1.4 beta?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Fredda66

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Can't delete an image.
« Reply #2 on: September 01, 2005, 10:53:59 pm »

I didn't have the problem on my previous version 1.2.1.
It has occured since the update...
But if you so wish, then move it to some sort of official support page?

//F
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Can't delete an image.
« Reply #3 on: September 02, 2005, 12:59:55 am »

You upgraded to the beta version, 1.4.1?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Fredda66

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Can't delete an image.
« Reply #4 on: September 05, 2005, 05:23:32 pm »

Yes I did.
Logged

Nibbler

  • Guest
Re: Can't delete an image.
« Reply #5 on: September 05, 2005, 08:35:01 pm »

Does your db user have the CREATE privilege ?
Logged

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: Can't delete an image.
« Reply #6 on: September 06, 2005, 10:19:45 am »

I don't know if this will help, but I had something similar happen to me. Using Admin Tools and
rebuilding the thumbnails and intermediate pictures in the suspect album sorted out the problem for me.


Dennis
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

Fredda66

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Can't delete an image.
« Reply #7 on: September 28, 2005, 12:15:08 pm »

There is no suspect album. Can't delete any picture in any album without alot of huzzle.
Tried to rebuild all the thumbs but that didn't help.
The DB user must have CREATE privilege, otherwise I shouldn't been able to install the script from the begining?

More suggestions please! This must be fixed!

//F
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Can't delete an image.
« Reply #8 on: September 29, 2005, 08:30:03 am »

your webhost might have changed permissions, so the initial install will have succeeded (while the db user had the create privilege), but when upgrading, the privileges might have been different then. Try this for yourself - use a tool like phpMyAdmin and run this query:
Code: [Select]
CREATE TABLE cpg11d_exif ( `filename` text NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAMIf it fails, contact your webhost. Post feedback here.
Logged

Nibbler

  • Guest
Re: Can't delete an image.
« Reply #9 on: October 14, 2005, 04:13:41 am »

This does need looking at though, we can't assume 'already done' just because the query fails.

Code: [Select]
        if (@mysql_query($q)) {
            echo "<td class='updatesOK'>OK</td>";
        } else {
            echo "<td class='updatesFail'>Already Done</td>";
        }
Logged

Fredda66

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Can't delete an image.
« Reply #10 on: October 15, 2005, 09:43:53 am »

your webhost might have changed permissions, so the initial install will have succeeded (while the db user had the create privilege), but when upgrading, the privileges might have been different then. Try this for yourself - use a tool like phpMyAdmin and run this query:
Code: [Select]
CREATE TABLE cpg11d_exif ( `filename` text NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAMIf it fails, contact your webhost. Post feedback here.

Okey, sorry for the slow feedback here. It's been other things on the "to do list".
I've tried the proposed suggestion, with the following result:

SQL-frċga : 

CREATE TABLE cpg11d_exif(

`filename` text NOT NULL default '',
`exifData` text NOT NULL ,
UNIQUE KEY `filename` ( `filename` )
) TYPE = MYISAM

MySQL sa:

#1170 - BLOB column 'filename' used in key specification without a key length


There is no doubt that the user has create privileges. There's something else that's just not playing out right.
Logged

Nibbler

  • Guest
Re: Can't delete an image.
« Reply #11 on: October 15, 2005, 02:16:56 pm »

Ah, that query is indeed wrong - it should be this

Code: [Select]
CREATE TABLE CPG_exif (
  `filename` varchar(255) NOT NULL default '',
  `exifData` text NOT NULL,
  UNIQUE KEY `filename` (`filename`)
) TYPE=MyISAM;
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 20 queries.