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;

Plesk Upgrade failed : `Cannot load from mysql.proc. The table is probably corrupted`

Error while Upgrading Plesk,
ERROR 1548 (HY000) at line 67: Cannot load from mysql.proc. The table is probably corrupted

1. Make sure mysql tables are not corrupted. You can use mysqlcheck  utility to do so.
mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow`

If everything looks fine here, go for alternative solutions like repair table (repair table mysql.proc) or;
enable mysql debug log and find the exact error in logs.

Also please make sure that you have checked mysqld.log file,
if you find something like "Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64)."  in mysqld.log file, then you need to ad the missing column in proc table.

Login to mysql and run:
mysql> alter table proc change comment comment text;

Plesk Panel Error:- Unable to obtain secret key for passwords encryption.

Following error noticed while opening Plesk Panel:-

ERROR: PleskFatalException
Unable to obtain secret key for passwords encryption.

0: String.php:330
        Plesk_Base_Utils_String::getCryptKey()
1: common_func.php3:3453
        get_failure_redirect_url(string 'failure_redirect_url')
2: auth.php3:191

Solution:-

Running the below command in server will fix it:-

/usr/local/psa/admin/sbin/encrypt_keygen

SWKeyExFatalError : Repository is not opened

Plesk Gives error like below:-

ERROR: SWKeyExFatalError
Repository is not opened

0: common_func.php3:4759
    of_get_key_by_product(string 'plesk-unix')
1: common_func.php3:4759
    getPleskKey()
2: common_func.php3:4834
    getKeyProp(string 'demo')
3: auth.php3:88

Or you will see error "Could not open Repository at "/etc/sw/keys": Cannot open file" on browser.

The solution to this error is to correct the permission of requires files/folders:-

Change it like:-

~# cd /etc/sw
~# chown -R psaadm keys
~# /etc/init.d/psa restart

Error: Unable to remove domain: Domain domain.com is temporarily turned off for backup/restoring and is not currently available.

Error Description:-
While deleting the domain from Plesk Panel, it fails with below error:-

Error: Unable to remove domain: Domain domain.com is temporarily turned off for backup/restoring and is not currently available.


Cause and Resolution:-
1. Check if any backup task is running in the server. If so wait for it completion.

2. No backup is running now, but still the same issue. Now check if the domain is listed under psa.suspend_handler_history. If so, then delete the entry firts from this table.

3. If stil the issue persists, then check the status of domain in domains table. It should be 0 (zero). If its other than 0 (zero) then update it to , and then delete the domain.

------
mysql> select id, name, statu from domains where name like "%domain.com%"\G;
*************************** 1. row ***************************
             id: 1001
           name: domain.com
         status: 4
     
mysql> update domains set status=0 where id=1001;      
------

Plesk Panel- horde webmail sending attachment as links !!!

Horde sends attachment as:-
1. a link
2. a physical file

If you want the attachment as a link, then you need to change the line in "/usr/share/psa-horde/imp/config/conf.php" file like below:-

$conf['compose']['link_attachments'] = true;

else, on the other hand it should be like:-

$conf['compose']['link_attachments'] = false;

Plesk FileManager fail with error:- Internal error: Unable to logon user (WIN-TQSW234RET\user): (1331) Logon failure: account currently disabled. (Error code 1)

Error received in Plesk Panel while navigating through:- 

Plesk Home > domain.tld >  Open in Control Panel > File Manager > Internal error: Unable to logon user (WIN-Z4werERT\user): (1331) Logon failure: account currently disabled. (Error code 1)

Resolution:-

Navigate yourself to Computer Management > 
Local Users and Groups > 
Users (There find the user "user" and then > 
open properties window for this user > 
General tab( here uncheck Account is disabled check-box) >
Ok.

Mail management settings are not available in Plesk.

You can enable the settings at:

1. Login to Plesk Panel.
2. Now navigate to Tools & Settings.
3. Go to the "Mail Server Management" link.
4. Now tick the option "Enable mail managemnet functions in panel."

ERROR while trying to upgrade MySQL password format for Billing user.

Upgrade failed with below error:

ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

ERROR while trying to upgrade MySQL password format for Billing user
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

Such error occurs if the password for "billing" user is missing in the psa database. To fix it,

------

#insert into `user` (Host,User,Password) values ('localhost', 'billing', 'password');

#echo 'SET PASSWORD FOR "billing"@"localhost" = PASSWORD("password")'|mysql -uadmin -p`cat /etc/psa/.psa.shadow`

#echo 'GRANT ALL PRIVILEGES ON `billing`.* TO "billing"@"localhost";' | mysql -uadmin -p`cat /etc/psa/.psa.shadow`

------

Starting psa... Unable to create 'dirty' flag.

Starting of psa Failing with below error:

# /etc/init.d/psa start

Starting psa... Unable to create 'dirty' flag (/usr/local/psa/tmp/components_dirty_flag): Permission denied
System error 13: Permission denied

Solution:

# chmod 777 /usr/local/psa/tmp

Plesk Internal error: Specified column "custom" is not in the row!!!

Here is the Fixxxxx :)

mysql> ALTER TABLE `psa.Subscriptions` ADD `custom` enum('true','false')  NULL default 'false'; 

mysql> ALTER TABLE `psa.Subscriptions` ADD `uuid` varchar(36)  NULL;

Plesk control panel error: Unable to find service node for web service on domain with id=x !!!

Just a simple query to fix the error: 

mysql> select name from psa.domains where id=x\G;
           name: abcdefg.com 

mysql> update psa.domains set htype='none' where name="abcdefg.com";

:)

Unable to start named service!!!

While starting named, I am getting the below error:

# /etc/init.d/named start
Starting named:
Error in named configuration:
zone 0.0.127.IN-ADDR.ARPA/IN: loaded serial 200987622
zone 0.113.162.in-addr.arpa/IN: loaded serial 13876565009
zone xyz.com/IN: loaded serial 1330747140
zone abcde.com/IN: loaded serial 11235678848

Steps to solve the issue: 

# cd /var/named/chroot/etc

# mv  named.conf named.conf.bak
# cp named.conf.default named.conf
# for x in `ls`; do /usr/local/psa/admin/sbin/dnsmng update $x;   done;/etc/init.d/named restart

Try it !!! :)

Which database provider Plesk is using in My Windows server ???

Check the following parameter in regedit.exe:

Windows x86:

HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config

Windows x64:

HKEY_LOCAL_MACHINE\SOFTWARE\wow6432node\PLESK\PSA Config\Config

Here check the value against   "PLESK_DATABASE_PROVIDER_NAME". This will give you the database provider name( JET, MSSQL or MySql).

:)

Unable to satrt psa due to "psa dead but subsys locked" error !!! :(

To fix the issue perform the following steps:

~# /etc/init.d/psa status
psa dead but subsys locked

~# rm -f /var/lock/subsys/psa

Now start psa using below command:

~# /etc/init.d/psa start

Issue fixed :)

Horde is not showing inbox messages!!!

Following steps will solve the issue:

1) Take the backup of horde database (/hordebackup.sql).

mysqldump -uadmin -p'cat /etc/psa/.psa.shadow' horde > horde_backup.sql

2) Run the below mysql queries for horde database.

mysql> select * from horde_prefs where pref_uid='abc@xyz.com' and pref_name='sortpref';

mysql> delete from horde_prefs where pref_uid='abc@xyz.com' and pref_name='sortpref';

Issue fixed :)

Plesk panel is showing blank page !!!

Getting blank pages while clicking on FileMnager,  FTP,  DNS Settings etc.

1. Login to psa database.

 #mysql -uadmin -p'cat /etc/psa/.psa.shadow' psa

2 Run the below query:

 mysql>ALTER TABLE sessions CHANGE data data MEDIUMBLOB; 


Waiting for your feedback!!! 

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!!!

How will I install Microupdates in my Linux Plesk server ?

To install microupdates:

/usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base

You can check the installed microupdates using the below command:

 

cat /root/.autoinstaller/microupdates.xml

Forgot my Plesk admin Password !!!

Login to your server and use the below commands in your command prompt:

Windows Plesk 8.x,9.x, 10.x, 11.x:

C:\> cd %plesk_bin%
C:\Program Files (x86)\Parallels\Plesk\admin\bin>plesksrvclient.exe -get

Linux Plesk 8.x,9.x:

#cat /etc/psa/.psa.shadow

Linux Plesk 10.x,11.x:

#/usr/local/psa/bin/admin –show-password