Erase all optimized images and traces

  • Resolved voutmore

    (@voutmore)


    4 years, 3 months ago

    Hello,

    how can I erase the plugin and all the traces, including optimized images?

    I’ve tried this

    DELETE FROM 'postmeta' where meta_key = '_imagify_status' or meta_key = '_imagify_optimization_level' or meta_key = '_imagify_data'

    but MySQL returns this:

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”postmeta’ where meta_key = ‘_imagify_status’ or meta_key = ‘_imagify_optimizati’ at line 1

    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WP Media

    (@wp_media)

    Hi @voutmore!

    This is Joseph from Imagify, and I’ll gladly assist you here!

    I’m sorry you’re having issues getting your Imagify entries removed from your database!

    I tried the same MySQL command that you are attempting to use on my test setup and received the same error message as you.

    So instead, I tried the following, which did work:

    DELETE FROM
  `postmeta`
where
  meta_key = '_imagify_status'
  or meta_key = '_imagify_optimization_level'
  or meta_key = '_imagify_data'

    Notice the use of backticks around postmeta rather than single quotes. Would you please give the above code a try and see if it works for you? Thank you so much!

    Best regards,
    Joseph

    • This reply was modified 4 years, 3 months ago by WP Media.
    • This reply was modified 4 years, 3 months ago by WP Media.
    Thread Starter voutmore

    (@voutmore)

    Nope, it doesn’t work neither.

    Is there any other way to delete everything, including optimized images?

    Error:
    #1146 – Table ‘***.postmeta’ doesn’t exist

    • This reply was modified 4 years, 3 months ago by voutmore.
    Plugin Author WP Media

    (@wp_media)

    Hey @voutmore,

    Sorry that didn’t work for you! It seems like the table name ‘postmeta’ does not exist in your database. Most WordPress installations use a table prefix, with the most common one being ‘wp_’ though yours could be different. Would you please instead try the following:

    DELETE FROM
  `wp_postmeta`
where
  meta_key = '_imagify_status'
  or meta_key = '_imagify_optimization_level'
  or meta_key = '_imagify_data'

    If that doesn’t work, then your table prefix may be different. In this case, you may need to view your tables in PHPMyAdmin to find the exact name of your ‘postmeta’ table.

    Regarding removal of optimized images, if you mean restoring the images to their original, unoptimized form, then you can go into your Media Library (list view), select large groups of images by checking the boxes next to them, and then applying the “Restore original” bulk action. This would need to be done before removing Imagify though.

    If you mean just deleting all the images entirely, then you can do the same as above, but instead apply the “Delete permanently” bulk action.

    Let me know if you are able to get the MySQL command to work with the above suggestions, and I’ll be glad to continue from there if needed!

    Best regards,
    Joseph

    Thread Starter voutmore

    (@voutmore)

    Yep, that one worked, thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Erase all optimized images and traces’ is closed to new replies.