Unread Personal Messages Count is wrong. Fix?

[littlenicki]

Hello,

for some time now  - since my board has grown big - the unread personal messages count get wrong. A member can read all his personal messages but suddenly it will again indiciate he has unread messages while actually there are none. If I run the board maintenance it will temporarily fix this issue but shortly after it is back to the proble,

Any ideas what I can look for into fixing this issue?

Thank you

[JimM]

It sounds like you might have a corrupt table or something that is getting written wrong to the database. 

What mods do you have installed? 

[littlenicki]

Hello Jim,

thank you for your reply. I have many mods installed. Running the forum maintenance will temporarily fix the problem but soon afterwards it will be back to the wrong post count.

Should I try to repair the personal message table throuh MySQL?

Thank you

[JimM]

Should I try to repair the personal message table throuh MySQL?

Yes.  That would be the next step.  Take note as to whether phpMyAdmin reports an issue with the table as well.

[littlenicki]

Hello, I tried reapring it through MySQL but it wouldn't fix it.

As it seem the error results from users having detelted unread personal messages. The unread messages are no longer in their inbox but remain as unread / count towards the unread message count.

Any idea what I could do?

Thank you

[JimM]

Does the table show and error when you check it through phpMyAdmin?  Can you copy and paste the error if it does?

[littlenicki]

Hello all, I am still desperately looking for a fix for this. Thank you

[SergeantAsh]

Just for anyone else wanting a fix for this - my cure was that I hadn't realised that I was on page 2 of 2 when viewing my PM inbox, and each time you go back to your 'Read My Messages', it automatically opens on Page 2, therefore Page 1 still had unread messages.

User error...basically