Pages

Wednesday 3 September 2014

Unknown column 'owner' in 'where clause'

Plesk Websites & Domains tab not accessible, Error noticed:

Error message or request description : When you attempt to open Websites & Domains tab:
Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'owner' in 'where clause'
Message         SQLSTATE[42S22]: Column not found: 1054 Unknown column 'owner' in 'where clause'
File    Pdo.php
Line    234
Type    Zend_Db_Statement_Exception
This is because column `owner` missing from psa.longtasks table.
So to add this column run the below query:

1. Login to psa (mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa )

2. Run: 
mysql> alter table longtasks add owner int(10) unsigned;

No comments:

Post a Comment