Hello/Hi/Greetings,
I would like to remove duplicates based on checksum, I have done the checksum and I can see the duplicates but I don't know if selecting all and doing a batch delete will delete also the original ones, I would like to delete all copies and have only the "original" one
Piwigo 11.5.0 Check for upgrade
Operating system: Linux
PHP: 7.4.22 (Show info) [2021-08-30 15:44:37]
MySQL: 5.5.5-10.6.4-MariaDB-1:10.6.4+maria~focal [2021-08-30 13:44:37]
Graphics Library: ImageMagick 7.0.11-13
Piwigo URL: localhost
Offline
If you select *all* then of course *all* selected will be deleted.
Besides, how should it know what you consider the original of two identical duplicates.
Offline
erAck wrote:
If you select *all* then of course *all* selected will be deleted.
Besides, how should it know what you consider the original of two identical duplicates.
Ok, but isn't there anyway to select only duplicates?
Offline
Which is the original and which is the duplicate? And then, which album is the said original supposed to be in. That is the riddle of life.
Offline
If you have them in the mysql database already. Then you can
select (T1.name, t1.md5sum where ( t1.md5sum=t2.md5sum )) and ( T1.second_field <> T2.second_field ))
from table_one T1 table_one T2
You'll have to check the syntax, but it can be done
The mysql 5.7 manual on-line has a fine example of this.
Offline
jnashpiwigo wrote:
Which is the original and which is the duplicate? And then, which album is the said original supposed to be in. That is the riddle of life.
they are all in the same album, I don't really care which one is the "original" but the oldest would be ok
Offline
I have a similar 'issue'. I have a lot of duplicates and the only thing I want to do is merge them. I don't care which is the original. In my eyes they are both copy and both original. Only thing I want is to be left with one of the two. I don't care in which album they are, or will be. Is there any way to do this easily? Manually selecting 1000+ images is not my hobby :-P.
Offline
Hello. I use DupeGuru for this kind of tasks. See: https://dupeguru.voltaicideas.net/
Robert
Offline
Thanks BigIsland, so I guess your answer is also that there is no way of doing this within Piwigo. It would have been a great feature.
Offline