Veateade : Error no: 1055.
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'info_estl_ee_estl.cs.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT est.seotud_id, cs.id as sisu_id
FROM epood__seotud_tooted as est
INNER JOIN epood__grupp as eg ON eg.epood_id = est.seotud_id
INNER JOIN cms__sisu as cs ON cs.id = eg.sisu_id
WHERE cs.keel = '7' AND est.epood_id = 5
GROUP BY est.seotud_id;
Asukohad :
Rida: 0009 @ /var/www/vhosts/estl.ee/httpdocs/include/core/core_debug.php
Rida: 0097 @ /var/www/vhosts/estl.ee/httpdocs/include/core/core_database.php
Rida: 0123 @ /var/www/vhosts/estl.ee/httpdocs/include/core/core_database.php
Rida: 0158 @ /var/www/vhosts/estl.ee/httpdocs/include/core/core_database.php
Rida: 0177 @ /var/www/vhosts/estl.ee/httpdocs/include/core/core_database.php
Rida: 0037 @ /var/www/vhosts/estl.ee/httpdocs/include/shop_class.php
Rida: 0014 @ /var/www/vhosts/estl.ee/httpdocs/include/shop_class.php
Rida: 0000 @ *Undefined*
Rida: 0038 @ /var/www/vhosts/estl.ee/httpdocs/include/functions/core_functions.php(31) : eval()'d code
Rida: 0358 @ /var/www/vhosts/estl.ee/httpdocs/include/index_class.php
Rida: 0358 @ /var/www/vhosts/estl.ee/httpdocs/include/index_class.php
Funktsioonid :
Debug::log(
„Error no: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'info_estl_ee_estl.cs.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT est.seotud_id, cs.id as sisu_id FROM epood__seotud_tooted as est INNER JOIN epood__grupp as eg ON eg.epood_id = est.seotud_id INNER JOIN cms__sisu as cs ON cs.id = eg.sisu_id WHERE cs.keel = '7' AND est.epood_id = 5 GROUP BY est.seotud_id;”
, Array
(
[0] => 0
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
[8] => 8
[9] => 9
[10] => 10
)
, „r092aa6c3fd”
)
Debug::call(
„Error no: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'info_estl_ee_estl.cs.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT est.seotud_id, cs.id as sisu_id FROM epood__seotud_tooted as est INNER JOIN epood__grupp as eg ON eg.epood_id = est.seotud_id INNER JOIN cms__sisu as cs ON cs.id = eg.sisu_id WHERE cs.keel = '7' AND est.epood_id = 5 GROUP BY est.seotud_id;”
, Array
(
[0] => 0
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
[8] => 8
[9] => 9
[10] => 10
)
)
MySqlDB->error(
5
)
MySqlDB->query(
„ SELECT est.seotud_id, cs.id as sisu_id FROM epood__seotud_tooted as est INNER JOIN epood__grupp as eg ON eg.epood_id = est.seotud_id INNER JOIN cms__sisu as cs ON cs.id = eg.sisu_id WHERE cs.keel = '7' AND est.epood_id = 5 GROUP BY est.seotud_id;”
, 5
, FALSE
)
MySqlDB->handleResult(
„ SELECT est.seotud_id, cs.id as sisu_id FROM epood__seotud_tooted as est INNER JOIN epood__grupp as eg ON eg.epood_id = est.seotud_id INNER JOIN cms__sisu as cs ON cs.id = eg.sisu_id WHERE cs.keel = '7' AND est.epood_id = 5 GROUP BY est.seotud_id;”
, FALSE
)
MySqlDB->fetch_assoc(
„ SELECT est.seotud_id, cs.id as sisu_id FROM epood__seotud_tooted as est INNER JOIN epood__grupp as eg ON eg.epood_id = est.seotud_id INNER JOIN cms__sisu as cs ON cs.id = eg.sisu_id WHERE cs.keel = '7' AND est.epood_id = 5 GROUP BY est.seotud_id;”
)
shop_class->products(
„5”
)
shop_class->start(
)
*Undefined**Undefined*call_user_func_array(
Array
(
[0] => shop_class Object
(
[act] => 6
)
[1] => start
)
, Array
(
)
)
FRONT->__call(
„start”
, Array
(
)
)
FRONT->start(
)