Delete plugin

Hi @freddyee

If you don’t want to keep optimized images, it would be ideal to restore them to original via Media Library (Bulk option).

Then you can delete it from Plugins page.

Some database entries would stay in case you need them in the future (if you decide to use Imagify again, for example).

You can go into your hosting account’s PHPMyAdmin, and run the following on your database:

DELETE FROM wp_postmeta where meta_key = ‘_imagify_status’ or meta_key = ‘_imagify_optimization_level’ or meta_key = ‘_imagify_data’

Note: Be sure to replace the “wp” part with your database’s prefix.

Hope this helps. ?Let me know if you need any further assistance, I am happy to help.

Best Regards
Marko

I try to restore them to original in bulk, but some images do and others don’t, what can I do ?

I have to do it one by one, but some images doesn’t have the option to restore

• This reply was modified 4 years ago by freddyee.

I tried the code, but I have this error

SQL query:
DELETE FROM wpco_postmeta where meta_key = ‘_imagify_status’ or meta_key = ‘_imagify_optimization_level’ or meta_key = ‘_imagify_data’

MySQL said: Documentation
#1054 - Unknown column '‘_imagify_status’' in 'where clause'

hello ?

You told me to let you know if I need further assistance, I need it

I can’t delete the data, please , help !

Hey @freddyee,

Sorry about that!

I think I may see what the issue was. Sometimes certain text editing environments can replace straight quotes (which should be used for code) with curly quotes, and I think that may have happened with the code we pasted for you earlier (apologies for that). If you look at it closely, you can see ‘ is used rather than ‘.

So please try the following instead, and hopefully, it will work better for you:

DELETE FROM wp_postmeta where meta_key = ‘_imagify_status’ or meta_key = ‘_imagify_optimization_level’ or meta_key = ‘_imagify_data’

And as before, make sure you replace the “wp” part of “wp_postmeta” with your own database prefix (may or may not also be “wp”). Also, be sure you’ve made a complete site and database backup before doing this.

Please let us know if this still doesn’t work for you and we can see if there might be any other options.

Best regards,
Joseph

Hi

It didn’t work.

Table 'runayaqc_wp100.wp_postmeta' doesn't exist

what can I do ?

Hey @freddyee

Try with runayaqc_wp100_postmeta, it should work.

Best Regards
Marko

I tried that , got this :

#1146 - Table 'runayaqc_wp100.runayaqc_wp100_postmeta' doesn't exist

So then tried this:

DELETE FROM wpco_postmeta where meta_key = ‘_imagify_status’ or meta_key = ‘_imagify_optimization_level’ or meta_key = ‘_imagify_data’

but got this result:

ERROR 1054 (42S22): Unknown column '‘_imagify_status’' in 'where clause'

What can I do ?

• This reply was modified 3 years, 11 months ago by freddyee.

Hey @freddyee,

Sorry things are still not working for you! It should be working for you, so it’s hard to know exactly what the issue is. If you look at your database tables in PHPMyAdmin, do you see one similar to as follows, only named runayaqc_wp100_postmeta or wpco_postmeta instead (I’ve seen you reference both in code above)?

https://jmp.sh/8zbrWXM

If so, then I think the issue might be that when we post our code, the single quota are being changed to the curly quote versions, which should not be used in code. Please try either of the following while making sure you’re using the straight single quotes if this post changes them to the curly versions:

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

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

When you check in PHPMyAdmin, if you see the table prefixed with anything else, then replace that name in the code above and try that.

If none of these work, you can also try to install and activate the following plugin:

https://www.dropbox.com/s/csubnnil3oxh2o0/imagify-reset-optimization-status.zip?dl=0

Once activated, just refresh the page one time, then deactivate and unistall the plugin, and then check to see if the Imagify data has been removed from your database.

Best regards,
Joseph