Pages

Sunday 12 August 2012

Plesk control panel error: MySQL query failed: Unknown column 'ip_dual_stack' in 'field list'

If you are getting an error like this in your Plesk login page:


ERROR: PleskMainDBException
MySQL query failed: Unknown column 'ip_dual_stack' in 'field list'


0: common_func.php3:220
        db_query(string 'SELECT login, type, ip_address, ip_dual_stack FROM sessions WHERE sess_id=""')
1: class.Session.php:420
        Session->init(string 'xx.xx.xx.xx')
2: auth.php3:194
Follow the below steps to fix the issue:

1. Login to psa database:
#mysql -uadmin -p'password' psa
2. Run the below query:
 mysql> ALTER TABLE sessions ADD ip_dual_stack VARCHAR(39) NULL;

Waiting for your feedback!!!

6 comments:

  1. Thank you very much, I was a big help.

    This is what I used for the BD conectarame:

    mysql -uadmin -p `cat /etc/psa/.psa.shadow`

    ReplyDelete
    Replies
    1. Hey Luis, I am happy that the post helped you. :)
      Yes, you can use mysql -uadmin -p `cat /etc/psa/.psa.shadow` psa to connect psa database.

      In-fact the file "/etc/psa/.psa.shadow", itself contains plesk admin password. Hence in the password field, we can directly mention the command "cat /etc/psa/.psa.shadow"

      Delete
  2. Which database do I have to select before running this command????

    ReplyDelete