Product:
Search Type:

[FIX] Plesk database corruption warning on IP address management page

Article ID: 2005 
Last Review: Jul,17 2007
APPLIES TO:
  • Plesk 7.6.x for Windows
  • Plesk 8.1 for Windows
  • Plesk 8.2 for Windows

SYMPTOMS

The following error message is displayed on IP address management page (Plesk, Server, IP addresses ):

Warning: The Plesk database is corrupt. Please launch the Reconfigurator utility to fix it

CAUSE

Plesk database contains corrupted records that may have been created because of problems during certificate removal.

RESOLUTION

Plesk database should be checked for inconsistency.

Please login to Plesk Mysql :

"%plesk_dir%\mysql\bin\mysql" -uadmin -p<plesk_password> -P8306 psa

The following sql  query needs to be executed in Plesk database:

delete from repository where rep_id=1 and component_id not in (select id from certificates);

Note: The article is valid providing that Plesk database engine is Mysql.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields