Print Page - how to remove dead pictures

Title: how to remove dead pictures
Post by: dt on April 05, 2004, 12:26:05 AM

ok some things that i have noticed in my album is that i have reuploaded the pictures into another folder and delted thoose certain pics in that directory and that folder and it still shows up

well heres a link to it
http://rapid.50free.org/gallery/thumbnails.php?album=lastup&cat=0&page=27

:?

Title: how to remove dead pictures
Post by: Nibbler on April 05, 2004, 12:35:41 AM

You have to delete images through coppermine, not by deleting files yourself. The database needs to be updated when pics are removed, and the only way to do this is by using coppermine's own interface.

Title: how to remove dead pictures
Post by: dt on April 05, 2004, 01:33:30 AM

im sure i deleted it using the coppermine

caus i had this problem uploading it and it didnt show and yeah

what can i do to fix it???

or any other suggestion please

Title: how to remove dead pictures
Post by: Nibbler on April 05, 2004, 02:42:57 AM

Can't you just delete the broken pics from within coppermine ? this should remove them from the database completely.

Title: how to remove dead pictures
Post by: dt on April 05, 2004, 06:50:14 AM

i think i renamed the folder first before i delete it therefore i can delete it now :(

is there any way to delete it from the database code or something :)
or what sould i do, i dont want to leave it like this :cry:

Title: how to remove dead pictures
Post by: Joachim Müller on April 05, 2004, 08:20:38 AM

use a tool like phpMyAdmin and edit the table cpg11d_pictures manually (delete the records with the dead links). Back up your database before doing so (in case you delete records you weren't meant to). Next time, use coppermine to delete pics, as coppermine will delete both the records in the database and the files (that's one of the main advantages of using a software like coppermine). Once pics are within coppermine's database, you mustn't touch them with ftp.

GauGau

Title: how to remove dead pictures
Post by: warteschlange on April 07, 2004, 11:10:37 AM

Quote from: "gaugau"use a tool like phpMyAdmin and edit the table cpg11d_pictures manually (delete the records with the dead links). Back up your database before doing so (in case you delete records you weren't meant to). Next time, use coppermine to delete pics, as coppermine will delete both the records in the database and the files (that's one of the main advantages of using a software like coppermine). Once pics are within coppermine's database, you mustn't touch them with ftp.

GauGau

i just want to remind, that a good database application never should behave as the sole and unique modifier of content. Just imagine, as it happens in my case, someone uses two different gallery-applications and use the same folders, which is always preferable.
Now i don't think that the rebuild query is very difficult. You should provide a simple dialog which allows to remove broken database entries.
Allowing people to upload by FTP means, they can delete images, even by mistake.

Andres

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: dt on April 05, 2004, 12:26:05 AM