help - wierd errors. database possibly corrupt?

Discussion in 'Troubleshooting' started by ronniead, Jan 29, 2009.

  1. ronniead

    ronniead Member

    Joined:
    Dec 20, 2007
    Messages:
    118
    Hey,

    Okay, so I'm getting some pretty full on errors...not really sure what to do. I think my database may be corrupt (and well...haven't backed up for about a month).

    I'm getting different errors in various places (member.php,admin/index.php etc)


    Code:
    WARNING: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in line 101 of file bruteforce.inc.php
     
    And

    Code:
    WARNING: mysql_query() [function.mysql-query]: Unable to save result set in line 2949 of file mysql-zend.inc.php-bin
    
    And...

    Code:
    MYSQL ERROR:
    Table './blackbox_amember/amember_failed_login' is marked as crashed and should be repaired
    in query:
    INSERT INTO amember_failed_login (ip, login_type, failed_logins, last_failed) VALUES ('69.114.216.132', '2', 1, 1233237161)
    
    and also getting this error:


    Code:
    MYSQL ERROR:
    
    in query:
    SELECT COUNT(*) FROM amember_error_log WHERE time BETWEEN 20090129000000 AND 20090129235959
    Anyone have an idea what I should do!??
  2. ronniead

    ronniead Member

    Joined:
    Dec 20, 2007
    Messages:
    118
    fixed

    Went into phpMySql and used the repair functions on the table... and now everything back to normal...

    I need to implement some way of auto backups...

Share This Page