Blank Domain Name Template

[LostInTime]

Hi,

I am unable to delete a domain template that has no name. When I do select it and try and delete it I get the following error;

Service Unavailable
Service is not available now, probably your Plesk is misconfigured.
Contact Your provider for details.

Internal Plesk error occurred: TemplatesList::remove() failed: TemplatesList::getRepositId_() failed: Unable to define templates

I can create and delete templates witrhout error.

I'm using plesk 8.2.1.

Thanks.

 

[Satoriya]

Hi,

We have met such problem with 'dead' domain template in the past. To delete this template we had to clear some records in 'psa' database. You can try to apply this solution but before that I suggest you to backup psa database just in case.

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> use psa;
mysql> select val from misc where param='dom_tmpl_list_id';
+-----+
| val |
+-----+
| 3 |
+-----+
1 row in set (0.00 sec)

mysql> select `rep_id`, `component_id` from `Repository` where rep_id=3;
+--------+--------------+
| rep_id | component_id |
+--------+--------------+
| 3 | 1 |
| 3 | 4 |
+--------+--------------+
2 rows in set (0.00 sec)

mysql> delete from `Repository` where rep_id=3 and component_id=1;
Query OK, 1 row affected (0.03 sec)

mysql> select `rep_id`, `component_id` from `Repository` where rep_id=3;
+--------+--------------+
| rep_id | component_id |
+--------+--------------+
| 3 | 4 |
+--------+--------------+
1 row in set (0.00 sec)