I am back
Yesterday, I run
UPDATE
mybb_users SET
unreadpms = '0'
soon after, mybb show zero unread PMs on header
Today, I logged into board to find + 300 unread PMs again
Where does mybb store this magic number !!?
Please try sending yourself one PM and reading it. This should auto-correct itself once you do.
I sent myself a PM
Unfortunately, this disnot fix the issue !!
Maybe I screwed something in the database, beacause, I run several queries desperately trying to fix the problem
You could also try:
UPDATE `mybb_privatemessages` SET `status` = '1' WHERE `status` = 0 AND `folder` != 2;
(2010-12-14, 03:10 PM)doylecc Wrote: [ -> ]You could also try:
UPDATE `mybb_privatemessages` SET `status` = '1' WHERE `status` = 0 AND `folder` != 2;
Thanks doylecc, I forgot the status in my initial query with the readtime. Too many ways to do the same thing. The status is really redundant, since if there isn't a readtime yet, then it hasn't been read, if there is, it has.
@doylecc
@Dylan M.
Thanks a lot for help
Now, there is no unread Pms info on header
Inside inbox, all PMs are listed with read icon
