plesk innodb

[mrfooy]

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.

 

[Amin Taheri]

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...

 

[sseeger]

The problem is that Plesk has remembered your last search, and for some reason, it's gotten it's wires crossed. To fix, go to this URL:

domains/domains.php3?cmd=clearFilter

If you're currently at https://example.com:8443/?previous_page=login_up for example, you want to go to: https://example.com:8443/domains/domains.php3?cmd=clearFilter

This will show you the page of all your domains. Hit the back button to get the frames back. Good luck!