Роман Аяпергенов (Все сообщения пользователя)

SET sql_mode = ''; или 
SET sql_mode =  или
sql_mode = '';

mysql> SET sql_mode = '';

MySQL Query Error: SEL ECT b.PRODUCT_ID, b.NAME,  ifnull(b.CATALOG_XML_ID, '') CATALOG_XML_ID, b.PRODUCT_XML_ID,  SUM(b.PRICE*b.QUANTITY) as PRICE, AVG(b.PRICE) as AVG_PRICE,  SUM(b.QUANTITY) as QUANTITY, b.CURRENCY  FR OM b_sale_basket b  INNER JOIN b_sale_order O ON (b.ORDER_ID = O.ID)  WHERE   b.ORDER_ID is not null   AND  O.DATE_INSERT >= '2016-07-26 00:00:00' AND UPPER(O.PAYED) like upper('Y')  GROUP BY b.PRODUCT_ID, ifnull(b.CATALOG_XML_ID, ''), b.PRODUCT_XML_ID,  b.CURRENCY   ORDER BY PRICE DESC LIMIT 5[[1055] Expression #2 of SELECT list is not in GROUP BY  clause and contains nonaggregated column 'bitrixstudy.b.NAME' which is  not functionally dependent on columns in GROUP BY clause; this is  incompatible with sql_mode=only_full_group_by]

<?
    $APPLICATION->setPageProperty('slider1', 'main1.jpg');
    $APPLICATION->setPageProperty('link1', '/about_us');
?>