K Um

Discussion in 'GR Classic Archive' started by johndapunk FTW, Oct 5, 2006.

Thread Status:
Not open for further replies.
  1. johndapunk FTW

    johndapunk FTW Senior Member

    Age:
    35
    Posts:
    2,513
    Likes Received:
    0
    Joined:
    Jan 19, 2006
    Location:
    Palm Beach
    i know there is like 40 topics with this, but you closed all of them, therefor leaving no topic for me to give a possible solution.

    It says "ibf_sessions is full". Ok then. First get into your cpanel account, and go to your mySQL Manager (phpmyadmin, w/e you got.) Then start deleting multiple inputs in the "ibf_sessions" table. With the number of users you have entering the site a day, it's a wonder this hasnt happened already.
     
  2. zabiMARU.

    zabiMARU. Well-Known Member

    Posts:
    1,903
    Likes Received:
    0
    Joined:
    Jul 7, 2005
    Location:
    Cleveland, Ohio
    If they closed them, they closed them for a reason.
     
  3. Scooby.05

    Scooby.05 Senior Member

    Age:
    40
    Posts:
    6,350
    Likes Received:
    0
    Joined:
    Jul 28, 2005
    Location:
    Ohio
    We mainly closed them because it was just a repeat of the others. Thanks for this john, I'll forward this to Shaggy.
     
  4. Shaggy

    Shaggy Administrator Staff Member

    Posts:
    1,783
    Likes Received:
    8
    Joined:
    Apr 23, 2004
    Location:
    Arizona
    Ok, how do I starte deleting just the imputs of seesions and not drop the whole table?
     
  5. GFX Resource

    GFX Resource Well-Known Member

    Posts:
    120
    Likes Received:
    0
    Joined:
    Jun 9, 2006
    we have an admin who cant admin?
     
  6. Logicaly

    Logicaly Senior Member

    Age:
    44
    Posts:
    4,253
    Likes Received:
    0
    Joined:
    May 17, 2005
    Location:
    Bay Area, California
    Theres no need for a comment like that. Shaggy is more experienced with VB I believe, so yes, hes capable of admining.
     
  7. UV Street

    UV Street Senior Member

    Posts:
    1,517
    Likes Received:
    0
    Joined:
    May 7, 2005
    you could go into the acp -> sql -> sql toolbox and look at all the sessions and run the query

    That will delete every session ID in the SQL forcing all the unused ones out and the active members to stay logged in. If you can run that query every hour (automatically) it should help.
     
  8. johndapunk FTW

    johndapunk FTW Senior Member

    Age:
    35
    Posts:
    2,513
    Likes Received:
    0
    Joined:
    Jan 19, 2006
    Location:
    Palm Beach
    Yeah, either manually delete the rows in the phpMyAdmin (Select the table, then find the "Browse" button, click it, then find the delete button.

    Or you can use code (like above).
    Code:
    DELETE from ibf_sessions LIMIT( START, END );
    
    where START and END is the starting row and the ending row
     
  9. BrokenFaith

    BrokenFaith Well-Known Member

    Posts:
    2,380
    Likes Received:
    0
    Joined:
    Sep 1, 2005
    k um .. wow read that with no spaces =O! haha but uhh, PHPMYADMIN is pretty easy shagster, once your into your table, just start deleteing =D
     
  10. Shaggy

    Shaggy Administrator Staff Member

    Posts:
    1,783
    Likes Received:
    8
    Joined:
    Apr 23, 2004
    Location:
    Arizona
    Well I know phpadmin, just not deleting processes in tables. Still learning everything. Well it seemed to wrok, not seeing any errors anymore.
     
  11. johndapunk FTW

    johndapunk FTW Senior Member

    Age:
    35
    Posts:
    2,513
    Likes Received:
    0
    Joined:
    Jan 19, 2006
    Location:
    Palm Beach
    Gj, all seems to be working in proper order :)
     
  12. Zohair

    Zohair Formerly zohBOT

    Posts:
    6,128
    Likes Received:
    0
    Joined:
    Dec 18, 2005
    Location:
    Cave
    Yay!! John ftw + shaggy! Thanks for solving this :wub:
     
  13. .ZERO

    .ZERO Well-Known Member

    Posts:
    2,220
    Likes Received:
    1
    Joined:
    May 28, 2006
    Location:
    #gamerenders
    i'm still getting it on a few threads now and again, but alot better than it was
     
  14. Shaggy

    Shaggy Administrator Staff Member

    Posts:
    1,783
    Likes Received:
    8
    Joined:
    Apr 23, 2004
    Location:
    Arizona
    I just restarted mysql, so it should be fine for a well.
     
  15. UV Street

    UV Street Senior Member

    Posts:
    1,517
    Likes Received:
    0
    Joined:
    May 7, 2005
    =< lol


    Thanks for fixing it Shaggy GR's up time was better than average today
     
Thread Status:
Not open for further replies.

Share This Page