Title: Clearing out data
Last modified: August 30, 2016

---

# Clearing out data

 *  Resolved [anefarious1](https://wordpress.org/support/users/anefarious1/)
 * (@anefarious1)
 * [11 years ago](https://wordpress.org/support/topic/clearing-out-data/)
 * Awhile back it was explained that if you simply change the name of a button and
   then hit “remove unused data” and the change the button name back… it will clear
   out the data for that particular button. That used to work great but today I 
   tried to do it several times with no luck. Could the recent updates have changed
   the process?
 * [https://wordpress.org/plugins/reaction-buttons/](https://wordpress.org/plugins/reaction-buttons/)

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

 *  Plugin Author [Jakob Lenfers](https://wordpress.org/support/users/jakob42/)
 * (@jakob42)
 * [10 years, 12 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202138)
 * I thought I checked all functions, maybe I missed this. I’ll try to check it 
   soon.
 *  Thread Starter [anefarious1](https://wordpress.org/support/users/anefarious1/)
 * (@anefarious1)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202167)
 * Is there a different way to clear the data?
 *  Plugin Author [Jakob Lenfers](https://wordpress.org/support/users/jakob42/)
 * (@jakob42)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202168)
 * 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.
 *  Thread Starter [anefarious1](https://wordpress.org/support/users/anefarious1/)
 * (@anefarious1)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202169)
 * 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.
 *  Thread Starter [anefarious1](https://wordpress.org/support/users/anefarious1/)
 * (@anefarious1)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202192)
 * Can I pay you to assist with this?
 *  Plugin Author [Jakob Lenfers](https://wordpress.org/support/users/jakob42/)
 * (@jakob42)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202194)
 * 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`
 *  Thread Starter [anefarious1](https://wordpress.org/support/users/anefarious1/)
 * (@anefarious1)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202195)
 * 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!
 *  Plugin Author [Jakob Lenfers](https://wordpress.org/support/users/jakob42/)
 * (@jakob42)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202196)
 * 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.
 *  Thread Starter [anefarious1](https://wordpress.org/support/users/anefarious1/)
 * (@anefarious1)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202197)
 * That did it! Thank you! Now it’s easy to clear out data when needed!!!
 *  Plugin Author [Jakob Lenfers](https://wordpress.org/support/users/jakob42/)
 * (@jakob42)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202198)
 * Great, good to hear. Sorry it tool so long 😉

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

The topic ‘Clearing out data’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/reaction-buttons_ddebf9.svg)
 * [Reaction Buttons](https://wordpress.org/plugins/reaction-buttons/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/reaction-buttons/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/reaction-buttons/)
 * [Active Topics](https://wordpress.org/support/plugin/reaction-buttons/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/reaction-buttons/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/reaction-buttons/reviews/)

 * 10 replies
 * 2 participants
 * Last reply from: [Jakob Lenfers](https://wordpress.org/support/users/jakob42/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/clearing-out-data/#post-6202198)
 * Status: resolved