PDA

View Full Version : Post searches fail when member has many posts


jsw
Aug 9, 2004, 10:00 AM
I just noticed that the database behind the site is now failing when looking for all posts by a member, if that member has many posts.

For example, try to find all posts by Mr. Anderson (http://forums.macrumors.com/member.php?u=2649). Doesn't work.

It seems that the user with the largest number of posts which can actually be seen is AmbitiousLemon (http://forums.macrumors.com/member.php?u=2787), although this might change by the time you read this.

I haven't tested every member, obviously, but I can't seem to see posts for members with a lot of posts, and I can seem to see them for members with fewer posts.

New problem?

Sun Baked
Aug 9, 2004, 10:36 AM
I noticed I couldn't search for a post I made when I tried yesterday either. :(

idkew
Aug 9, 2004, 09:17 PM
yeah- can't search my posts.

don't like this, i use the feature to keep up on threads i write in.....


arn?

jsw
Aug 9, 2004, 09:28 PM
Well, if you guys weren't so freaking prolific, you wouldn't have the problem, now would you? ;)

Nermal
Aug 10, 2004, 01:19 AM
Works for me, and I have 3092 posts at time of writing (much more than AmbitiousLemon at 1920).

Hemingray
Aug 10, 2004, 12:44 PM
Hm, doesn't work for me either, and I use that function a lot too. I thought it was just me, but apparently not. Weird that it's arbitrary though! Why would it work for Nermal? What's your secret? :p

edesignuk
Aug 10, 2004, 12:47 PM
Guess what!?!









Doesn't work for me either! :eek: (searching for 5339 posts :D)

Where is arn? :confused: Dead? :eek: I haven't seen him around in a long time now...

jsw
Aug 10, 2004, 04:37 PM
Maybe it has something to do with someone who has posts that occurred in a given span of time? I can't figure it out. As of now, idkew (http://forums.macrumors.com/member.php?u=2391) and moxiemike (http://forums.macrumors.com/member.php?u=3040) have the same number of posts - yet I cannot see idkew's posts whereas I can see moxiemike's. On the other hand, I can see the posts of those who joined immediately before and after idkew. Nermal proves it isn't based on post count alone.

This is all very odd, and is a bit worrisome - the database underlying MacRumors might be starting to crumble.

And arn does seem to have faded from view, at least for now. Hopefully, he'll be back in full strength soon!

jsw
Aug 10, 2004, 05:48 PM
Hey, whatever it was, that last crash and repair a few minutes ago fixed it, at least for the few members I checked.

It takes forever as of right now to get posts by some (like Mr. Anderson (http://forums.macrumors.com/member.php?u=2649)). But it works again!

idkew
Aug 10, 2004, 10:37 PM
post search up and running for me.

:)

looks like you are bak to normal, JSW, also.
:D

gwuMACaddict
Aug 11, 2004, 09:34 AM
glad i don't have to worry about that... brevity is the soul of wit, fellas ;) :D

Hemingray
Aug 11, 2004, 10:41 AM
Yup, it's working for me now too. Yay! Thanks to whoever fixed it. :) Arn? That you?