some of errors after Migrate from Plesk 8.6 to Plesk 11.5

[christiano1203]

Hello,

after i migrate from Plesk 8.6 to Plesk 11.5 some of my Domains have trouble.

When I want to open one of the Domain i become this error here:

Internal error: Unable to load object of type Account with id=340: Account: unable to select: no such row in the table

In the databases i found some of errors here:

Previous error: Template_Exception: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2864 | nginxDomainVhost | 1 | |
14159608750.24688700 | nginxDomain | 755 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/nginxDomainVhost.php, error = Template_Exception: Unable to load object of type Account with
id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous errorine: 27
c: Template_Exception: Unable to load object of type Account with
id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2865 | domainVhost | 1 | |
14159607660.28767600 | domain | 756 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/domainVhost.php, error =
Template_Exception: Unable to load object of type Account with id=1080:
Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: Template_Exception: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2866 | nginxDomainVhost | 1 | |
14159608750.84286100 | nginxDomain | 756 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/nginxDomainVhost.php, error = Template_Exception: Unable to load object of type Account with
id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27Previous error: Template_Exception: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2864 | nginxDomainVhost | 1 | |
14159608750.24688700 | nginxDomain | 755 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/nginxDomainVhost.php, error = Template_Exception: Unable to load object of type Account with
id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous errorine: 27
c: Template_Exception: Unable to load object of type Account with
id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2865 | domainVhost | 1 | |
14159607660.28767600 | domain | 756 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/domainVhost.php, error =
Template_Exception: Unable to load object of type Account with id=1080:
Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
code: 0
Previous error: Template_Exception: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1080: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1080)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2895 | domainVhost | 1 | |
14159607660.28767600 | domain | 772 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/domainVhost.php, error =
Template_Exception: Unable to load object of type Account with id=1109:
Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1109)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: Template_Exception: Unable to load object of type Account with id=1109: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1109)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1109: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1109)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |
| 2896 | nginxDomainVhost | 1 | |
14159608860.60860600 | nginxDomain | 772 | error | true |
Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/nginxDomainVhost.php, error = Template_Exception: Unable to load object of type Account with
id=1109: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where `id`=1109)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: Template_Exception: Unable to load object of type Account with id=1109: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1109)
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: PleskFatalException: Unable to load object of type Account with id=1109: Account: unable to select: no such row in the table (select `id`, `type`, `password` . from `accounts` . where
`id`=1109)
file: /usr/local/psa/admin/plib/functions.php
line: 1614
code: 0 |


Is there a solution to fix this issue ?

I have already do this here: http://kb.odin.com/en/117727 and reconfigure all my domains again, but the issue dont fix.

 

[UFHH01]

You have several domains which can't be found in your log. Please see all entries with the comment "Account: unable to select: no such row in the table".
Every domain id should be added like you already read in the mentioned KB - article, to solve the database inconsistency.

 

[christiano1203]

Hi,

i already do the solution in the KB article, but it's not fix my problem.

 

[UFHH01]

You might want to try the bootstrapper repair, which fixes a lot of issues/problems:

/usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair​

... but I won't repair database inconsistency which depends on missing rows. If you would like to have further suggestions, make sure to update sur issues/problems with current errors, because they might be different to the former ones.