/home/viters/public_html/classes/Modules.php => 351
Modules(Video_Categories)::show_list() QUERY= SELECT CTG.*,IMGCTG.image_id as is_empty FROM `video_categories` AS CTG LEFT JOIN `video_category` AS IMGCTG ON IMGCTG.category_id=CTG.ID WHERE CTG.parent_id='1' AND CTG.active=1 AND CTG.title NOT LIKE 'private' GROUP BY CTG.ID ORDER BY order_num DB Error: unknown error
SELECT CTG.*,IMGCTG.image_id  as is_empty FROM `video_categories` AS CTG
   	  	   				                      LEFT JOIN `video_category` AS IMGCTG ON IMGCTG.category_id=CTG.ID
                      	  	    				WHERE CTG.parent_id='1' AND CTG.active=1 AND CTG.title NOT LIKE 'private'  GROUP BY CTG.ID ORDER BY order_num  [nativecode=1055 ** Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'viter_viter.IMGCTG.image_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]