- Issue created by @GarChris
I'm getting "Syntax error or access violation" on the Opigno calendar View "Week" on a new install of Opigno.
Website Info:
Drupal: 9.5.11
PROFILE: Opigno LMS 3.1.0
PHP: 8.1.13
Memory limit: 128M
Web Server: nginx/1.23.2
Database: 10.6.18-MariaDB-0ubuntu0.22.04.1
The following error is present:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'range_intersects '202426')) AND (("opigno_calendar_event_field_data"."status"...' at line 8: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "opigno_calendar_event_field_data" "opigno_calendar_event_field_data" LEFT JOIN "opigno_calendar_event__date_daterange" "opigno_calendar_event__date_daterange" ON opigno_calendar_event_field_data.id = opigno_calendar_event__date_daterange.entity_id AND opigno_calendar_event__date_daterange.deleted = :views_join_condition_0 LEFT JOIN "opigno_calendar_event__7d784727b3" "opigno_calendar_event__7d784727b3" ON opigno_calendar_event_field_data.id = opigno_calendar_event__7d784727b3.entity_id WHERE ((DATE_FORMAT((opigno_calendar_event__date_daterange.date_daterange_value + INTERVAL -14400 SECOND), '%Y%v') range_intersects :opigno_calendar_event__date_daterange_date_daterange_value_year_week)) AND (("opigno_calendar_event_field_data"."status" = :db_condition_placeholder_0) AND (("opigno_calendar_event__7d784727b3"."field_calendar_event_members_target_id" IS NULL) OR ("opigno_calendar_event__7d784727b3"."field_calendar_event_members_target_id" = :db_condition_placeholder_1)))) "subquery"; Array ( [:opigno_calendar_event__date_daterange_date_daterange_value_year_week] => 202426 [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:views_join_condition_0] => 0 )
Active
3.1
Code