A MySql patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/45589
The combination of GROUP_CONCAT(), DISTINCT, and LEFT JOIN could crash the server when the right table is empty.Noted also in 5.0.62, 5.1.25, 6.0.6 changelogs.
Your SQL-query has been executed successfully (Query took 0.0013 sec) SQL-query: SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon FROM `modx_site_content` sc WHERE ( ( sc.published =1 ) AND ( sc.searchable =1 ) AND ( sc.deleted =0 ) AND ( sc.type = 'document' ) AND ( sc.privateweb =0 ) ) GROUP BY sc.id HAVING ( ( ( sc.pagetitle LIKE '%deco%' ) OR ( sc.longtitle LIKE '%deco%' ) OR ( sc.description LIKE '%deco%' ) OR ( sc.alias LIKE '%deco%' ) OR ( sc.introtext LIKE '%deco%' ) OR ( sc.menutitle LIKE '%deco%' ) OR ( sc.content LIKE '%deco%' ) ) ) ORDER BY sc.publishedon, sc.pagetitle LIMIT 0 , 30
what is it?Which version of AS do you use ? Could you explain the issue and results. Thanks.
all version of ajaxsearch dont work with modx-0.9.6.3-rc1