Лаки Беггар/Lucky Beggar / Питомники / Sobakino

Из этой же категории

Теги

SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sobakino_db.cp.producer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /home/admin/sobakino.com/public_html/plugins/dao/classes/modules/catalog/mapper/Catalog.mapper.class.php line 0
Array ( [code] => 1055 [message] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sobakino_db.cp.producer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [query] => SELECT cp.*, count(cp.producer_name) as count FROM prefix_catalog_producer as cp, prefix_catalog_item as i WHERE i.producer_id=cp.producer_id AND i.item_publish=1 AND i.catalog_id=13 GROUP BY cp.producer_name ORDER BY count desc LIMIT 0, 70 [context] => /home/admin/sobakino.com/public_html/plugins/dao/classes/modules/catalog/mapper/Catalog.mapper.class.php line 0 )