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

Error when doing search ( mailman mailing list)

Discussion in 'Plesk for Linux - 8.x and Older' started by hendri haryanto, Feb 23, 2010.

  1. hendri haryanto

    hendri haryanto Guest


    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
    2: /usr/local/psa/admin/plib/class.cList.php3:103
    3: /usr/local/psa/admin/plib/class.cList.php3:123
    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.
    maybe fix that error