mysql error

Discussion in 'PSA 2.0 Troubleshooting and Questions' started by Q8Provider, Apr 16, 2002.

  1. Q8Provider

    Q8Provider Guest

    Hi,,

    One from my clinte install vBulletin after i reboot my server the vBulletin working fine after that in few min he get error like that:


    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON
    userfield.userid=user.userid WHERE user.userid='1'
    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016


    i restart the psa and the MySQL working fine the problem only in this database ?

    any idea ?
     
  2. netman

    netman Guest

    1. Do you have free disk space on the partition where mysql databases are located?
    2. May be mysql marked table "user" as "crashed table". To repair it start mysql "/usr/local/psa/mysql -uadmin -p`cat /etc/psa/.psa.shadow`", change database "use <db_name>" (put correct vBulletin database name) and execute "repair table user" command from here.
     
  3. Q8Provider

    Q8Provider Guest

    Thanks its workinh fine now
     

Share This Page