Error message
PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'kagapjzt_bmsnew.n.sticky' which is not in SELECT list; this is incompatible with DISTINCT: SELECT DISTINCT n.nid AS nid, n.title AS title, n.created AS created, fd.field_calendar_event_value AS field_calendar_event_value
FROM
{node} n
LEFT OUTER JOIN {field_data_field_calendar_event} fd ON fd.entity_id = n.nid
WHERE (n.status = :db_condition_placeholder_0) AND (DATE(field_calendar_event_value) = :date) AND (n.type IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5))
ORDER BY n.sticky DESC, n.created DESC; Array
(
[:db_condition_placeholder_0] => 1
[:date] => 2019.03.11
[:db_condition_placeholder_1] => calendar_event
[:db_condition_placeholder_2] => 0
[:db_condition_placeholder_3] => 0
[:db_condition_placeholder_4] => 0
[:db_condition_placeholder_5] => 0
)
in pretty_calendar_select_nodes() (line 557 of /home2/kagapjzt/public_html/bmshri.org/sites/all/modules/pretty_calendar/pretty_calendar.module).
Error
The website encountered an unexpected error. Please try again later.