I thought I checked all functions, maybe I missed this. I’ll try to check it soon.
Is there a different way to clear the data?
MySQL:
DELETE FROM wp_postmeta WHERE meta_key = reaction_buttons_0
Replace 0 for the first button, 1 for the second and so on. I’ll need to rewrite the whole delete unused data stuff, not sure how and when I’ll do it yet.
I’m not proficient with MySQL but I think I’m doing exactly what you suggested. I went to the database, searched it, and here is what I got:
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 seconds.)
Based on this search:
SELECT * FROM wp_postmeta WHERE meta_key = ‘reaction_buttons_0’
This was copied and pasted from the results.
Can I pay you to assist with this?
Sorry, wouldn’t be faster then as well 😉 But the problem was a missing underscore, try
DELETE FROM wp_postmeta WHERE meta_key = _reaction_buttons_0
Went to database and SQL tab in PHPmyAdmin and got this:
Error
SQL query:
DELETE FROM wp_postmeta WHERE meta_key = _reaction_buttons_0
MySQL said:
#1054 – Unknown column ‘_reaction_buttons_0’ in ‘where clause’
Frustrating!
I’m no SQL-whiz myself, it’s hard to find the right syntax on mobile…
DELETE FROM wp_postmeta WHERE meta_key = '_reaction_buttons_0'
probably needed to quote the where clause.
That did it! Thank you! Now it’s easy to clear out data when needed!!!
Great, good to hear. Sorry it tool so long 😉
