Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/wwwtrir/public_html/classes/db/db.php on line 43

MySQL Error Occurred

Error Message:
1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wwwtrir_shopping.C.cat_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT DISTINCT(I.productId), C.cat_id, I.productCode, I.description, I.image, I.price,, I.popularity, I.sale_price, I.stock_level, I.useStockLevel FROM CubeCart_cats_idx AS C INNER JOIN CubeCart_inventory AS I ON C.productId = I.productId WHERE I.disabled = '0' AND I.sale_price != 0 AND C.cat_id > 0 GROUP BY I.productId