Announcement

#1 2023-04-19 01:06:35

Jan Becket
Member
2015-01-17
41

Check Uploads plugin

Hello,

I installed the Check Uploads plugin after a site crash in which I had to replace my database with one from over a year earlier. Of course there were images I had uploaded previously but which did not appear after I had installed the earlier database. I’ve been repairing and updating the site.

Every time I log into Piwigo I now get a message that there are missing images and the Check Uploads plugin gives the the list below. I have probably up-uploaded most of those images. How do I now delete the 28 prior images listed by Check Upload? Is there a path I can follow to go into my hosting server and pull those files out?

thanks,
Jan

Piwigo 13.6.0 Check for upgrade
Installed on 17 January 2015, 8 years 3 months ago
Operating system: Linux
PHP: 7.4.33 (Show info) [2023-04-18 15:59:28]
MySQL: 5.5.5-10.2.44-MariaDB-log [2023-04-18 15:59:28]
Graphics Library: ImageMagick 6.9.10-68
Cache size 1106.57 Mo   calculated 1 month ago

Piwigo URL: http://janbecket.net/piwigo


28 files are listed in the database, but not available in the filesystem
photo #164 path=2015/01/29/20150129183450-65bc5cd4.jpg is in the database, not in the filesystem
photo #166 path=2015/01/29/20150129184800-f0867bc9.jpg is in the database, not in the filesystem
photo #176 path=2015/01/29/20150129214817-9ce5fd18.jpg is in the database, not in the filesystem
photo #184 path=2015/01/29/20150129221030-db559d4e.jpg is in the database, not in the filesystem
photo #188 path=2015/01/29/20150129221118-d2a7f4df.jpg is in the database, not in the filesystem
photo #191 path=2015/01/29/20150129221300-f591182b.jpg is in the database, not in the filesystem
photo #193 path=2015/01/29/20150129221330-66420afc.jpg is in the database, not in the filesystem
photo #195 path=2015/01/29/20150129221352-22bc4bbc.jpg is in the database, not in the filesystem
photo #206 path=2015/01/29/20150129222513-3746d6fc.jpg is in the database, not in the filesystem
photo #207 path=2015/01/29/20150129222524-5e73b37b.jpg is in the database, not in the filesystem
photo #345 path=2015/02/02/20150202184523-22118867.jpg is in the database, not in the filesystem
photo #387 path=2015/02/02/20150202225408-e274bdac.jpg is in the database, not in the filesystem
photo #417 path=2015/02/02/20150202230025-1f130546.jpg is in the database, not in the filesystem
photo #418 path=2015/02/02/20150202230038-c4bae17f.jpg is in the database, not in the filesystem
photo #927 path=2015/06/03/20150603032600-dc94a983.jpg is in the database, not in the filesystem
photo #929 path=2015/06/03/20150603032641-51a555a5.jpg is in the database, not in the filesystem
photo #1177 path=2017/03/27/20170327011059-a4077199.jpg is in the database, not in the filesystem
photo #1353 path=2019/12/09/20191209211209-bd2edea1.jpg is in the database, not in the filesystem
photo #1395 path=2021/08/15/20210815000004-118c7e67.jpg is in the database, not in the filesystem
photo #1399 path=2021/08/15/20210815000130-497017d2.jpg is in the database, not in the filesystem
photo #1403 path=2021/08/15/20210815000257-956b5e9d.jpg is in the database, not in the filesystem
photo #1404 path=2021/08/15/20210815000319-44e2ec06.jpg is in the database, not in the filesystem
photo #1407 path=2021/08/15/20210815000446-eed61393.jpg is in the database, not in the filesystem
photo #1411 path=2021/08/15/20210815000609-52ce726a.jpg is in the database, not in the filesystem
photo #1413 path=2021/08/15/20210815000652-1d45e312.jpg is in the database, not in the filesystem
photo #1414 path=2021/08/15/20210815000713-fd748616.jpg is in the database, not in the filesystem
photo #1416 path=2021/08/15/20210815000756-27e6a22d.jpg is in the database, not in the filesystem
photo #1417 path=2021/08/15/20210815000816-2b3f5501.jpg is in the database, not in the filesystem

Offline

 

#2 2023-04-19 03:23:03

erAck
Only trying to help
2015-09-06
2023

Re: Check Uploads plugin

That would involve manipulating the database, i.e. remove the corresponding image entries from table piwigo_images, but also removing the ID or records from wherever it's used as a reference, e.g. in table piwigo_comments the image_id, table piwigo_history, and all tables piwigo_image_category, piwigo_image_format (if any), and piwigo_image_tag. Maybe more.

Hopefully repairing database under Admin -> Tools -> Maintenance does it already. Otherwise it's going to be a hairy manual task.. Do backups ;-)


Running Piwigo at https://erack.net/gallery/

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact