how to list missing pictures from posts?

  • Resolved audioscavenger

    (@audioscavenger)


    4 years, 9 months ago

    hi

    I need help to build a list of missing pictures in my uploads folder. The media library only displays grey squares and I would like to see a list of filenames. Does anyone knows of a plugin that can do that or a SQL query that can do it?

    thanks

    ———- don’t read below if you don’t want details ————
    For some reason (file system issue maybe), I lost all the pictures of all the posts I created since February 17, 2020
    That’s 3 months totaling 199 pictures.
    The folders of months 03, 04 and 05 also are missing under wp-content\upload\2020\
    The folder of February – 02 – is not missing and some pictures uploaded prior to Feb 17 are still present.

    Even weirder, WP statistics plugin logs under uploads/wp-statistics/ are still present for March and May, but totally absent for February and April.
    This doesn’t make a lot of sense. If the FS was full at 100% which it wasn’t, all the statistics since February would be missing, right?

    Finally, all the nginx logs owned by root are also missing from Feb 9 to May, this clearly indicates a filesystem loss of some kind.

    I have what I consider a correct security setup involving Cloudflare DNS+DDoS, custom login url, bruteforce protection from a plugin + nginx, gg captcha, and web auth, all together. I highly doubt I’ve been hacked but who knows…
    Database is saved daily, and .
    I forgot to ALSO schedule a daily zip of the uploads folder, thank you AWS ><

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)

  • Have you spoken to your host?
    Have you combed through some apache / php logs ?
    Did you change your hosting login ?

    There seems to be a lot of images available in the Google cache if you want to grab them from there, and then re-create the structure locally, and re-upload them in the same filename and folders :

    View post on imgur.com

    I don’t think this is a WordPress issue.

    Thread Starter audioscavenger

    (@audioscavenger)

    thanks for replying!
    my host is AWS, they don’t listen.
    all the logs from that period are gone as well.
    google cache? good idea ?? this is why i need the filenames…………

    this is not a wordpress issue, this is clearly an AWS hardware issue.

    okay, will dig into sql myself then. THANK YOU!

    What are you expecting to gain from accessing the database?
    I don’t understand the data you trying to extract. ?

    Thread Starter audioscavenger

    (@audioscavenger)

    I can parse the pages for regexp like /*.png and test the list against the filesystem to find missing files… i was just wondering if plugins that do just that for me would exist… coz i’m like everyone: lazy.
    Case closed, I’m working on restoring now.
    Thanks again @corrinarusso

    Yes okay.
    I would do a find . on the server for png and include the path. Then grep the same from your sql export. Then kick it old school with PerlDoc File::Compare.
    Good luck!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘how to list missing pictures from posts?’ is closed to new replies.