• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

plesk innodb

M

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
DomainsList->fetchDomainsList()
2: /usr/local/psa/admin/plib/class.cList.php3:99
cList->fetchList()
3: /usr/local/psa/admin/plib/class.cList.php3:119
cList->init()
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.
 
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...
 
Back
Top