Problem when delete domain

[ThanhBT]

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
    mdeleteDomains(array)
4: /usr/local/psa/admin/plib/class.Manager.php:351
    Manager->removeDomains(array)
5: /usr/local/psa/admin/htdocs/domains/domains.php3:215

How to fix this problem? Thank in advance

 

[Traged1]

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?