H
hendri haryanto
Guest
hi,
Am using plesk 8.4 on centos 3.6.
Initially, I tried to do search on the mailman mailing list and then I got this error :
ERROR: PleskMainDBException
MySQL query failed: You have an error in your SQL syntax near '(ml.name using 'utf8') LIKE '%nt%' AND 1' at line 1
0: /usr/local/psa/admin/plib/common_func.php3:214
db_query(string 'SELECT count(*) from MailLists ml WHERE ml.dom_id = "1" AND convert(ml.name using 'utf8') LIKE '%nt%' AND 1')
1: /usr/local/psa/admin/plib/class.MailListsList.php:80
MailListsList->fetchMailListsList()
2: /usr/local/psa/admin/plib/class.cList.php3:103
cList->fetchList()
3: /usr/local/psa/admin/plib/class.cList.php3:123
cList->init()
4: /usr/local/psa/admin/htdocs/domains/maillists/maillists.php:191
Now, I am stuck, because every time I click the mailing list icon, I always come up with that page.
It seems that plesk remember your entered key in the search box and always try to reload that search page.
I cant even manage my mailing list now.
Is there anyway to clean my session history or something.
or
maybe fix that error
thanks
Am using plesk 8.4 on centos 3.6.
Initially, I tried to do search on the mailman mailing list and then I got this error :
ERROR: PleskMainDBException
MySQL query failed: You have an error in your SQL syntax near '(ml.name using 'utf8') LIKE '%nt%' AND 1' at line 1
0: /usr/local/psa/admin/plib/common_func.php3:214
db_query(string 'SELECT count(*) from MailLists ml WHERE ml.dom_id = "1" AND convert(ml.name using 'utf8') LIKE '%nt%' AND 1')
1: /usr/local/psa/admin/plib/class.MailListsList.php:80
MailListsList->fetchMailListsList()
2: /usr/local/psa/admin/plib/class.cList.php3:103
cList->fetchList()
3: /usr/local/psa/admin/plib/class.cList.php3:123
cList->init()
4: /usr/local/psa/admin/htdocs/domains/maillists/maillists.php:191
Now, I am stuck, because every time I click the mailing list icon, I always come up with that page.
It seems that plesk remember your entered key in the search box and always try to reload that search page.
I cant even manage my mailing list now.
Is there anyway to clean my session history or something.
or
maybe fix that error
thanks