poc_database.php

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

SELECT `bliss_articles_master`.id as article_id,`bliss_articles_items`.id as item_id,`bliss_articles_items`.title,`bliss_articles_items`.first_line,`bliss_articles_items`.alias,text,excerpt,category_id,`bliss_articles_categories`.alias AS category_alias,`bliss_articles_items`.created_date,`bliss_articles_items`.created_by,start_date,end_date,active,allow_comments,display_image,`bliss_articles_master`.image,`bliss_articles_master`.image_size,count(bliss_articles_items.id) as num_of_languages,`bliss_users`.userId,`bliss_users`.userName,`bliss_users`.firstName as first_name,`bliss_users`.lastName as last_name,link_url,link_directly FROM `bliss_articles_master` JOIN `bliss_articles_items` ON (`bliss_articles_master`.id=`bliss_articles_items`.article_id) LEFT JOIN `bliss_users` ON `bliss_users`.userId=`bliss_articles_items`.created_by LEFT JOIN `bliss_articles_categories` ON `bliss_articles_categories`.id=`bliss_articles_master`.category_id WHERE `bliss_articles_items`.language='sv' AND `bliss_articles_master`.active = '1' AND category_id IN (1) AND start_date < unix_timestamp() AND (end_date > unix_timestamp() OR end_date IS NULL) GROUP BY `bliss_articles_master`.id ORDER BY start_date DESC LIMIT 100, 20;

poc_database.php

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

SELECT `bliss_articles_master`.id as article_id,`bliss_articles_items`.id as item_id,`bliss_articles_items`.title,`bliss_articles_items`.first_line,`bliss_articles_items`.alias,text,excerpt,category_id,`bliss_articles_categories`.alias AS category_alias,`bliss_articles_items`.created_date,`bliss_articles_items`.created_by,start_date,end_date,active,allow_comments,display_image,`bliss_articles_master`.image,`bliss_articles_master`.image_size,count(bliss_articles_items.id) as num_of_languages,`bliss_users`.userId,`bliss_users`.userName,`bliss_users`.firstName as first_name,`bliss_users`.lastName as last_name,link_url,link_directly FROM `bliss_articles_master` JOIN `bliss_articles_items` ON (`bliss_articles_master`.id=`bliss_articles_items`.article_id) LEFT JOIN `bliss_users` ON `bliss_users`.userId=`bliss_articles_items`.created_by LEFT JOIN `bliss_articles_categories` ON `bliss_articles_categories`.id=`bliss_articles_master`.category_id WHERE `bliss_articles_items`.language='sv' AND `bliss_articles_master`.active = '1' AND category_id IN (1) AND start_date < unix_timestamp() AND (end_date > unix_timestamp() OR end_date IS NULL) GROUP BY `bliss_articles_master`.id ORDER BY start_date DESC LIMIT 5, 1;

poc_database.php

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

SELECT `bliss_articles_master`.id as article_id,`bliss_articles_items`.id as item_id,`bliss_articles_items`.title,`bliss_articles_items`.first_line,`bliss_articles_items`.alias,text,excerpt,category_id,`bliss_articles_categories`.alias AS category_alias,`bliss_articles_items`.created_date,`bliss_articles_items`.created_by,start_date,end_date,active,allow_comments,display_image,`bliss_articles_master`.image,`bliss_articles_master`.image_size,count(bliss_articles_items.id) as num_of_languages,`bliss_users`.userId,`bliss_users`.userName,`bliss_users`.firstName as first_name,`bliss_users`.lastName as last_name,link_url,link_directly FROM `bliss_articles_master` JOIN `bliss_articles_items` ON (`bliss_articles_master`.id=`bliss_articles_items`.article_id) LEFT JOIN `bliss_users` ON `bliss_users`.userId=`bliss_articles_items`.created_by LEFT JOIN `bliss_articles_categories` ON `bliss_articles_categories`.id=`bliss_articles_master`.category_id WHERE `bliss_articles_items`.language='sv' AND `bliss_articles_master`.active = '1' AND category_id IN (1) AND start_date < unix_timestamp() AND (end_date > unix_timestamp() OR end_date IS NULL) GROUP BY `bliss_articles_master`.id ORDER BY start_date DESC LIMIT 21, 4;