Symptoms
-
Unable to install applications like Prestashop in Subscriptions > example.com > Create Website > More Apps
-
Domains > example.com cannot be opened:
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.
Cause
Missing tables in the apsc (application service controller) database of Plesk.
Resolution
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%MysqlBackup
List all available Plesk daily dumps sorted by date (newest first):
C:> dir /O:-D
Directory of C:Program Files (x86)PleskMySQLBackup
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%Mysqlbinmysql.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%admindbapscdbschema-mysql.sql
with