plugin error with mysql settings ONLY_FULL_GROUP_BY
-
SET sql_mode := CONCAT(@@sql_mode,',ONLY_FULL_GROUP_BY');
PHP message: База данных WordPress возвратила ошибку Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause в ответ на запрос SELECT COUNT(DISTINCT hmm_posts.ID) FROM hmm_posts INNER JOIN hmm_term_relationships ON (hmm_posts.ID = hmm_term_relationships.object_id) INNER JOIN hmm_term_relationships AS tt1 ON (hmm_posts.ID = tt1.object_id) WHERE 1=1 AND ( hmm_term_relationships.term_taxonomy_id IN (87) AND tt1.term_taxonomy_id IN (60,153,160,162,164,215,216,222,223,225,227) ) AND hmm_posts.post_type IN ('product') AND (hmm_posts.post_status = 'publish') ORDER BY hmm_posts.post_date DESC , выполненный require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/gridmarket/mp_category.php'), get_header, locate_template, load_template, require_once('/themes/gridmarket/header.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, scbWidget->wid... PHP message: База данных WordPress возвратила ошибку Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause в ответ на запрос SELECT COUNT(DISTINCT hmm_posts.ID) FROM hmm_post 2013/05/29 10:30:14 [error] 31284#0: *7810 FastCGI sent in stderr: "tionships.object_id) INNER JOIN hmm_term_relationships AS tt1 ON (hmm_posts.ID = tt1.object_id) WHERE 1=1 AND ( hmm_term_relationships.term_taxonomy_id IN (172) AND tt1.term_taxonomy_id IN (60,153,160,162,164,215,216,222,223,225,227) ) AND hmm_posts.post_type IN ('product') AND (hmm_posts.post_status = 'publish') ORDER BY hmm_posts.post_date DESC , выполненный require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/gridmarket/mp_category.php'), get_header, locate_template, load_template, require_once('/themes/gridmarket/header.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, scbWidget->wi...
off ONLY_FULL_GROUP_BY in mysql conf work fine!
https://www.ads-software.com/extend/plugins/query-multiple-taxonomies/
- The topic ‘plugin error with mysql settings ONLY_FULL_GROUP_BY’ is closed to new replies.