mysql problem on plesk GUI

[yalti]

Hello,

As you can see on the error logs below, we have an mysql error on "Web Hosting Settings" menu in Plesk.
It is not just that website, whole reseller account give that error on "Web Hosting Settings"
We already tried remove and re add hosting, but nothing change.
What can we do about that issue ? Any help would be great.

DB query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
---------------------- Debug Info -------------------------------
0: common_func.php3:171
db_query(string 'SELECT d.displayName, d.cl_id, d.id FROM domains AS d, Repository AS r, certificates AS c WHERE d.cert_rep_id=r.rep_id AND r.component_id=c.id AND c.id=')
1: class.SSLCertificate.php:1064
get_cert_owner_info(string '')
2: class.IPAddressSelector.php:504
IPAddressSelectorForm->_get_cert_owner_info(string '')
3: class.IPAddressSelector.php:377
IPAddressSelectorForm->assign(object of type IPAddressSelector, boolean true, boolean true, integer '557')
4: class.PHostingManager.php:1965
PHostingForm->assign(object of type PHostingManager, boolean true, boolean true, boolean true, boolean false)
5: phosting_setup.php:269
require(string 'C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\domains\hosting\phosting_setup.php')
6: plesk.php:56


P.S : We dont have a SSL on that server

 

[IgorG]

Usually this problem caused by missing record for SSL certificates with some ID. It lead to the problem that none certificate was assigned to IP addresses and Plesk returned error on query

'SELECT d.displayName, d.cl_id, d.id FROM domains AS d, Repository AS r, certificates AS c WHERE d.cert_rep_id=r.rep_id AND r.component_id=c.id AND c.id='

Checking your database directly on server is required. So, I suggest you contact Support Team.