Plesk broken. HELP!

[antonio_toni]

My plesk 12 is working, but one subscription doest show, or any of the domains.

Doing some digging got to this:

[root@server src]# /usr/local/psa/bin/sw-engine-pleskrun check_db_integrity-beta.php
PHP Notice: Undefined variable: PLESK_DB_HOST in /usr/local/src/check_db_integrity-beta.php on line 240
List of records in [psa.domains.cl_id] that miss a matching record in [psa.clients.id]
0
List of records in [psa.dom_level_usrs.dom_id] that miss a matching record in [psa.domains.id]
27, 32, 36, 43, 61, 83, 86
PHP Notice: Undefined index: PARAMETERS in /usr/local/psa/admin/plib/CommonPanel/Exception.php on line 266
Error occured while sending feedback. HTTP code returned: 502
Caught exception: MySQL query failed: Table 'psa.domainaliases' doesn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases);"
PHP Notice: Undefined index: PARAMETERS in /usr/local/psa/admin/plib/CommonPanel/Exception.php on line 266
Error occured while sending feedback. HTTP code returned: 502
Caught exception: MySQL query failed: Table 'psa.domainaliases' doesn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases);"
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
List of records in [psa.Subscriptions.object_id WHERE object_type='domain'] that miss a matching record in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0]
58, 81
List of records in [psa.Subscriptions.id] that miss a matching record in [psa.PlansSubscriptions.subscription_id]
2, 80, 55, 64, 65, 66, 67, 68
List of records in [psa.smb_roles.ownerId] that miss a matching record in [psa.clients.id]
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
List of records in [psa.smb_servicePermissionAccounts.servicePermissionId] that exceed N in 1:N (N=1) relation to [psa.smb_servicePermissions.id]
2 [count in table psa.smb_servicePermissions:1; count in table psa.smb_servicePermissionAccounts:232]
List of records in [psa.smb_servicePermissions.id] that miss a matching record in [psa.smb_servicePermissionAccounts.servicePermissionId]
1
ERROR: Table "smb_apsImportedResources" is not found in database "psa"!
ERROR: Table "smb_apsImportedResources" is not found in database "psa"!
List of records in [psa.domains.webspace_id, cl_id WHERE webspace_id<>0] that miss a matching record in [psa.domains.id, cl_id WHERE webspace_id=0]
20:1, 52:1, 52:1, 52:1, 68:1

Now what?

Please help!

 

[IgorG]

Could you please describe with details what exactly doesn't work? Any error messages? Steps to reproduce this issue?
I'm not sure but I think this check_db_integrity-beta.php script is not optimized for Plesk 12 version yet.