INVALID SQL: 1231 : Variable 'sql_mode' can't be set to the value of 'MYSQL40' SQL QUERY FAILURE:SET sql_mode = 'MYSQL40' INVALID SQL: 1055 : Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sprayequ_sprayequip1.lng_c.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL QUERY FAILURE:SELECT xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages, xcart_countries LEFT JOIN xcart_languages as lng_c ON lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' LEFT JOIN xcart_languages as lng_l ON lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) WHERE xcart_languages.code = xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code Spray Equipment Packages :: Help zone
Quick
Contact
