Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Doublets  (Read 2620 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: 15764
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: 15764
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.023 seconds with 19 queries.