We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 26877
    • 2 Posts
    Hi,

    Ive got a strange behaviour regarding ajaxsearch. if no webuser is logged into the site the search is working properly. But I get an error after searching for words if i am logged in:

    Cannot query the database (SELECT DISTINCT sc.id, sc.pagetitle, sc.description, sc.content, [...] '%here...%')) AND (ISNULL(dg.document_group) OR dg.document_group IN (0%2C1)) AND sc.published = 1 AND sc.searchable=1 AND sc.deleted=0;)


    Does anybody know why this error occurs?

    Thx in advance
      • 5811
      • 1,717 Posts
      Hi Shaft

      Which version AjaxSearch do you use it ? 1.7.0.2 ? or a previous version ?
      Once you are logged, could you look the code of the page and give me the value of the docgrp.

      Could I access to your site or is it a local site ?

        • 26877
        • 2 Posts
        Hi,

        I just updated to 1.7.0.2. Now it works fine. I would like to point out, that the $database_connection_charset wasnt set (should be utf8 normally) during installation of modx.

        Thanks again!