[Forum] Every member has all Private messages unread... mass PM class as read needed!

[Threepwud]

Hey folks

I can't say why but it is a new install with an SMF 2 import. Went well but for some reason everyone has all their PMs as unread. Some people have hundreds, perhaps thousands and going through them 50 at a time is not the best way to mark them all as read.

So is there a mass query I can execute to mark all the private messages as read for everyone?

Kind regards,

[matt94gt]

I want to know the same thing, have the same problem.

[*~Vix~*]

I have the same problem. I've done numerous searches on here and can't find anything on this. Is there an SQL query I can execute to mark them all as read please?

[Andy]

See post #5

https://www.vbulletin.com/forum/showthread.php/105112-Some-SQL-queries