Article ID: 112887, created on Jul 29, 2013, last review on Jul 29, 2013

  • Applies to:
  • Plesk Automation 11.1
  • Plesk 12.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix
  • Plesk 12.0 for Windows
  • Plesk 11.0 for Windows
  • Plesk 10.4 for Windows

自 Plesk 10.4.4 MU#35 起该问题已得以解决。Plesk 11 未受其影响。

问题

在 Parallels Plesk Panel 10.4 中的 "域名" 页面中未显示域名,但是 "订阅" 页面中确有显示订阅。

原因

可能的原因如下:

1. 在 Error Console 中显示以下错误 (Mozilla Firefox > Tools > Error Console):
---8<---
Error: item.forwardingUrlHost is null
Source File: https://PLESKHOST:8443/admin/domain/list?context=domains
Line: 200
--->8---


该问题可能是由于为多个域名配置了一个无效的转发 URL 而导致的:

mysql> select d.name, d.htype, f.redirect from domains d, forwarding f where d.id=f.dom_id and f.redirect not like 'http://%';
+-------------+---------+------------------+
| name        | htype   | redirect         |
+-------------+---------+------------------+
| DOMAIN1.TLD | std_fwd | REALDOMAIN1.TLD/ |
| DOMAIN2.TLD | frm_fwd | REALDOMAIN2.TLD/ |


您可能会看到该 URL 没有包含 "HTTP://"

2. 在 Error Console 中出现以下错误:
--->8---
Error: item.ownerName is null
Source File: https://
PLESKHOST:8443/admin/domain/list?context=domains
Line: 220
---8<---


给 Parallels Plesk Panel 中丢失的客户端分配了一个域名:

mysql> SELECT domains.name FROM domains LEFT JOIN clients ON (domains.cl_id=clients.id) WHERE clients.id is NULL;
+-----------+
| name      |
+-----------+
| test5.com |
+-----------+
1 row in set (0.00 sec)

mysql> select id, name, cl_id from domains where name='test5.com';
+----+-----------+-------+
| id | name      | cl_id |
+----+-----------+-------+
| 55 | test5.com |    30 |
+----+-----------+-------+
1 row in set (0.00 sec)

mysql> select id, pname from clients where id=30;
Empty set (0.00 sec)

mysql>

解决方案

1. 开发人员已经知道了该错误的存在并计划于 Parallels Plesk Panel 10.4.4 之后的更新中予以修复。
目前有必要手动更改数据库中受影响的域名的 URL。 您可以使用以下命令:

mysql> update forwarding set redirect='http://REALDOMAIN1.TLD/' where redirect='REALDOMAIN1.TLD/';
Query OK, 1 rows affected (0.8 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update forwarding set redirect='http://REALDOMAIN2.TLD/' where redirect='REALDOMAIN2.TLD/';
Query OK, 1 rows affected (1.09 sec)
Rows matched: 1  Changed: 1  Warnings: 0

2. 分配域名给 admin 用户:

mysql> select id, login from clients where type='admin';
+----+-------+
| id | login |
+----+-------+
|  1 | admin |
+----+-------+
1 row in set (0.00 sec)

mysql> update domains set cl_id=1 where name='test5.com';
Query OK, 1 rows affected (1.13 sec)
Rows matched: 1  Changed: 1  Warnings: 0


56797cefb1efc9130f7c48a7d1db0f0c e8756e9388aeca36710ac39e739b2b37 a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 dd0611b6086474193d9bf78e2b293040 ff5a00b8ead2e480367b019417a04207 85a92ca67f2200d36506862eaa6ed6b8 c796c01d6951fa24ed54c7f1111667c6 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 01bc4c8cf5b7f01f815a7ada004154a2 0a53c5a9ca65a74d37ef5c5eaeb55d7f c1ecc6010feff26cb42d1d14a7881dd6 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079 ed7be2b984f9c27de1d2dc349dc19c6d a766cea0c28e23e978fa78ef81918ab8 400e18f6ede9f8be5575a475d2d6b0a6 514af229ae32522202a910a2649c80fb bd7fc88cf1b01f097749ae6f87272128

Email subscription for changes to this article