We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Messages Notifications Won't Reset | Forum
Team
"2" and "3" you can leave put as 2 stands for the person who received the message has read it - and 3 stands for both parties have read it. But 1 stands for only the sender of the message has read it
so 2 means the recipient has read the message and 3 means both the sender and the recipient have read it?isn't it kinda contradictory?if the recipient has read the message (option 2) then logically both the sender and the recipient have read itI'm not the one who developed this plugin. So I can only safely assume those numbers are there for a reason."2" and "3" you can leave put as 2 stands for the person who received the message has read it - and 3 stands for both parties have read it. But 1 stands for only the sender of the message has read it
If you follow that small guide I wrote, the issue goes away for good. The only way that I can think of that the devs of this plugin can fix this issue is by writing a string of code that auto-deletes all "mailbox_chat" messages permanently from the database as that is where the issue lies. But in doing so, you would lose all those messages via the IM chat.
So your next best thing, if you do not want to lose ALL the mailbox_chat (IM chat) messages, you will need to do some clean-up on your database and follow that guide I wrote up. It will fix the issue and will not get rid of ALL the IM messages you may have.
http://www.oxwall.org/forum/topic/29195?page=3#post-127021
So, basically, you need to run update query:
UPDATE ow_mailbox_conversation
SET `read`='3'
WHERE `subject`='mailbox_chat_conversation' AND `read`<>'3'
UPDATE: Strangely enough, it really works :)
Thanks to all the users, especially Hybrid82 on the help!
Guys, I have reported back to the developers. I'll get back with the reply from them or a fix asap.and
Wait for the fix, please
I see two post by Ross responding to this issue. The fix your using could be or not be the real fix for the plugin even thoe your problem has been resolved. In regards to your comment "no information has been published" well I see at the top of this page "Messages Notifications Won't Reset" so this issue has been published to everyone.
Also take in mind that its Christmas Holidays...so things might be a bit slow! But be assured that a REAL fix will be posted by Ross as soon as they get it done or if Ross confirms your fix as the TRUE fix to use.
Please be patient, there working on it as reported by Ross!
Wilson
sorry to hear that
what was the message you got when you ran the "my" query?
do you have any results when you run:
SELECT * FROM ow_mailbox_conversation
WHERE `subject`='mailbox_chat_conversation' AND `read`<>'3'
mysql> SELECT * FROM ow_mailbox_conversation WHERE `subject`='mailbox_chat_conversation' AND `read`<>'3' ;
+----+-------------+----------------+---------------------------+------+---------+--------+------------------+-------------+---------------------------+------------------------------+---------------+----------------------+
| id | initiatorId | interlocutorId | subject | read | deleted | viewed | notificationSent | createStamp | initiatorDeletedTimestamp | interlocutorDeletedTimestamp | lastMessageId | lastMessageTimestamp |
+----+-------------+----------------+---------------------------+------+---------+--------+------------------+-------------+---------------------------+------------------------------+---------------+----------------------+
| 7 | 19 | 2 | mailbox_chat_conversation | 1 | 0 | 1 | 0 | 1419409848 | 0 | 0 | 0 | 0 |
| 8 | 23 | 26 | mailbox_chat_conversation | 1 | 0 | 1 | 0 | 1419501148 | 0 | 0 | 76 | 1419503304 |
+----+-------------+----------------+---------------------------+------+---------+--------+------------------+-------------+---------------------------+------------------------------+---------------+----------------------+
but do not tell me what it means :D
WHERE `subject`='mailbox_chat_conversation' AND `read`<>'3'
Nvm Inside.. just to try i've gave again the command.. and now worked.. probably i've made some mistakes before... thank you for the help ;)
@hybrid82testing :)
So, basically, you need to run update query:
UPDATE ow_mailbox_conversation
SET `read`='3'
WHERE `subject`='mailbox_chat_conversation' AND `read`<>'3'
UPDATE: Strangely enough, it really works :)
Still no update fix to the plug in?
Glad it helped but real kudos goes to Hybrid82
@DeFender
Make sure to get back with the results :)
@Fred
Try the query above, until they come up wit a solution
The lack of feedback from the developers lately has me wondering if they think they've fixed the problem. I have installed their "fix" and I just got a new message on my site and after responding to it, the indicator still showed the new message waiting. I don't wish to keep manipulating my SQL database since it clears ALL new message indicators including the legitimate ones people may be relying on to inform them of new messages.That's because the fix has NOT been posted by Ross or confirmed that the temp fix your using is the TRUE fix...but be assured they are working on it!
Wilson
