[RESOLVED] SQL Error
Results 1 to 4 of 4

Thread: [RESOLVED] SQL Error

  1. #1
    Join Date
    Oct 2000
    Location
    graham, tx, us
    Posts
    7,156

    Resolved [RESOLVED] SQL Error

    Anyone see this before.

    phpBB : Critical Error

    Error creating new session

    DEBUG MODE

    SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI'. (errno: 145)

    INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('3bf7af01fc9b400ec21bbf75b38ab472', -1, 1189907200, 1189907200, '445a7905', 0, 0, 0)

    Line : 188
    File : sessions.php

    How does one recover from this? Is there a program that will restore normal ops? Is this just a corruption or a hacking??

    This is on a friends site and I know next to nothing about this.

  2. #2
    Join Date
    Apr 2000
    Location
    Sheboygan, WI
    Posts
    53,391
    Maybe this will help out.
    http://www.phpbb.com/community/viewtopic.php?t=259967
    Then add this.
    (errno: 145) = Table was marked as crashed and should be repaired.

  3. #3
    Join Date
    Apr 2005
    Posts
    551
    show this to your 'friend'

    MySQL Error - Can't open file: 'something.MYD'. (errno: 145)

    The following error may occur with a MySQL database table:

    Can't open file: 'TableName.MYD'. (errno: 145)

    This error usually means the 'TableName' table has become corrupt. From our experience, it appears the error commonly affects a table used for storing sessions and may occur the webs site/database has used up all allocated disk space. Additional disk space will normally need to be allocated.

    Also, run the following SQL query using phpMyAdmin:

    REPAIR TABLE TableName

    This will often fix the table.
    SANITY IS JUST A STATE OF MIND

  4. #4
    Join Date
    Oct 2000
    Location
    graham, tx, us
    Posts
    7,156
    The corrupted site is now back up. Thanks for the help.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •