A bunch of really old sent PMs are marked as unread

[Viper007Bond]

At the top of my UserCP, I have a ton of really old PMs that I sent to other members that seem to be unread. My count in the upper-right shows 0 new ones.

I assume these really old ones are from back when we used phpBB.

Is there any way to mass mark them as read?

[Jake Bunce]

I have heard of this happening with some imports. You can easily mark all PMs read with this query:

UPDATE pm
SET messageread = 1

But there probably is not an easy way to single out just the old ones.

[Jake Bunce]

And if you mark all PMs read then you can also run this query to update the counter in the navbar for each user:

UPDATE user
SET pmunread = 0

[Viper007Bond]

Ah, thanks a lot. I'll find a PM ID of around when we made the switch and then will add a "WHERE ID < 12345" to the query. :)

[Jake Bunce]

That works. But then there is not an easy way to update the user.pmunread field to the correct non-zero value. But that counter should automatically correct itself once the user receives a PM.

[Viper007Bond]

That works. But then there is not an easy way to update the user.pmunread field to the correct non-zero value. But that counter should automatically correct itself once the user receives a PM.

Yeah, the counter isn't a big deal, plus at least for me, it was only sent PMs that were marked as new.