• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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