Sorry...

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

Page 1 of 2
  1. Feb 17, 2009 at 8:02 PM #1
    Shaggy

    Shaggy Administrator Staff Member

    Posts:
    1,783
    Likes Received:
    8
    Joined:
    Apr 23, 2004
    Location:
    Arizona
    I have no idea why we couldn't post. But it seems like its ok now.
     
  2. Feb 17, 2009 at 8:03 PM #2
    AnythingPink

    AnythingPink Well-Known Member

    Age:
    33
    Posts:
    3,400
    Likes Received:
    0
    Joined:
    Nov 18, 2007
    Location:
    Stealing your cookies, duh
    Test..
     
  3. Feb 17, 2009 at 8:03 PM #3
    Lefthanded

    Lefthanded Gentlemen of Leisure

    Posts:
    1,762
    Likes Received:
    0
    Joined:
    Apr 2, 2006
    Location:
    United States
    heroo?
     
  4. Feb 17, 2009 at 9:04 PM #4
    -Calypso-

    -Calypso- Well-Known Member

    Posts:
    57
    Likes Received:
    0
    Joined:
    Apr 23, 2006
    Here is the sql error log.
    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.
     
  5. Feb 17, 2009 at 9:21 PM #5
    clayface

    clayface Well-Known Member

    Posts:
    62
    Likes Received:
    0
    Joined:
    Feb 10, 2009
    Whoa I want your brains. :mellow:

    --------------------

    <div align="center">[​IMG]</div>
     
  6. Feb 17, 2009 at 11:03 PM #6
    Daecu

    Daecu Senior Member

    Age:
    32
    Posts:
    4,081
    Likes Received:
    0
    Joined:
    Jul 23, 2007
    Location:
    Chicago, IL
    WELL

    I was about to quote Calypso and be like... "wow, that's cool, glad to see everything's good :D"

    And then I got an IPS Error...
     
  7. Feb 17, 2009 at 11:34 PM #7
    r3m1x

    r3m1x Well-Known Member

    Posts:
    2,260
    Likes Received:
    0
    Joined:
    Jun 21, 2005
    Location:
    New York City
    Why didn't you just delete 4393970? In my tiny practice tables I just do that and SQL just kinda scans that one, then the next one, then it detects the end of the table and just continues there. I just tell my Database teacher that one entry is worth the sacrifice.




    And then when he says "What if that entry is of someone buying a private jet?" I remind him of backups. I get ----ty grades on tests.
     
  8. Feb 17, 2009 at 11:36 PM #8
    mantis33

    mantis33 Banned from GR

    Age:
    35
    Posts:
    1,724
    Likes Received:
    0
    Joined:
    Apr 14, 2006
    Location:
    The Ohio State University
    I would have just typed /fix problem. It works I swurr.
     
  9. Feb 17, 2009 at 11:45 PM #9
    Daecu

    Daecu Senior Member

    Age:
    32
    Posts:
    4,081
    Likes Received:
    0
    Joined:
    Jul 23, 2007
    Location:
    Chicago, IL
    Made my evening
     
  10. Feb 17, 2009 at 11:48 PM #10
    Neuron

    Neuron Senior Member

    Age:
    32
    Posts:
    2,505
    Likes Received:
    0
    Joined:
    Dec 22, 2007
    Location:
    US
    Hit it with a bat next time.
     
  11. Feb 18, 2009 at 3:46 AM #11
    Shaggy

    Shaggy Administrator Staff Member

    Posts:
    1,783
    Likes Received:
    8
    Joined:
    Apr 23, 2004
    Location:
    Arizona

    Trust me, I would if I could, I would if I could :huh:
     
  12. Feb 18, 2009 at 5:33 AM #12
    Faith.09

    Faith.09 Banned from GR

    Age:
    16
    Posts:
    4,849
    Likes Received:
    0
    Joined:
    Jun 11, 2004
    Location:
    http://faith-09.deviantart.com
    ------ LAND IM ON A BOAT MOTHER------ER
     
  13. Feb 18, 2009 at 5:58 AM #13
    imwellhung

    imwellhung Well-Known Member

    Posts:
    682
    Likes Received:
    0
    Joined:
    Jan 21, 2007
    lmao that was great.
     
  14. Feb 18, 2009 at 6:26 AM #14
    dinges

    dinges Senior Member

    Posts:
    5,883
    Likes Received:
    0
    Joined:
    Feb 22, 2005
    Location:
    The Netherlands
    har har har i was asleep
    hai faith <3
     
  15. Feb 18, 2009 at 8:41 AM #15
    Sanity Penguin

    Sanity Penguin My sex is on fire

    Age:
    37
    Posts:
    3,349
    Likes Received:
    0
    Joined:
    Aug 2, 2006
    Location:
    Belgium
    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
     
Page 1 of 2

Share This Page