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

Error deleting domain

Discussion in 'Plesk for Linux - 8.x and Older' started by Sys Av, Apr 1, 2009.

  1. Sys Av

    Sys Av Guest

    0
     
    Hello,
    I have created a domain on Plesk, and tried to login as domain administrator..
    I got a blank page when I login..
    Then, I tried to remove the domain, so I can add it again.
    I got this error:

    ERROR: PleskFatalException
    Up LevelUp Level
    DomainUser::getAccount failed: Unable to create Account object: Account: unable to select:

    no such row in the table

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


    I did find out this article on the kb:

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

    First, hey don't say on the article what database to use..
    I would guess is psa, but..
    I am not very proficient with mysql, so everything that has to do with databases (and more, with plesk main database) kind of scares me :)

    Then, they say is for version 8.1 up to 8.3
    My server is 8.6 (on top of Suse 10.3), and there is my conundrum..Is there any change on the psa table structure from 8.3 to 8.6 that would screw the plesk database?
    Can I apply the resolution from that article?

    Thanks for any suggestion you might have.

    Barasians
     
    Last edited by a moderator: Apr 1, 2009
  2. Sys Av

    Sys Av Guest

    0
     
    Still error after applying resolution from article

    I have followed the steps from the article above (did first a dump of the psa database)
    No errors, but when I have logged back into Plesk and tried to delete the domain, I got this:

    ERROR: PleskFatalException
    Up LevelUp Level
    Dashboard preset used by user failed: DashboardPreset: unable to select: no such row in the table

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


    Ideas?

    Thanks
     
  3. Sys Av

    Sys Av Guest

    0
     
  4. ziba

    ziba Guest

    0
     
    Hi,

    Try running the following query:
    select preset_id from DashboardPresetConfig left join DashboardPreset on DashboardPresetConfig.preset_id=DashboardPreset.id where DashboardPreset.id is NULL group by preset_id;

    and post here what you get as result.
     
  5. Sys Av

    Sys Av Guest

    0
     
    I get empty set:
    mysql> select preset_id from DashboardPresetConfig left join DashboardPreset on DashboardPresetConfig.preset_id=DashboardPreset.id where DashboardPreset.id is NULL group by preset_id;
    Empty set (0.00 sec)

    Thanks ziba!
     
  6. nika

    nika Guest

    0
     
    try to run the following command:

    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"

    Then remove references to non-existing presets from dom_param, for example:
    mysql> delete from dom_param where dom_id=xx and param='custom_preset_id'

    where xx is id value from the output of previous command
     
Loading...