Hi guys, whats the php or sql command to run and delete all "Unread Message"
I've tried the one from year 2012 it doesnt work anymore it says
#1054 - Unknown column 'NOT status=0' in 'where clause'
The query i entered is this:
DELETE FROM mybb_privatemessages WHERE NOT status=0
Thank you and its not too much to ask, kindly include the query for how to delete all read message, or delete all private message.
I'm not too good but try:
DELETE FROM mybb_privatemessages WHERE *
That one should delete all private messages
private.php?action=empty
You can find the rest out yourself I don't want to empty my folders
Based on this :
http://docs.mybb.com/1.6/Database-Tables...emessages/
The status for unread messages seems to be "0" and in your query you said :
"DELETE FROM
mybb_privatemessages WHERE
NOT status=0 "
Shouldn't it be :
DELETE FROM
mybb_privatemessages WHERE status = '0'
Try on a test database before deleting anything.
thank you guys, and leefish corp
UBER i wana delete all my members unread or private msg because all of them are lazy to delete and complaining that their inbox are full,
but i dont want to increase their quota.
oldducky, actually i dont have any idea about what i did, i jst googled it. tnx
My point of view : tell them to delete themselves what they want to delete, some of your users which are not complaining could have some data that they want to keep.
Otherwise, deleting all PM should works using Ben C suggestion.
Thank you guys for the support. I've talked to my board and they said its fine to delete all pm including read or unread so whats the query for this.
The plugin above can i use that and set the day to 0 this way it will delete all pm both read and unread?
You don't need to delete everything, deleting old PMs will leave some place for new ones and so on.
At least if you set it to 1day should be ok for them.
Otherwise, there is an option directly into phpmyadmin to clear a table. I have it in french so I don't now directly the english term but you should find it easily.
Thanks guys problem solved.
After deleting both read and unread msg thru phpadmin, do i need to press the recount and rebuild option for pm's in ACP? Thanks