Skip to main content

Najlepšie články

  • user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'boinc_drupal.votingapi_cache_node_percent_vote_average.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value, votingapi_vote_node_percent_vote_curuser.value AS votingapi_vote_node_percent_vote_curuser_value, node_counter.totalcount AS node_counter_totalcount, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m%d%H%i') AS node_created_minute FROM drupal_node node INNER JOIN drupal_votingapi_cache votingapi_cache_node_count ON node.nid = votingapi_cache_node_count.content_id AND (votingapi_cache_node_count.content_type = 'node' AND votingapi_cache_node_count.function = 'count') INNER JOIN drupal_votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average') LEFT JOIN drupal_votingapi_vote votingapi_vote_node_percent_vote_curuser ON node.nid = votingapi_vote_node_percent_vote_curuser.content_id AND (votingapi_vote_node_percent_vote_curuser.content_type = 'node' AND votingapi_vote_node_percent_vote_curuser.value_type = 'percent' AND votingapi_vote_node_percent_vote_curuser.tag = 'vote' AND votingapi_vote_node_percent_vote_curuser.uid = '0') LEFT JOIN drupal_workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN drupal_node_counter node_counter ON node.nid = node_counter.nid INNER JOIN drupal_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.type in ('story')) AND (node.status = 1) AND (workflow_node.sid not in (1, 2, 3)) AND (votingapi_cache_node_count.value >= 5) AND (votingapi_cache_node_percent_vote_average.value > 40) )GROUP BY nid ORDER BY votingapi_cache_node_percent_vote_average_value DESC, votingapi_vote_node_percent_vote_curuser_value DESC, node_counter_totalcount DESC, node_created_minute DESC ) count_alias in /data/webroot/sk.boinc.www/sites/all/modules/views/includes/view.inc on line 805.
  • user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'boinc_drupal.votingapi_cache_node_percent_vote_average.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT(node.nid) AS nid, votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value, votingapi_vote_node_percent_vote_curuser.value AS votingapi_vote_node_percent_vote_curuser_value, node_counter.totalcount AS node_counter_totalcount, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m%d%H%i') AS node_created_minute FROM drupal_node node INNER JOIN drupal_votingapi_cache votingapi_cache_node_count ON node.nid = votingapi_cache_node_count.content_id AND (votingapi_cache_node_count.content_type = 'node' AND votingapi_cache_node_count.function = 'count') INNER JOIN drupal_votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average') LEFT JOIN drupal_votingapi_vote votingapi_vote_node_percent_vote_curuser ON node.nid = votingapi_vote_node_percent_vote_curuser.content_id AND (votingapi_vote_node_percent_vote_curuser.content_type = 'node' AND votingapi_vote_node_percent_vote_curuser.value_type = 'percent' AND votingapi_vote_node_percent_vote_curuser.tag = 'vote' AND votingapi_vote_node_percent_vote_curuser.uid = '0') LEFT JOIN drupal_workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN drupal_node_counter node_counter ON node.nid = node_counter.nid INNER JOIN drupal_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.type in ('story')) AND (node.status = 1) AND (workflow_node.sid not in (1, 2, 3)) AND (votingapi_cache_node_count.value >= 5) AND (votingapi_cache_node_percent_vote_average.value > 40) )GROUP BY nid ORDER BY votingapi_cache_node_percent_vote_average_value DESC, votingapi_vote_node_percent_vote_curuser_value DESC, node_counter_totalcount DESC, node_created_minute DESC LIMIT 0, 10 in /data/webroot/sk.boinc.www/sites/all/modules/views/includes/view.inc on line 810.

Žiadne články nie sú ohodnotené (aspoň piatimi hlasmi)