1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

I can not remove one domain

Discussion in 'Plesk for Linux - 8.x and Older' started by kaesar, Oct 7, 2008.

  1. kaesar

    kaesar Basic Pleskian

    25
    23%
    Joined:
    Oct 7, 2008
    Messages:
    71
    Likes Received:
    0
    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.
     
  2. ziba@

    ziba@ Guest

    0
     
    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.
     
  3. kaesar

    kaesar Basic Pleskian

    25
    23%
    Joined:
    Oct 7, 2008
    Messages:
    71
    Likes Received:
    0
    Yes, with this change I can remove the domain.

    Thanks
     
Loading...