Product:
Search Type:

I get the following error during login to Plesk CP: "ERROR: Unable to query: Can't find file: 'misc.MYD' (errno: 2)"

Article ID: 996 
Last Review: May,16 2006
APPLIES TO:
  • Plesk 7.5.x Reloaded

RESOLUTION


Full error message:

ERROR:
Unable to query: Can't find file: 'misc.MYD' (errno: 2)

0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Can't find file: 'misc.MYD' (errno: 2)")
1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc")
2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout")
3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()

Since Plesk 7.5.3 'psa' database is stored in InnoDB format. Make sure that InnoDB format is enabled. Check if the following line exists in /etc/my.cnf:

innodb_data_file_path=ibdata1:10M:autoextend

If it doesn't, add it into the [mysqld] section and restart MySQL.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields