-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
-
None
Hello,
I'm using phpBB v3.3.10 on my website and for multiple months now (and on older phpBB versions too) some users reports to me that they see the inbox notification badge while they have no new PM in their inbox.
After some researches in the database, I've found out that these users had some "ghosts" PM with an author_id = 0 remaining in the table forum_privmsgs_to{}
For example this user have 2 unread ghost messages, that he can't see nor open because the author_id = 0 and I don't know how it came in this situation. In the table forum_users, this user have also the column user_new_privmsg and user_unread_privmsg equals to 2.
The 2 msg_id, still exists in the table forum_privmsgs, for example the message 953637 has this data
<table name="forum_privmsgs"> |
<column name="msg_id">953637</column> |
<column name="root_level">0</column> |
<column name="author_id">0</column> |
<column name="icon_id">0</column> |
<column name="author_ip">REDACTED</column> |
<column name="message_time">1725577153</column> |
<column name="enable_bbcode">1</column> |
<column name="enable_smilies">1</column> |
<column name="enable_magic_url">1</column> |
<column name="enable_sig">1</column> |
<column name="message_subject">REDACTED</column> |
<column name="message_text">REDACTED</column> |
<column name="message_edit_reason"></column> |
<column name="message_edit_user">0</column> |
<column name="message_attachment">0</column> |
<column name="bbcode_bitfield"></column> |
<column name="bbcode_uid"></column> |
<column name="message_edit_time">0</column> |
<column name="message_edit_count">0</column> |
<column name="to_address">u_230795</column> |
<column name="bcc_address"></column> |
<column name="message_reported">0</column> |
</table>
|
|
The user that have the bug can see in his notifications also this
And when he clicks he's redirected to this :
UPDATE : We found out the author/user that wrote the message above, the account still exists and told us :
The message has been sent this night, but it has disappeared from his "Pending Sending box" and he can't see it in is "Sent box"
Thank you for your consideration.
