Post Count Test

Discussion in 'Forum Issues' started by Shaun Mason, May 18, 2011.

  1. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    Test
     
  2. HackGolfer

    HackGolfer Administrator

    Joined:
    Jun 22, 2009
    Messages:
    7,807
    Only 258 more of those to go
     
  3. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    Actually, I found a bug in Xenforo.
     
  4. HackGolfer

    HackGolfer Administrator

    Joined:
    Jun 22, 2009
    Messages:
    7,807
    Wow that jumped you up quite a bit. That will be my excuse for the low post count....
     
  5. Drifterbub

    Drifterbub Help me hide a body?

    Joined:
    Feb 10, 2009
    Messages:
    17,173
    Featured Threads:
    1
    I think mine shot up as well.
     
  6. Iron Mickey

    Iron Mickey I'd take her out for some casadias

    Joined:
    Jul 14, 2009
    Messages:
    12,445
    wtf is that avatar? lmfao
     
    • Like Like x 1
  7. Wick36

    Wick36 Welcome to the Jungle

    Joined:
    Jul 14, 2010
    Messages:
    5,283
    That avatar is hilarious.
     
  8. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    That's why I corrected them.

    I put a bug report in the XenForo forums. You were missing 500 posts.
     
  9. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    Love your avatar.
     
  10. KnightNoles

    KnightNoles Learn to Compete

    Joined:
    Jul 6, 2009
    Messages:
    19,823
    what was the bug?
     
  11. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    In the XenForo_DataWriter model, user message count is incremented by grabbing the old value and adding one. Somewhere in the code it is possible to post without incrementing that value. So, since it never recalcs via a cron job, they never get corrected.

    So I wrote query to do it.
     
  12. KnightNoles

    KnightNoles Learn to Compete

    Joined:
    Jul 6, 2009
    Messages:
    19,823
    ahh nice, how long the query take to write
     
  13. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    20 minutes, because I tried to write a function using a cursor, then changed to just break the data up.
     
  14. KnightNoles

    KnightNoles Learn to Compete

    Joined:
    Jul 6, 2009
    Messages:
    19,823
    20 minutes; not that bad and I have no clue what that other language means

    :)
     
  15. HackGolfer

    HackGolfer Administrator

    Joined:
    Jun 22, 2009
    Messages:
    7,807
    Ever watched the TV show, "The Office"?
     
  16. Cimmy24

    Cimmy24 Candy Ass Self

    Joined:
    Jul 6, 2009
    Messages:
    8,063
    Me - "I live near Scranton, PA..."

    Person Asking Question - "Omg like the Office? Do you ever see..."

    Me - "No, they don't tape it in Scranton, but yes that Scranton, now stfu"
     
  17. Drifterbub

    Drifterbub Help me hide a body?

    Joined:
    Feb 10, 2009
    Messages:
    17,173
    Featured Threads:
    1
    Your nerd talk makes me all funny in my pants.
     
  18. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    Me breathing heavy (which is always because I'm fat) makes you feel all funny in your pants.
     
  19. Bulldog

    Bulldog Coach Richt is my Dawg!

    Joined:
    Jul 1, 2010
    Messages:
    9,041
    somehow i went down about 900 posts lol
     
  20. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    You only have 4,163 posts in the post table.
     
  21. Bulldog

    Bulldog Coach Richt is my Dawg!

    Joined:
    Jul 1, 2010
    Messages:
    9,041
    Yeah idk what that means but all i know is it dropped from 5000 to 4100 earlier today. No big deal it probably has something to do with whatever you fixed. Either that or you completely deleted the old TAE forum and i highly doubt you did that. :)
     
  22. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    I deleted the forum, but I moved the posts. Some dumbass decided to merge all the old content from TAE into one thread...I bet that is what happened.
     
  23. Bulldog

    Bulldog Coach Richt is my Dawg!

    Joined:
    Jul 1, 2010
    Messages:
    9,041
    If i knew it would have been a problem i wouldn't have done it. I just merged them because we were done for the year and were gonna start again when 12 dropped but those plans got shattered.
     
  24. Shaun Mason

    Shaun Mason Somebody you used to know.

    Joined:
    Feb 9, 2009
    Messages:
    24,887
    Featured Threads:
    5
    Haha, I didn't know it was you, honest.:)

    Anyway, it shouldn't have mattered anyway, a post is a post is a post. I think you got credited for extra when you merged them.
     
  25. Bulldog

    Bulldog Coach Richt is my Dawg!

    Joined:
    Jul 1, 2010
    Messages:
    9,041
    haha i know man no big deal i dont really care. I did notice when i merged them my post count shot up by a shit load.

    I was more just curious as to what happened.
     

Share This Page