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: Doublets  (Read 1815 times)

0 Members and 1 Guest are viewing this topic.

Dieter Zoubek

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Doublets
« on: October 08, 2011, 05:52:13 pm »

We have imported some 10 000 pics in our coppermine installation. Due to unclaired reasons we have imported about 300 pics twice.

The filenames of the doublets are identified using SQL methods.

What is the best idea to delete the entries of the doublets in the coppermine installation ? Just delete the entries in the pictures table?

Dieter Zoubek
Austria, Europa
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Doublets
« Reply #1 on: October 11, 2011, 02:21:45 pm »

I assume those dupes points to the same physical files, right? If so, you have to delete them directly in the pictures table. If you'd use the built-in Coppermine methods you'd delete the file on the file system and one entry in the database, resulting in one data set with a missing file.
Logged

Dieter Zoubek

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Re: Doublets
« Reply #2 on: October 11, 2011, 04:35:53 pm »

I assume those dupes points to the same physical files, right?
No. The are in different directories. What do you suggest in this case?


Dieter Zoubek
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Doublets
« Reply #3 on: October 11, 2011, 04:53:01 pm »

Either delete them manually one-by-one with the built-in delete function or create a script that detects your dupes reliably and then delete all files (original/backup, full-sized, normal, thumb - depends on your settings and files) and remove the data sets. Of course you can also just delete the data sets, but then you'll have some dead files on your server that consume disk space.
Logged
Pages: [1]   Go Up
 

Page created in 0.028 seconds with 21 queries.