Question Removing a lot of the same entries

[domenico]

Hi,

Because of a mass PM I now have like 25000+ notifications in my shoutbox. How can I remove them all (leaving the other messages intact) in one go?

Thank you!

 

[Fillip H.]

There's no way of doing that outside of going into the DB, unfortunately

You will need to run a query similar to this in order to manually remove them:

DELETE FROM dbtech_vbshout_shout WHERE type = 8 AND id = x

Remember to add your table prefix, and change the X to your user ID. This will wipe all notifications sent to you.

change id to userid if you want to wipe notifications sent by you.