Applications tab - Search results could not be loaded at the moment

Created:

2016-11-16 13:19:47 UTC

Modified:

2017-08-16 16:50:12 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Applications tab - Search results could not be loaded at the moment

Applicable to:

  • Plesk for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows

Symptoms

Applications are not listed in Applications Vault:

Home> Tools & Settings > View Installed Apps ( nothing there )

Home> Tools & Settings > View My Apps> ( nothing there )

Home> Subscriptions> Any domain name > Application tab > Featured Applications :

Message: Search results could not be loaded at the moment. Retry

At the same time in %plesk_dir%\\admin\\logs\\php_error.log :

[31-Dec-2013 20:46:17 UTC] ERR (3)  [panel]: APS Catalog error exception: exception 'Exception' with message 'Package with UID 'a6f3d356-0341-4a57-ac2d-bc8079d9fa4a' not found.' in C:\\Program Files\\Parallels\\Plesk\\admin\\plib\\aps_php.php:12519

Home> Subscriptions> Any domain name > Application tab > All available application :

 List of categories could not be loaded at the moment.

Why are some applications (for example, Wordpress, Joomla, DotNetNuke) not available?

Cause

There is no related record in the apsc.aps.registry_object:

How to access the Parallels Plesk database

Make sure that you have records in psa.smb_apsPackages which do not have related records in the apsc.aps_registry_object table:

mysql> select count(*) from psa.smb_apsPackages where registryUid not in (select uid from apsc.aps_registry_object);
+----------+
| count(*) |
+----------+
| 38 |
+----------+
1 row in set (0.00 sec)

Resolution

  1. Create a psa database dump before making any changes:

    Parallels Plesk for Windows:

    "%plesk_bin%\\MySQL\\bin\\mysqldump.exe" -uadmin -P8306 -p****** psa > psa_dump.sql

    Parallels Plesk for Linux:

    plesk db dump > psa_dump.sql
  2. Delete the records in psa.smb_apsPackages:

    mysql> delete from psa.smb_apsPackages where registryUid not in (select uid from apsc.aps_registry_object);
  3. Go to Tools and Settings -> Application Vault -> My Apps -> Add App -> Select an app from Application Catalog -> add the applications you need and press OK.

Have more questions? Submit a request
Please sign in to leave a comment.