access_log.myd error

Discussion in 'Troubleshooting' started by syan, Jan 31, 2004.

  1. syan

    syan aMember Pro Customer

    Joined:
    Apr 6, 2003
    Messages:
    39
    MYSQL ERROR:
    Can't open file: 'access_log.MYD'. (errno: 145)
    in query:
    SELECT COUNT(DISTINCT remote_addr) FROM access_log WHERE member_id=4124 AND time BETWEEN '2004-01-31 13:37:03' AND '2004-01-31 13:49:03'

    Does anyone know why this occurs? I
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
  3. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Database tables has been corrupted, it was because unexpected shutdown of the hosting server or something like that, it is not the script problem. However, attached script should fix issue anyway.
  4. syan

    syan aMember Pro Customer

    Joined:
    Apr 6, 2003
    Messages:
    39
    I tried to reinstall the script, i think it has fixed the database since those errors do not come up anymore. Should i still use this repair tool?


    - the zip file you attached might be corrupted, i wasn't able to unzip it.

Share This Page