Destroyed media database – help !

  • the5krunner

    (@the5krunner)


    6 months, 3 weeks ago

    I seem to have destroyed my 20,000+ item media database (over 250,000 thumbnails). Before the issue occurred, several files were scaled and cropped within wordpress. I also changed the wordpress thumbnail sizes. I also migrated my images to Cloudflare Images Edge, keeping origin server masters.

    ‘Something’ went wrong at ‘some point’ and ‘everything broke’ giving me my worst tech issue in over 20 years (well, ever). Two examples of issues a) hardcoded image path to a specicfc size thumbnail that doesn’t exist b) image gallery shortcode of attachment_IDs displays blank images (but if I edit the image it finds something)

    (I’ve been working for the last 60+ hours on this!)

    I cant restore from a backup because I was unaware of the problem for a month. I would lose a month of work of have to perform some sort of export/import of content+images + configuration changes (of which there are many)

    Your free tool found only about 10 images on disk (all with -scaled.jpg suffixes). I’m not concerned about those.

    What I’ve done to fix:

    1. I’ve added a more comprehensive list of thumbnail sizes covering sizes I had before and sizes I have now.
    2. “Regenerate thumbnails” seems to have improved things. I’m as yet unable to get through the full list of 20k files
    3. I’m running wp-smush on a ‘cant hurt basis’
    4. I have run “broken link checker.” I’ve reduced the number of broken links from thousands to about 30, so that’s the job done for the more obvious errors. I’m not bothered about 30
    5. question. Can your Pro Tool fix my remaining issues? a. The remaining issue seems to be attachment_IDs that don’t properly resolve to images especially from galleries
    6. question. Can your Pro Tool fix my remaining issues? b. bring together all variants of original files, those with -scaled in their name and others with an odd suffix added, like e1590005335934 in this file AJ-Bell-London-Triathlon-Standard-Olympic-Route-e1590005335934.png

    One complicating factor is that I can make changes on the origin, but they are not necessarily reflected on the edge. So I might think a file is ok but it is not to the rest of the world (unless I specifically double-check…there is a LOT of double-checking to do)

    Basically I need a ‘fix everything’ media tool that consider the attachment_ID and then links every child thumbnail version, and scaled child, and resized child (defined by the first part of the image name)

    can your tool do that please?

    (the linked url contains numerous examples)

    • This topic was modified 6 months, 3 weeks ago by the5krunner.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author erolsk8

    (@erolsk8)

    6 months, 3 weeks ago

    Hi @the5krunner, I’m sorry to hear this, it’s quite the challenge. But unfortunately, the Pro version probably wouldn’t help. The Import part works the same as in this free version. Because both use the exact same functions that WordPress uses when uploading files through the Media Library. Except that files are already there in place and this plugin doesn’t touch them – it only creates database records for them.

    Sorry for the disappointing answer. Hope you’ll find a way to clean this up.

    Thread Starter the5krunner

    (@the5krunner)

    6 months, 3 weeks ago

    all my galleries were created with files that existed.

    i dont think any files have been deleted but may have got lost when i resized them or reoriented them

    so with my example: AJ-Bell-London-Triathlon-Standard-Olympic-Route-e1590005335934.png –

    1. would it add that as a separate and new database record?
    2. would it be added as a valid child of: AJ-Bell-London-Triathlon-Standard-Olympic-Route.png

    either case might help me as i’m currently going to have to upload new versions )or maybe i think there is an image replace tool that might work)

    Plugin Author erolsk8

    (@erolsk8)

    6 months, 2 weeks ago

    If you can select AJ-Bell-London-Triathlon-Standard-Olympic-Route-e1590005335934.png and import it, then it would be a separate and new database record. Pro version has option to filter out these edit versions when selecting items to import. Not sure if that helps.

    But yes, it would be good to properly detect these files that end with -e{timestamp} as edited versions of original images.

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

The topic ‘Destroyed media database – help !’ is closed to new replies.