Sorry...

Discussion in 'Spam Heaven' started by Shaggy, Feb 17, 2009.

  1. I checked the ibf_posts table and the last indexed post id (pid) was 4393970. For some reason the sql was seeing the latest pid as 4393971 therefore any new posts that were suppose to fall in line were being refused and returning the IPS Driver Error. What i did was change the pid index to BIGINT(20) and then back to INT(10), this forced the sql to recount the actual post indexes. From there the sql started returning the correct pid and allowing the new posts again. Some of you may have noticed that the site went down for a few minutes, this is due to the sql counting +4.3 million posts 2 times over, sorry for that but it had to be done. Something caused this, I don't know what yet but I will do some more poking around and see if anything jacked up jumps out at me.
    [/b][/quote]

    I was so gonna say that
    [/b][/quote]
    And I'm the owner of GR. Go figure.
     
  2. Sanity Penguin

    Sanity Penguin My sex is on fire

    Age:
    37
    Posts:
    3,349
    Likes Received:
    0
    Joined:
    Aug 2, 2006
    Location:
    Belgium
    Yeah, go figure
     
  3. .ZERO

    .ZERO Nigga wit a PSD

    Age:
    32
    Posts:
    2,220
    Likes Received:
    1
    Joined:
    May 28, 2006
    Location:
    #gamerenders
    L2NOT BREAK DATABASES >:3
     
  4. dementia

    dementia Well-Known Member

    Posts:
    6,244
    Likes Received:
    0
    Joined:
    May 21, 2005
    Location:
    Denver
    Tell it to Llama, all the IPS driver errors and stuff that were going on when Llama left are caused via the sql on GR, so him or BiG_DaVe are the two who messed it up.
     

Share This Page