WordPress.org

Ready to get started?Download WordPress

Forums

Query Multiple Taxonomies
plugin error with mysql settings ONLY_FULL_GROUP_BY (1 post)

  1. uradvd
    Member
    Posted 1 year ago #

    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!

    http://wordpress.org/extend/plugins/query-multiple-taxonomies/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.