• FAQs
  • Login
  • Register
  • Male
    Female
    Other
Advertise

Films

Announcements

    Database ERROR HERE: Invalid SQL: select film.id as id,meta_data.name as url, film.annoucements_title as title, film.annoucements_description as annoucements_description,film.original_title as original_title, film.english_title as english_title, film.annoucements_image_use_poster as annoucements_image_use_poster, film.announcements_detail as announcements_detail, film.announcements_start_date as announcements_start_date, film.announcements_stop_date as announcements_stop_date, film_images.image_name as image_name , UNIX_TIMESTAMP(film.announcements_start_date) as mys, (select count(film_people.dir_age) from film_people where film_people.film_id=film.id AND dir_age='2' ) as made_by_kid from film left join meta_data on (meta_data.type='film' AND meta_data.primay_key_id=film.id) left join film_images on (film_images.film_id=film.id AND order_by=1) where film.annoucements_title!='' AND film.status='2' AND film.target_audience_id='1' AND 1573516800>=UNIX_TIMESTAMP(film.announcements_start_date) AND 1573516800<=UNIX_TIMESTAMP(film.announcements_stop_date) group by film.id order by film.announcements_start_date desc limit 0,3
    MySQL error :1055  Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ccfsouth_users.meta_data.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    Session halted.