• The APS Catalog has been deprecated and removed from all Plesk Obsidian versions.
    Applications already installed from the APS Catalog will continue working. However, Plesk will no longer provide support for APS applications.
  • Please be aware: with the Plesk Obsidian 18.0.78 release, the support for the ngx_pagespeed.so module will be deprecated and removed from the sw-nginx package.

Upgrade to 8.3 broke Application Vault

C

cornerstone

Guest
I upgraded to version 8.3 this past week. When I goto my Application Vault, I see:

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'categories' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:218
db_query(string 'select `id`,`name`,`version`,`release`,`description`,`categories`,`integrated`,`access_level`,`package_type`,`params_id` from SiteAppPackages where `id`=39')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/SiteApps/class.cSiteApp.php:48
cSiteApp->cSiteApp(integer '39')
3: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackage.php:92
SiteAppPackage->__construct(string '39')
4: /usr/local/psa/admin/plib/common_func.php3:2875
objectMaker(string 'SiteAppPackage', string '39')
5: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:381
SiteAppPackageManager->registerSiteAppPackage(string 'pLog-1.0-29')
6: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:274
SiteAppPackageManager->syncWithDatabase()
7: /usr/local/psa/admin/htdocs/server/site_app_pkgs.php:42

It said it was successful and everything is "up to date". However I am unable to make any changes to my Application Vault. Does anyone have a solution? Your prompt response is much appreciated.
 
Also, when I try to add Site Applications, through the Domain, I get this error:

ERROR: PleskMainDBException
MySQL query failed: Table 'psa.APSClientApplicationItems' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:218
db_query(string 'SELECT sa.id, sa.dom_type, sd.displayName, sa.install_prefix, sa.htdocs_directory, sapkg.name, sapkg.version, sa.app_release, sapkg.description, sapkg.access_level, sa_url.value, sapkg.package_type, sa.capp_item_id, sa.license_id, ai.license_type_id, lt.description FROM SiteApps AS sa INNER JOIN APSClientApplicationItems csai ON (sa.capp_item_id=csai.id) INNER JOIN APSApplicationItems ai ON (csai.app_item_id=ai.id) LEFT JOIN APSLicenseTypes AS lt ON ai.license_type_id=lt.id INNER JOIN SiteAppPackages AS sapkg ON (ai.pkg_id=sapkg.id) LEFT JOIN subdomains AS sd ON (sd.id = sa.dom_id) LEFT JOIN Parameters AS sa_url ON (sa.params_id=sa_url.id AND sa_url.parameter="application_url") WHERE (sa.dom_id="321" AND sa.dom_type="domain") OR (sd.dom_id="321" AND sa.dom_type="subdomain");')
1: /usr/local/psa/admin/plib/SiteApps/class.SiteAppsList.php:114
SiteAppsList->fetchSiteAppsList()
2: /usr/local/psa/admin/plib/class.cList.php3:103
cList->fetchList()
3: /usr/local/psa/admin/plib/class.cList.php3:123
cList->init()
4: /usr/local/psa/admin/htdocs/domains/hosting/site_apps.php:101

Has anyone ran into the same problem? I can't seem to find a fix for this anywhere.
 
I have decided to purchase the support time from Parallels. Does this look like a problem they can solve? I don't want to pay the $75 and not have this be supported. Does anyone have any success stories from their support time? Problems?
 
Back
Top