Feature for removing db entries with an invalid file path #798

Closed
opened 2026-10-05 00:17:58 +02:00 by adam · 1 comment
Owner

I have a lot (!) of orphaned images with no thumbnail and URLs return 404. About 40,000. When I search the file system for the file name in the URL, nothing comes up. I've done the inverse and found files on the file system that does get thumbnails.

Not sure what happened to the images, but I would at least want to remove the invalid file entries from the database. Does piwigo have this functionality, or do I have to do it manually in mysql?

I have a lot (!) of orphaned images with no thumbnail and URLs return 404. About 40,000. When I search the file system for the file name in the URL, nothing comes up. I've done the inverse and found files on the file system that does get thumbnails. Not sure what happened to the images, but I would at least want to remove the invalid file entries from the database. Does piwigo have this functionality, or do I have to do it manually in mysql? <!-- github-sync-id:335213879 -->
adam closed this issue 2026-10-05 00:17:58 +02:00
Author
Owner

Found this issue while searching for "orphan" (problem of speed to compute them...)

Use plugin Check Uploads to find differences between what Piwigo has in its database and what's in the filesystem.

Found this issue while searching for "orphan" (problem of speed to compute them...) Use plugin Check Uploads to find differences between what Piwigo has in its database and what's in the filesystem. <!-- github-comment-id:1354486987 -->
Sign in to join this conversation.
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#798