Unable to install application or open domain menu in Plesk: Table 'apsc.tablename' doesn't exist

Daniel Yordanov

Updated April 16, 2024 16:33

Plesk for Windows Plesk for Linux kb: technical

Applicable to:

Unable to install applications like Prestashop in Subscriptions > example.com > Create Website > More Apps
Domains > example.com cannot be opened:

PLESK_ERROR: ODBC error #42S02: [ma-3.0.8][5.5.64-MariaDB]Table 'apsc.aps_package' doesn't exist.
The "apsc" database contains less then 23 tables:

# plesk db
use apsc
MariaDB [apsc]> show tables
+------------------------------------+
| Tables_in_apsc |
+------------------------------------+
| meta_info |
+------------------------------------+
There are no backups of the apsc database in /var/lib/psa/dumps/ folder.

Missing tables in the apsc (application service controller) database of Plesk.

Linux

Login to the server via SSH.
Restore an empty apsc database:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin apsc < /usr/local/psa/bootstrapper/pp18.0.21-bootstrapper/db/apsc_mysql_db.sql

Windows

Connect to the server via RDP
List the lasted available daily database backup:

C:\> cd %plesk_dir%Mysql\Backup

List all available Plesk daily dumps sorted by date (newest first):

C:\> dir /O:-D
Directory of C:\Program Files (x86)\Plesk\MySQL\Backup
10/18/2018 02:07 AM 106,128 horde-20181018020721.sql
10/18/2018 02:07 AM 122,124 config-20181018020721.reg
10/18/2018 02:07 AM 28,707 apsc-20181018020721.sql
10/18/2018 02:07 AM 389,032 psa-20181018020721.sql
Restore the APSC database:

C:\> "%plesk_dir%\Mysql\bin\mysql.exe" -uadmin -p -P8306 apsc < apsc-20181018020721.sql

Note: In case there's not an available APSC database backup, recreate the database using %plesk_dir%\admin\db\apsc\dbschema-mysql.sql