Power User view > Use Simple view no longer works after creating a new domain

[dotchd]

I'm a power user, I use Plesk to manage my own VPS. I do not have customers or resellers, just an admin user. I created a new domain yesterday. The domain + website work. Power User View works. Simple View used to work, but not anymore. When I try to switch to Simple view (Panel Appearance > Interface Management > Power User view > Use Simple view), I get this message:

[paste]
ERROR: PleskFatalException
Unable to load object of type PhDomain with id=5: Domain does not exist.

0: common_func.php3:3318
objectMakerEx(string 'PhDomain', string '5')
1: DSWeb.php:61
DSWeb::getByDomainId(string '5')
2: UpdateCrontabShells.php:25
UpdateCrontabShells->_executeCommand()
3: UpdateCrontabShells.php:10
UpdateCrontabShells->runFromDeepInside()
4: Mode.php:90
Plesk_Mode::switchPowerUserPanel(boolean true)
5: server.interface.uimodes.php:43
plesk__server__interface__uimodes->accessItem(string 'POST', NULL null)
6: UIPointer.php:595
UIPointer->access(string 'POST')
7: plesk.php:45
[/paste]

Any idea? Thanks!

 

[IgorG]

It is database inconsistency.

Check that domain with id 5 and corresponding hosting are really exists with

mysql> select * from domains where id = 5\G

mysql> select * from hosting where dom_id = 5\G

I suppose that you haven't record for this domain but have hosting for this missing domain. Try to find correct ID of domain with hostname from field 'www_root' from second select and update it.
If you can't do it by yourself - contact Support Team.

 

[dotchd]

If I type "msql" I get: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Tried to reset password, but no luck

 

[AntonLS]

Try:
mysql -u admin -p`cat /etc/psa/.psa.shadow` -Dpsa

 

[dotchd]

I'm on Plesk Panel 11.0.9 now, restored my server, but the problem came back after I deleted a webspace.

ERROR: PleskFatalException
Unable to load object of type PhDomain with id=7: Domain does not exist.

0: common_func.php3:3327
objectMakerEx(string 'PhDomain', string '7')
1: DSWeb.php:63
DSWeb::getByDomainId(string '7')
2: UpdateCrontabShells.php:25
UpdateCrontabShells->_executeCommand()
3: UpdateCrontabShells.php:10
UpdateCrontabShells->runFromDeepInside()
4: Mode.php:90
Plesk_Mode::switchPowerUserPanel(boolean true)
5: server.interface.uimodes.php:43
plesk__server__interface__uimodes->accessItem(string 'POST', NULL null)
6: UIPointer.php:595
UIPointer->access(string 'POST')
7: plesk.php:45

I get this

mysql> select * from domains where id = 7\G
Empty set (0.00 sec)

mysql> select * from hosting where dom_id = 7\G
*************************** 1. row ***************************
dom_id: 7
sys_user_id: 7
ip_address_id: 0
www_root: /var/www/vhosts/mydomain.net/httpdocs
real_traffic: 0
fp: false
fp_ssl: false
fp_enable: false
fp_adm:
fp_pass:
ssi: false
php: true
cgi: true
perl: true
python: true
fastcgi: true
miva: false
coldfusion: false
asp: false
asp_dot_net: false
ssl: true
same_ssl: true
webstat: awstats
traffic_bandwidth: -1
max_connection: -1
php_handler_type: module
maintenance_mode: false
certificate_id: 0
1 row in set (0.00 sec)

As I said, I wanted to delete mydomain.net, so how do I solve this database inconsistency?

Anyone?

 

[IgorG]

I suggest you contact Support Team if you can't fix this database inconsistency by yourself.