Expression #56 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'procesdesk_2107.c.positie' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Array ( [0] => Array ( [file] => /var/www/procesdesk.nl/www/ba59f661c01dc48dcc3f7396c35ce8e5/inc/functions.php [line] => 2193 [function] => queryError [args] => Array ( [0] => Expression #56 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'procesdesk_2107.c.positie' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1] => SELECT p.*, m.merk, wcv.titel AS voorraad_titel, wcv.kleur AS voorraad_kleur, wcv.voorraad_aantallen_tonen AS voorraad_aantallen_tonen, wca.titel AS aanbodstadia, wca.id AS aanbodstadia_id, c.positie AS productpositie, cb.hash AS bewerkpadhash FROM webwinkel_product_categorie c, webwinkel_product p LEFT JOIN webwinkel_merk m ON m.id = p.merk_id LEFT JOIN webwinkel_config_voorraad wcv ON p.voorraad_id = wcv.id LEFT JOIN webwinkel_config_aanbodstadia wca ON p.status_aanbieding = wca.id LEFT JOIN configuratie_bewerkpaden cb ON cb.tabel_id = p.id AND cb.tabel_naam = 'webwinkel_product' WHERE 1 AND c.product_id = p.id AND p.status > 0 AND p.verwijderd = 0 AND c.categorie_id = '1' GROUP BY p.id ORDER BY productpositie ASC [2] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 7.4.3-4ubuntu2.17 [client_version] => 70403 [connect_errno] => 0 [connect_error] => [errno] => 1055 [error] => Expression #56 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'procesdesk_2107.c.positie' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [error_list] => Array ( [0] => Array ( [errno] => 1055 [sqlstate] => 42000 [error] => Expression #56 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'procesdesk_2107.c.positie' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ) ) [field_count] => 6 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 8.0.32-0ubuntu0.20.04.2 [server_version] => 80032 [sqlstate] => 42000 [protocol_version] => 10 [thread_id] => 15240 [warning_count] => 0 ) ) ) [1] => Array ( [file] => /var/www/procesdesk.nl/www/includes/functions/webwinkel.functions.php [line] => 1021 [function] => getArray [args] => Array ( [0] => SELECT p.*, m.merk, wcv.titel AS voorraad_titel, wcv.kleur AS voorraad_kleur, wcv.voorraad_aantallen_tonen AS voorraad_aantallen_tonen, wca.titel AS aanbodstadia, wca.id AS aanbodstadia_id, c.positie AS productpositie, cb.hash AS bewerkpadhash FROM webwinkel_product_categorie c, webwinkel_product p LEFT JOIN webwinkel_merk m ON m.id = p.merk_id LEFT JOIN webwinkel_config_voorraad wcv ON p.voorraad_id = wcv.id LEFT JOIN webwinkel_config_aanbodstadia wca ON p.status_aanbieding = wca.id LEFT JOIN configuratie_bewerkpaden cb ON cb.tabel_id = p.id AND cb.tabel_naam = 'webwinkel_product' WHERE 1 AND c.product_id = p.id AND p.status > 0 AND p.verwijderd = 0 AND c.categorie_id = '1' GROUP BY p.id ORDER BY productpositie ASC [1] => ) ) [2] => Array ( [file] => /var/www/procesdesk.nl/www/includes/functions/webwinkel.rendercontent.php [line] => 192 [function] => shopGetProducts [args] => Array ( [0] => 1 ) ) [3] => Array ( [file] => /var/www/procesdesk.nl/www/includes/functions/webwinkel.rendercontent.php [line] => 240 [function] => shopProcesDeskTarieven [args] => Array ( ) ) [4] => Array ( [file] => /var/www/procesdesk.nl/www/includes/functions/inc.rendercontent.php [line] => 144 [args] => Array ( [0] => /var/www/procesdesk.nl/www/includes/functions/webwinkel.rendercontent.php ) [function] => include ) [5] => Array ( [file] => /var/www/procesdesk.nl/www/index.php [line] => 53 [args] => Array ( [0] => /var/www/procesdesk.nl/www/includes/functions/inc.rendercontent.php ) [function] => include_once ) )
/var/www/procesdesk.nl/www/ba59f661c01dc48dcc3f7396c35ce8e5/inc/functions.php > 3369