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

Server Settings: Error: DashboardPreset: unable to select: no such row in the table

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by ThomasKa, Jul 29, 2011.

  1. ThomasKa

    ThomasKa New Pleskian

    12
    60%
    Joined:
    Jul 26, 2011
    Messages:
    1
    Likes Received:
    0
    Hi,

    I am using Plesk 10.1.1 on a Suse Linux 11.0.

    After removing Plesk Billing i can not enter Server Settings, Restrict Creation of Subzones and Settings of Server Statistics, in summary all https://mydomain:8443/plesk/server/preferences/ adresses.

    If i want to access one of this settings i get the following error: DashboardPreset: unable to select: no such row in the table

    Please Help.

    Greetz Thomas
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    Such problem may occurs if a domain has reference to custom dashboard presets that really does not exist.
    To find such domain the following command can be used:


    Then remove references to non-existing presets from dom_param, for example:
     
  3. DarthWalo

    DarthWalo New Pleskian

    10
     
    Joined:
    Jun 20, 2012
    Messages:
    2
    Likes Received:
    0
    Complementing

    If it still fails, one should also try:

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

    Regards
     
Loading...