• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

how can i attempt to solve this issue stated above?
 
Back
Top