Symptoms
-
The database check shows the next warning in Plesk > Tools & Settings > Diagnose & Repair and it can not be fixed:
Checking the consistency of the Plesk database Inconsistency in the table 'smb_roleServicePermissions' for the column servicePermissionId: No rows in the table 'smb_servicePermissions' with id = 1
-
The Plesk has been updated to 18.0.30.0 recently
Cause
Product issue:
- #PPPM-12392 “Running the plesk bin repair –db command after updating to Plesk Obsidian 18.0.30 no longer results in a misleading error message.”
Fixed in:- Plesk Obsidian 27 October 2020 (Linux)
Resolution
Please consider updating your server:
Workaround
If update is not possible for some reason you may try the following:
workaround
-
Connect to the server via SSH
-
Repair the database:
# plesk repair db
Note: The inconsistency should be fixed despite the fact it is not possible to do via GUI.
with