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