Article ID: 116613, created on Aug 1, 2013, last review on May 11, 2014

  • Applies to:
  • Plesk 11.5 for Linux
  • Plesk 11.5 for Windows


Unable to install any application for domain, I got the following error:

Zend_Db_Table_Row_Exception: Specified column "isNonStorefrontCommercial" is not in the row


  1. login to Mysql

    [root@myhost ]# mysql -u admin -p`cat /etc/psa/.psa.shadow` psa
  2. Check if column 'isNonStorefrontCommercial' exists in Plesk database:

    mysql> desc smb_apsPackages;

    If column is absent, please check such column 'isNonStorefrontCommercial' exists in recent psa dump, and if yes - import that dump. Plesk database dumps are located under '/var/lib/psa/dumps' drectory by default. To check column existence, open the dump file with a text redactor and locate the table 'smb_apsPackages', the check the 'CREATE TABLE' command options. In case if the column is absent completely, please do the following actions:

  3. create Plesk database dump:

    [root@myhost ]# mysqldump  -u admin -p`cat /etc/psa/.psa.shadow` psa >psa.dump
  4. execute the following command:

    [root@myhost ]# mysql  -u admin -p`cat /etc/psa/.psa.shadow` psa
    mysql> alter table smb_apsPackages add isNonStorefrontCommercial int(11) DEFAULT '0';
    Query OK, 9 rows affected (0.17 sec)
    Records: 9  Duplicates: 0  Warnings: 0

Search Words


a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f 85a92ca67f2200d36506862eaa6ed6b8 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128

Email subscription for changes to this article
Save as PDF