Forums
Hello,
installed opigno_lms-8.x-rc2.tar.gz english on Ubuntu 16 with PHP 7.2 andDrupal core 8.6.1
the calendar worked fine intially, showing date, week, month and year on request.
After running the current update suggestions (incl. calendar 8.x-1.x-dev) and refreshing the database the calendar functions were gone in all three states, maintenance mode, active user and logged out.
Requesting calendar week, the following error is reported
Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Opigno calendar[opigno_calendar]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range_intersects '201811')) AND (opigno_calendar_event_field_data.status = '1'))' at line 2: 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 WHERE ((DATE_FORMAT((opigno_calendar_event__date_daterange.date_daterange_value + INTERVAL 3600 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)) subquery; Array ( [:opigno_calendar_event__date_daterange_date_daterange_value_year_week] => 201811 [:db_condition_placeholder_0] => 1 [:views_join_condition_0] => 0 ) in Drupal\views\Plugin\views\query\Sql->execute() (line 1543 of /var/www/vhosts/h2809481.stratoserver.net/httpdocs/e81109/core/modules/views/src/Plugin/views/query/Sql.php).
calendar day or year request result: page not found (h2809481.stratoserver.net/e81109/opigno/calendar/day/201811 et al.)
calendar mont request result in showing first week days in a thick border including << and >> but without function.
Thank you for hints to fix it.
Kind regards
Hi
Hi
If you are using Opigno LMS, you should just update with the new releases of Opigno LMS.
Updating modules individually will result in problems of compatibility like the one you encounter.
Before releasing a new version of Opigno LMS we update all the modules and check + fix all the compatibility problems.
For the moment you can just revert to the code included in RC2 and then upgrade to the next version (that should be released around the end of the month)