The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Error : 1114 The table phpbb_sessions is full

Discussion in 'Database Discussions' started by billau, Jul 30, 2004.

  1. billau

    billau Well-Known Member

    Joined:
    Dec 24, 2003
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Brisbane, Australia
    The following error message will be shown on accessing the phpBB forum index page

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

    Error creating new session

    DEBUG

    SQL Error : 1114 The table phpbb_sessions is full

    INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('544c13e2eea831bb6402a4b35f78e96a', -1, 1041341439, 1041341439, '7f000001', 0, 0)

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

    Reason:

    When a user views the index page, a session_id is created, and a new row is inserted into the sessions table. But then, the user decides to open up a new index.php, without using their existing session, thus creating a new row in the database. By doing this, the limit set by MAX_ROWS can soon be reached, bringing on the table is full error.

    Fix:

    Login to mysql server and select the phpBB database and execute the following

    Quote:
    DELETE FROM phpbb_sessions;
     
Loading...

Share This Page