• The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

some of errors after Migrate from Plesk 8.6 to Plesk 11.5

christiano1203

Basic Pleskian
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.
 
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.
 
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.
 
Back
Top