Article ID: 2108, created on Aug 21, 2007, last review on Apr 18, 2012

  • Applies to:
  • Plesk 8.2 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.

b23c51a6195823476e308cc12db2be0e 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF