how to remove dead pictures

[dt]

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

 :?

[Nibbler]

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.

[dt]

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

[Nibbler]

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

[dt]

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:

[Joachim Müller]

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

[warteschlange]

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