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

Problem when delete domain

Discussion in 'Plesk for Linux - 8.x and Older' started by ThanhBT, May 24, 2006.

  1. ThanhBT

    ThanhBT Guest

    Unable to init SSLCertificate object: SSLCertificate: unable to select: no such row in the table
    0: /usr/local/psa/admin/plib/class.PhDomain.php:401
        PhDomain->reset(integer '0', boolean true, boolean false)
    1: /usr/local/psa/admin/plib/class.BsDomain.php:289
        BsDomain->reset(integer '0')
    2: /usr/local/psa/admin/plib/class.BsDomain.php:283
        BsDomain->delete(integer '0')
    3: /usr/local/psa/admin/plib/class.BsDomain.php:524
    4: /usr/local/psa/admin/plib/class.Manager.php:351
    5: /usr/local/psa/admin/htdocs/domains/domains.php3:215
    How to fix this problem? Thank in advance
  2. Traged1

    Traged1 Guest

    Looks like the psa record for this domain has a wrong number set for the "cert_rep_id" in the domains table.

    To fix do the following:

    First figuire out if this domain is using the defualt ssl cert, if so great this fix will work!

    login to mysql from console.

    use psa;

    select * from domains where name = 'domain.com';

    you will now see the "cert_rep_id" number in the 9th column, it will most likely be some number other then 0, as it should be set to 0, do this by:

    update domains set cert_rep_id = 0 where name = 'domain.com';

    Make sure to change the domain.com to the actual domain.

    If the domain is using an exclusive SSL cert then run an sql query like:

    Select * from certificates;

    Find the right cert and record the correct ID fom the query result, then update the certrep_id as described above with the proper ID number.

    Hope this helps?