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

mysql problem on plesk GUI

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by yalti, Nov 14, 2011.

  1. yalti

    yalti New Pleskian

    22
    23%
    Joined:
    Jan 19, 2009
    Messages:
    5
    Likes Received:
    0
    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
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,564
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    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.
     
Loading...