ajaxSearchが動作しない
Posted: 2019年5月09日(木) 19:44
もう一点、AjaxSearchも動かないようです。
ajaxモード・non-ajaxモード共に下記のようなエラーになります。
よろしくお願いいたします。
« MODX Parse Error »
MODX encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ntv1.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by »
Backtrace
1 $modx->executeParser()
index.php on line 124
2 $modx->prepareResponse()
manager/includes/document.parser.class.inc.php on line 271
3 $modx->outputContent()
manager/includes/document.parser.class.inc.php on line 534
4 $modx->parseNonCachedSnippets()
manager/includes/document.parser.class.inc.php on line 615
5 $modx->parseDocumentSource()
manager/includes/document.parser.class.inc.php on line 740
6 $modx->invokeEvent()
manager/includes/document.parser.class.inc.php on line 2794
7 $modx->evalPlugin()
manager/includes/document.parser.class.inc.php on line 3930
8 eval()
manager/includes/document.parser.class.inc.php on line 2170
9 PHxParser->OnParseDocument()
manager/includes/document.parser.class.inc.php(2170) : eval()'d code on line 24
10 PHxParser->Parse()
assets/plugins/phx/phx.parser.class.inc.php on line 47
11 PHxParser->ParseValues()
assets/plugins/phx/phx.parser.class.inc.php on line 65
12 $modx->evalSnippets()
assets/plugins/phx/phx.parser.class.inc.php on line 140
13 $modx->_get_snip_result()
manager/includes/document.parser.class.inc.php on line 2315
14 $modx->evalSnippet()
manager/includes/document.parser.class.inc.php on line 2377
15 eval()
manager/includes/document.parser.class.inc.php on line 2238
16 require()
manager/includes/document.parser.class.inc.php(2238) : eval()'d code on line 17
17 AjaxSearch->run()
assets/snippets/ajaxSearch/snippet.ajaxSearch.php on line 409
18 AjaxSearchCtrl->run()
assets/snippets/ajaxSearch/classes/ajaxSearch.class.inc.php on line 101
19 AjaxSearchResults->getSearchResults()
assets/snippets/ajaxSearch/classes/ajaxSearchCtrl.class.inc.php on line 70
20 AjaxSearchRequest->doSearch()
assets/snippets/ajaxSearch/classes/ajaxSearchResults.class.inc.php on line 99
21 DBAPI->query()
assets/snippets/ajaxSearch/classes/ajaxSearchRequest.class.inc.php on line 65
22 $modx->__call()
manager/includes/extenders/dbapi/mysqli.inc.php on line 188
ajaxモード・non-ajaxモード共に下記のようなエラーになります。
よろしくお願いいたします。
« MODX Parse Error »
MODX encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ntv1.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by »
Backtrace
1 $modx->executeParser()
index.php on line 124
2 $modx->prepareResponse()
manager/includes/document.parser.class.inc.php on line 271
3 $modx->outputContent()
manager/includes/document.parser.class.inc.php on line 534
4 $modx->parseNonCachedSnippets()
manager/includes/document.parser.class.inc.php on line 615
5 $modx->parseDocumentSource()
manager/includes/document.parser.class.inc.php on line 740
6 $modx->invokeEvent()
manager/includes/document.parser.class.inc.php on line 2794
7 $modx->evalPlugin()
manager/includes/document.parser.class.inc.php on line 3930
8 eval()
manager/includes/document.parser.class.inc.php on line 2170
9 PHxParser->OnParseDocument()
manager/includes/document.parser.class.inc.php(2170) : eval()'d code on line 24
10 PHxParser->Parse()
assets/plugins/phx/phx.parser.class.inc.php on line 47
11 PHxParser->ParseValues()
assets/plugins/phx/phx.parser.class.inc.php on line 65
12 $modx->evalSnippets()
assets/plugins/phx/phx.parser.class.inc.php on line 140
13 $modx->_get_snip_result()
manager/includes/document.parser.class.inc.php on line 2315
14 $modx->evalSnippet()
manager/includes/document.parser.class.inc.php on line 2377
15 eval()
manager/includes/document.parser.class.inc.php on line 2238
16 require()
manager/includes/document.parser.class.inc.php(2238) : eval()'d code on line 17
17 AjaxSearch->run()
assets/snippets/ajaxSearch/snippet.ajaxSearch.php on line 409
18 AjaxSearchCtrl->run()
assets/snippets/ajaxSearch/classes/ajaxSearch.class.inc.php on line 101
19 AjaxSearchResults->getSearchResults()
assets/snippets/ajaxSearch/classes/ajaxSearchCtrl.class.inc.php on line 70
20 AjaxSearchRequest->doSearch()
assets/snippets/ajaxSearch/classes/ajaxSearchResults.class.inc.php on line 99
21 DBAPI->query()
assets/snippets/ajaxSearch/classes/ajaxSearchRequest.class.inc.php on line 65
22 $modx->__call()
manager/includes/extenders/dbapi/mysqli.inc.php on line 188