Delete all smilies at once?


Well-known member
Not sure if I asked this one before, but what is the best way to bulk delete smilies from the Admin CP?


Well-known member
You'll have to manually construct a query that'll delete it based on IDs. Its most likely easier to delete manually.
I'm sure they'll update this in the future, but in the meantime:

How do you delete more than one smiley at a time?
We really need a way to mass delete smilies in the ACP. I deleted the file from the DB but I am having to indivdually delete nearly 150 smilies one by one - taking 4ever. :rolleyes:
  1. Use phpmyadmin
  2. Go to the xf_smilies table
  3. Press browse to show the data, rather than structure
  4. At the bottom of the page set it to display more than 30 rows if needed
  5. Shift and tick to select multiple rows at once
  6. Press the delete button at the bottom.
There may be a maximum number of rows you can select at once, so if it looks like it hasn't ticked all rows in your range, it will have selected as many as it can, so just delete and repeat.
Last edited: