XF 2.2 Mass delete smilies

[Maa]

Hi, I am trying to delete smilies but it is time consuming to delete each single one using acp, is there any way to do it using acp without phpmyadmin? thank you

 

[Paul B]

The only built in function via the ACP UI is to delete them one at a time.

 

[Maa]

we should have that facility when xenforo started.. i am shocked tbh that it was not in the latest version as if you export you can select them all.. why not just implement it to delete too.. makes sense to .. just a suggestion

 

[Paul B]

It shouldn't take that long unless you have hundreds of smilies.

Untested but you could probably use phpMyAdmin to delete all but one and delete the final one in the ACP (to ensure caches are updated correctly).

Take a backup first, just in case.

 

[Maa]

silly question but what is the smilies table called? xf_smilies?

 

[Paul B]

The table is xf_smilie.

 

[Mr Lucky]

I have had problems deleting just one ot two smilers, because you end up with posts that have random irrelevant smilie text in them.