View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004282||website||website||public||2010-04-22 09:50||2010-05-10 01:37|
|Target Version||Fixed in Version|
|Summary||0004282: Private Message Notifications no longer working for CentOS Fora|
|Description||Some time on about Tuesday April 20, 2010 Private Message Notifications stopped working for the CentOS Fora. I use notifications extensively on the fora and have gotten no new notifications for the past two days, despite the presence of numerous new posts and topics that should have generated notifications. Have tried changing notification method to Email, temporarily suspended, and back to PM; also editing Notifications, adding and deleting, to no effect. Old messages remained in the inbox after the problem started until they were deleted. No new messages have appeared, nor does sending a PM appear to work.|
|Additional Information||The problem has been confirmed by toracat. Forum thread on the issue:|
|Tags||No tags attached.|
|Notifications do work when Notification method is set to "email".|
I deleted a bunch of message from the private message queue.
mysql> DELETE from xoops_priv_msgs WHERE read_msg = '0' AND msg_time < 1271656470;
Query OK, 427572 rows affected (1 min 22.33 sec)
Let me know if notifications begin to work.
|I see posts on the fora that should have generated PM notifications after the time of the delete, but still nothing in my queue. An attempt to send a PM still returns "Error" "None" as it did previously. Still seems broken.|
|I have tested this by attempting to send Phil (prschaffner) a PM on 2010-04-30 which, in the light of note 11203, has not been received . . .|
I recently received an e-mail message from a forum member in which it was mentioned that a PM had been sent to me.
On checking, I saw that the message had not been delivered.
Hence I deduce that the system is still broken.
mysql and/or xoops kiddieware issue.
msg_id's start at 0 and go to 16777215, at which point mysql inserts fail. WHY WHY WHY @ 24bits?
I deleted all private messages, tested sending PMs again and all is well.
Someday when the centos website is designed...
|nothing to add. toy systems? I'm sure this problem is present in numerous other areas as well.|
First of all, thanks for your effort to rectify the issue. I am reopening this report because Phil indicated in the forum thread that PM was still not working and I could confirm it. I attempted to send a PM for testing and got the error:
I tried twice and got that same error message both times. Any ideas?
|... Or is that saying "Errors" were "None" ? It looks as if that is the case.|
|I will wait for Phil's response. If/when it is confirmed by him that he got the test PMs, I will ask you to close the report (once again).|
|toracat, please send me a test PM.|
|A test PM sent to you.|
Message sent by toracat was not received by me.
Hence this functionality is still broken.
Did you folks logout and log back into the centos.org website? Persistent connections might be causing the excessive value to be used when xoops goes for the next message ID.
centos.pm.png (72,724 bytes)
centos.pm.png (72,724 bytes)
|I uploaded a screen shot of a successful PM send and the resulting PM opened...|
I hope this is a reopen. I'll confirm the issue persists.
priv_msgs table has an auto_increment on msg_id.
This drops all messages and resets the auto_increment back on it's way to 24bits...
truncate table xoops_priv_msgs;
|Lets try this again. :)|
|2010-04-22 09:50||prschaffner||New Issue|
|2010-04-22 10:18||prschaffner||Note Added: 0011167|
|2010-04-30 19:52||donavan||Note Added: 0011199|
|2010-05-02 11:41||prschaffner||Note Added: 0011203|
|2010-05-02 13:28||AlanBartlett||Note Added: 0011204|
|2010-05-07 00:58||AlanBartlett||Note Added: 0011230|
|2010-05-09 00:20||donavan||Note Added: 0011238|
|2010-05-09 00:21||donavan||Note Added: 0011239|
|2010-05-09 00:21||donavan||Status||new => resolved|
|2010-05-09 00:21||donavan||Resolution||open => fixed|
|2010-05-09 15:15||toracat||Note Added: 0011240|
|2010-05-09 15:15||toracat||Status||resolved => feedback|
|2010-05-09 15:15||toracat||Resolution||fixed => reopened|
|2010-05-09 15:17||toracat||Note Added: 0011241|
|2010-05-09 15:20||toracat||Note Added: 0011242|
|2010-05-09 15:21||AlanBartlett||Note Added: 0011243|
|2010-05-09 15:28||toracat||Note Added: 0011244|
|2010-05-09 15:41||AlanBartlett||Note Added: 0011245|
|2010-05-10 01:04||donavan||Note Added: 0011247|
|2010-05-10 01:04||donavan||File Added: centos.pm.png|
|2010-05-10 01:05||donavan||Note Added: 0011248|
|2010-05-10 01:10||donavan||Note Added: 0011249|
|2010-05-10 01:10||donavan||Status||feedback => confirmed|
|2010-05-10 01:37||donavan||Note Added: 0011250|
|2010-05-10 01:37||donavan||Note Added: 0011251|
|2010-05-10 01:37||donavan||Status||confirmed => resolved|
|2010-05-10 01:37||donavan||Resolution||reopened => fixed|