• FAQs
  • Login
  • Register
  • Male
    Female
    Other
Advertise

Organisation

Announcements

    Database ERROR HERE: Invalid SQL: select organization.id as id, organization.organization_name as organization_name, organization.acronym as acronym, meta_data.name as url, organization.annoucements_title as title, organization.annoucements_description as annoucements_description,organization.original_title as original_title, organization.announcements_detail as announcements_detail, organization.announcements_start_date as announcements_start_date, organization.announcements_stop_date as announcements_stop_date, organization.logo as image_name , UNIX_TIMESTAMP(organization.announcements_start_date) as mys from organization left join meta_data on (meta_data.type='org' AND meta_data.primay_key_id=organization.id) WHERE organization.annoucements_title!='' AND 1621209600>=UNIX_TIMESTAMP(organization.announcements_start_date) AND 1621209600<=UNIX_TIMESTAMP(organization.announcements_stop_date) group by organization.id order by organization.announcements_start_date desc limit 0,3
    MySQL error :1055  Expression #4 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.