• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

I can not remove one domain

kaesar

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