Unable to access notifications page: Notification 0 does not exists

Created:

2016-12-12 03:39:57 UTC

Modified:

2017-08-08 13:41:59 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access notifications page: Notification 0 does not exists

Applicable to:

  • Plesk Onyx for Windows
  • Plesk 12.0 for Windows

Symptoms

Unable to access Notifications page under Plesk > Tools&Settings > Notifications . The following error occurs:

    Error: Notification '0' does not exists.

Cause

psa.Notifications and psa.notes tables are empty in Plesk database.

Resolution

1. Back up current psa database using the following command (check How to backup/restore a Plesk database dump? article as reference):

"%plesk_dir%"\\Mysql\\bin\\mysqldump.exe -uadmin -p<plesk_admin_password> -P8306 psa > C:\psa.sql

2. Log in to Plesk database and insert default values into psa database:

mysql> INSERT INTO `notes` VALUES (1,'A new customer account has been created.\nCustomer\'s contact name: <client_contact_name>\nCustomer\'s login: <client_login>\nTo obtain your password, please proceed to https://<hostname>:8443/get_password.php?email=<client_email>&login_name=<client_login>\nPanel entry point: https://<hostname>:8443'),(2,'A new domain name has been created.\nDomain name: <domain>\nDomain name owner: <user_contact_name>\nIP address associated with the domain name: <ip>'),(3,'The \'<domain_name>\' subscription, owned by user \'<user_contact_name>\', is approaching or already exceeded the resource usage limits:\n<resource_table>\n'),(6,'The term of subscription \'<domain_name>\', owned by user <user_contact_name> (username \'<user_login>\') has expired.\nThe subscription and all related services were deactivated on <domain_expiration_date>.'),(7,'The term of subscription \'<domain_name>\', owned by user <user_contact_name> (username \'<user_login>\') is about to expire.\nThe subscription and all related services will be deactivated by <domain_expiration_date> unless the subscription term is prolonged.'),(12,'The Application Manager has reported the following error: <error_name>.\nSee the error details below:\n-----\n<error_details>\n-----'),(13,'A new reseller account has been created.\nReseller\'s contact name: <reseller_contact_name>\nReseller\'s login: <reseller_login>\nTo obtain your password, please proceed to https://<hostname>:8443/get_password.php?email=<reseller_email>&login_name=<reseller_login>\nPanel entry point: https://<hostname>:8443'),(16,'The \'<reseller_contact_name>\' account is approaching or already exceeded the limits:\n<resource_table>\n'),(18,'The following resources were overused by subscription \'<domain_name>\', owned by user \'<user_contact_name>\':\n<resource_table>\nThe subscription was suspended.\n'),(20,'The following resource limits were exceeded by reseller \'<reseller_contact_name>\'):\n<resource_table>\nThe reseller account was suspended.\n'),(22,'Subscription of reseller \'<reseller_contact_name>\' tried to use more \'<limit_name>\' resource than can be provided to the reseller. The operation that tried to use more resources was blocked.\n'),(23,'<available_updates_text><available_updates_list><installed_updates_text><installed_updates_list><requirements_updates_text><requirements_updates_list>'),(24,'<available_updates_text><available_updates_list><installed_updates_text><installed_updates_list><requirements_updates_text><requirements_updates_list>'),(25,'<available_updates_text><available_updates_list><installed_updates_text><installed_updates_list><requirements_updates_text><requirements_updates_list>'),(26,'Please be informed,\nfollowing customers\' domains, mailboxes and subscriptions are reached their limits for outgoing emails for the period:\nFrom <from>\nTo <to><domains_list><mails_list><subscriptions_list>'),(27,'<header>\n\n<lists>\n<footer>'),(28,'<header>\n<limit_descriptor>\n\n<limit_information>\n\n<time_zone>\n\n<footer>');

mysql>  INSERT INTO `notifications` VALUES (1,'','0','1','1','0','0','','Notification of the customer creation.',1),(2,'','0','0','1','0','0','','Notification of the site creation.',2),(3,'','0','0','1','0','0','','Notification: Resource usage by subscription has exceeded the allotments.',3),(6,'','0','0','1','0','0','','Subscription event notification: The subscription term has expired.',6),(7,'','0','0','1','0','0','','Subscription event notification: The subscription term is about to expire.',7),(12,'','1','0','0','0','0','','Application Manager Error notification.',12),(13,'','1','1','0','0','0','','Notification of the reseller creation.',13),(16,'','1','1','0','0','0','','Notification: Resource limits exceeded by reseller account.',16),(18,'','0','0','1','0','0','','Notification: Subscription was suspended due to resource overuse.',18),(20,'','1','1','0','0','0','','Notification: Reseller account has exceeded its limits and was suspended.',20),(22,'','0','1','0','0','0','','Notification: Resources overuse blocked for reseller account.',22),(23,'','1','0','0','0','0','','Application Updates.',23),(24,'','0','1','0','0','0','','Application Updates.',24),(25,'','0','0','1','0','0','','Application Updates.',25),(26,'','1','0','0','0','0','','Attempts to exceed outgoing limits for domains, mailboxes and subscriptions.',26),(27,'','1','0','0','0','0','','Package Update Manager notification',27),(28,'','0','0','1','0','0','','Notification: Resource usage by subscription has exceeded the allotments.',28);
Have more questions? Submit a request

3 Comments

  • 0
    Avatar
    Peter Debik

    This article needs fixing of the page format setting. The first SQL insert statement is unreadable.

  • 0
    Avatar
    Nikolay Zhmuk

    2 Peter

    Hi, I checked that both inserts are valid. I copied them and pasted into MySQL prompt on test and verified that it applicable.

  • 0
    Avatar
    Peter Debik

    Yes, article was updated and now showing correct format.

Please sign in to leave a comment.