- Plesk 12.5 for Linux
- Plesk Onyx for Linux
Tools & Settings > Update and Upgrade Settings page is inaccessible with the following error in browser:
PLESK_ERROR: Unable to find row with id 27 in Notifications table
There are 27 and 28 rows are missing in Notifications table in Plesk database:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"select * from Notifications where id in (27,28)"
Database inconsistency. Default notifications are absent in database.
- Connect to the server using SSH ;
psadatabase from a backup using article How to backup/restore a Plesk database dump;
Enter the database:
# plesk db
Execute the following to insert 2 missing rows:
MYSQL_LIN: mysql> INSERT INTO `Notifications` VALUES (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);