| Dec 30, 2006 @ 1:24 AM |
-1 messages in the mailbox
|
|
null_geodesic
Posts: 684
|
There appears to be something wrong with the mail counter. My inbox is empty, yet the system claims I have -1 messages in my inbox.
|
|
  |
|
| Dec 30, 2006 @ 1:52 AM |
-1 messages in the mailbox |
|
T_i_m
Posts: 809
|
Try sending yourself mail and then deleting it.
|
| |
|
| Dec 30, 2006 @ 8:25 AM |
-1 messages in the mailbox
|
|
null_geodesic
Posts: 684
|
I really don't mind -1 at all. I was just reporting it because it indicates a bug in the MD code base.
|
|
| |
|
| Dec 31, 2006 @ 5:03 AM |
-1 messages in the mailbox |
|
Palomino
Posts: 7,635
|
Dang! I hope this doesn't happen to me! I keep seeing these "bugs" in the email system since they pruned the mailboxes! 
|
| |
|
| Jan 1, 2007 @ 5:32 PM |
-1 messages in the mailbox
|
|
null_geodesic
Posts: 684
|
It's probably harmless. I'm going to guess that the number of mails each user has listed (e.g. by letting the mouse hover over the "mail" link in the banner) is a number in the user's "main table", something like:
select mail_number from user_table where userID=1234;
and that this number gets updated whenever you delete the email or are sent an email.
But when it comes time to actually _read_ the email, the number is probably generated by counting the actual number of returns in the mail table:
select count(messages) from user_mail where userID=1234;
I've never programmed a web app anywhere near as big as MD, but I'm guessing you'd want to do this seemingly redundant record keeping because it's much less expensive to select from one table than it is for two tables. Plus, I'm sure all that count()'ing is expensive too. It prolly isn't a big deal if you have like 100 people, but if you have 1000's of people, then opening two tables and performing a count() operation each and every time someone loads a page (since the "mail" link is on the header banner of each MD page) would be really taxing on their database.
That's my guess, at least.
Null!
|
|
| |
|
| Jan 1, 2007 @ 9:43 PM |
-1 messages in the mailbox |
|
beckyiv42000
Posts: 14,576
|
null???  you lost me at -1 up there^^^
|
| |
|
| Jan 2, 2007 @ 2:05 PM |
-1 messages in the mailbox
|
|
mdTech2
Posts: 119
|
I have -1 messages
I figured you would have square root of -1 messages. Kidding aside, are you still having this problem?
|
|
| |
|
| Jan 5, 2007 @ 12:34 AM |
-1 messages in the mailbox |
|
null_geodesic
Posts: 684
|
LOL! I assure you, it wasn't imaginary!
It seems to have gone away. I did see someone with -1 blogs tonight though. Dangit. I can't remember who.
I should've made a note of who it was. Next time I see something like that, I'll report the offending URL immediately. I'll try going back to everyone I emailed tonight and see if I can catch it again.
|
| |
|
| Jan 5, 2007 @ 2:34 AM |
-1 messages in the mailbox
|
|
SunBabe
Posts: 12,279
|
Heck, I see negative blogs all the time 
|
|
| |
|
| Jan 5, 2007 @ 6:21 AM |
-1 messages in the mailbox |
|
T_i_m
Posts: 809
|
I saw a poster in the forums and next to his message his post count was listed as zero. That was in a thread that was reported as abuse and is now gone.
|
| |
|
| Jan 15, 2007 @ 10:32 AM |
-1 messages in the mailbox
|
|
null_geodesic
Posts: 684
|
Here we go. Consider Orphes1's blog. As of:
$ date
Mon Jan 15 10:31 AM
He has 3 blogs:
Scammers and fighting back
This just about made my day!!!
A nice day!
But on the blog tab it says he only has 2 blogs.
|
|
| |
|
| Jan 15, 2007 @ 12:53 PM |
-1 messages in the mailbox |
|
mdTech2
Posts: 119
|
He has 3 blogs...But on the blog tab it says he only has 2 blogs
I guess he was in the process of deleting blogs (not sure why people do that...we have plenty of room....) and the counts were off. I just checked a few minutes ago and they match again. Since you're a programmer too I'll explain: some queries are too expensive to do with every page load. If the data changes less often than it is read,
we may take a few minutes to update it.
How's your mailbox count? Still (-1)^0.5 messages?
|
| |
|
|