2 posts / 0 new
Last post
Digitalbalog
Digitalbalog's picture
Offline
Last seen: 5 months 5 days ago
Joined: 11/05/2018
calendar update issue

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

axel
Offline
Last seen: 3 days 3 hours ago
Staff
Joined: 09/25/2013
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)