• user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crtda.node_data_field_country.field_country_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(node.nid) AS nids, node_data_field_country.field_country_value AS country, FROM_UNIXTIME(node.created,'%e-%m-%Y') AS node_created, FROM_UNIXTIME(node.created,'%e-%m') AS node_created2 FROM node node LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 2 LEFT JOIN content_type_petition_signature node_data_field_petition ON node.vid = node_data_field_petition.vid LEFT JOIN content_type_petition_signature node_data_field_country ON node.vid = node_data_field_country.vid WHERE (node.status = 1) AND (node.type in ('petition_signature')) AND (flag_content_node.uid IS NOT NULL) AND (node_data_field_petition.field_petition_nid = 14682) group by node_created ORDER BY node.nid ASC in /var/www/www.crtda.org.lb/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc(223) : runtime-created function on line 25.
  • user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crtda.node.created' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT count(node.nid) AS nids, node_data_field_country.field_country_value AS country, FROM_UNIXTIME(node.created,'%e-%m-%Y') AS node_created FROM node node LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 2 LEFT JOIN content_type_petition_signature node_data_field_petition ON node.vid = node_data_field_petition.vid LEFT JOIN content_type_petition_signature node_data_field_country ON node.vid = node_data_field_country.vid WHERE (node.status = 1) AND (node.type in ('petition_signature')) AND (flag_content_node.uid IS NOT NULL) AND (node_data_field_petition.field_petition_nid = 14682) group by country ORDER BY country ASC in /var/www/www.crtda.org.lb/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc(223) : runtime-created function on line 74.

الإحصائيات