I can not remove one domain

[kaesar]

Hello,

When I try remove one domain, I get this error:

Dashboard preset used by user failed: DashboardPreset: unable to select: no such row in the table

0: /opt/psa/admin/plib/class.PhDomain.php:431
PhDomain->reset(integer '0', boolean true, boolean false)
1: /opt/psa/admin/plib/class.BsDomain.php:307
BsDomain->reset(integer '0')
2: /opt/psa/admin/plib/class.BsDomain.php:301
BsDomain->delete(integer '0')
3: /opt/psa/admin/plib/class.BsDomain.php:541
mdeleteDomains(array)
4: /opt/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
5: /opt/psa/admin/htdocs/domains/removeDomains.php3:44

I try the suggets in:

http://kb.odin.com/en/1360

But I have the same problem.

 

[ziba@]

Hi,

this can happen due if a domain has reference to custom dashboard presets that really does not exist.

To find such domain the following command can be used:

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` -D psa -e "select d.name,d.id, dp.param, dp.val, P.id from domains d, dom_param dp left join DashboardPreset P on P.id=dp.val where dp.param='custom_preset_id' and d.id=dp.dom_id and P.id is NULL"

let's say you got:

+----------------+---------------+----------------------+------+------+
| name | id | param | val | id |
+----------------+---------------+----------------------+------+------+
| domain.tld | 7 | custom_preset_id | 81 | NULL |
+----------------+---------------+----------------------+------+------+

remember "id" value from here
next you remove references to non-existing presets from dom_param, for example:

mysql> delete from dom_param where dom_id=7 and param='custom_preset_id'

I would also recommend to backup psa database before doing this.

 

[kaesar]

Yes, with this change I can remove the domain.

Thanks