Additional Services buttons are missing

Created:

2017-07-25 11:48:31 UTC

Modified:

2017-08-08 13:12:22 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Additional Services buttons are missing

Symptoms

  • Additional Services (which can be created under Service Plans > Additional Services > Add Service) are not shown under Subscriptions > example.com > Websites & Domains.
    However, they can be seen under Subscriptions > example.com > General > Additional Services.

  • Plesk was updated from 11.5 to 12.0 or higher version.

  • An empty output of the command below is provided:

    # plesk db "SELECT * FROM custom_buttons WHERE level = 16 AND level_id = 4001"

    Note: Where level_id is ID of the affected domain.

  • The value 8 of the column level exists in the custom_buttons table:

    # plesk db "SELECT level, count(*) FROM custom_buttons GROUP BY level"
    +-------+----------+
    | level | count(*) |
    +-------+----------+
    |   1   |     2    |
    |   4   |    246   |
    |   8   |    290   |
    |   16  |    706   |
    +-------+----------+

Cause

This is Plesk bug with ID PPPM-6802 which is planned to be fixed in future Plesk updates.

Resolution

As a workaround do the following:

  1. Create a backup of the table custom_buttons of the psa database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa custom_buttons > /root/psa_custom_buttons.sql

  2. Change all values of the column level which equal 8 to 16:

    mysql> MYSQL_LIN: UPDATE custom_buttons SET level = 16 WHERE level = 8;
    Query OK, 290 rows affected (0.01 sec)
    Rows matched: 290 Changed: 290 Warnings: 0

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