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 = 10 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 = 10 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
)
,
„r4b6da4a90b”

)


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 = 10 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 = 10 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 = 10 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 = 10 GROUP BY est.seotud_id;”

)


shop_class->products(

„10”

)


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(

)