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

plesk innodb

Discussion in 'Plesk for Linux - 8.x and Older' started by mrfooy, Sep 5, 2007.

  1. mrfooy

    mrfooy Guest

    ERROR: PleskMainDBException
    MySQL query failed: Unknown table 'sd' in where clause

    0: /usr/local/psa/admin/plib/common_func.php3:234
    db_query(string 'SELECT d.id, UNIX_TIMESTAMP(d.cr_date), d.displayName, d.status, d.htype, d.real_size, d.cl_id, sum(dt.http_in) + sum(dt.ftp_in) + sum(dt.smtp_in) + sum(dt.pop3_imap_in) + sum(dt.http_out) + sum(dt.ftp_out) + sum(dt.smtp_out) + sum(dt.pop3_imap_out) AS traffic FROM domains d LEFT JOIN DomainsTraffic dt ON (dt.date BETWEEN "2007-09-01" AND "2007-09-05") AND dt.dom_id = d.id WHERE (d.displayName like "%2%" OR sd.displayName LIKE "%2%") AND 1 GROUP BY d.id ORDER BY traffic DESC, d.displayName LIMIT 0, 100')
    1: /usr/local/psa/admin/plib/class.DomainsList.php3:218
    2: /usr/local/psa/admin/plib/class.cList.php3:99
    3: /usr/local/psa/admin/plib/class.cList.php3:119
    4: /usr/local/psa/admin/htdocs/domains/domains.php3:261

    Plesk seems to work but when i try to search for a domain i get the error stated above how can i go about to solve this issue.
  2. Amin Taheri

    Amin Taheri Golden Pleskian Plesk Certified Professional

    Jul 5, 2007
    Likes Received:
    Seattle Area
    only thing I can suggest is to reinstall the RPMs or to contact their support.

    We cant look or change the code as the files are encoded, and there are no tables called SD in the psa DB, and the query your using is wrong becuase your using a prefix name (sd) with out declaring which table that is (I know its not "your" query, but still) so I dont see much else you can do...
  3. sseeger

    sseeger Guest