Product:
Search Type:

[FIX] Certificate installation fails

Article ID: 2108 
Last Review: Aug,21 2007
APPLIES TO:
  • Plesk 8.2.0 for Windows

SYMPTOMS

SSL certificate installation for any domain fails with the following error:

<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b>
The data types ntext and nvarchar are incompatible in the equal to operator.
---------------------- Debug Info -------------------------------
0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:202
        com->execute(string 'select c.id, c.pvt_key from certificates c,
Repository r where r.rep_id=50 and r.component_id=c.id and c.cert=N'' and
c.pvt_key<>N''', NULL null)
1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:202
        db_query(string 'select c.id, c.pvt_key from certificates c, Repository
r where r.rep_id=50 and r.component_id=c.id and c.cert='' and c.pvt_key<>''',
boolean  false)
2: C:\Program Files\SWsoft\Plesk\admin\plib\class.SSLCertificate.php:922

RESOLUTION

Please download the following file:

http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/122576/class.SSLCertificate.php


and place it to %plesk_dir%\admin\plib folder.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields