New events page just gives an error-msg

[Akademika]

Trying to access https://mycommunity.example/events/ 

Just gives me the following error: 

SELECT calendar_events.*, ( 3959 * acos( cos( radians(62,2042) ) * cos( radians( event_latitude ) ) * cos( radians( event_longitude ) - radians( 6,1205 ) ) + sin( radians( 62,2042 ) ) * sin( radians( event_latitude) ) ) ) AS distance, author.*, core_tags_cache.tag_cache_text FROM `calendar_events`  LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('calendar;calendar;',calendar_events.event_id))  LEFT JOIN `core_members` AS `author` ON author.member_id = calendar_events.event_member_id WHERE ( event_online = 0 ) AND ( event_location IS NOT NULL ) AND event_recurring IS NULL AND ( 
                    ( event_end_date IS NULL AND DATE( event_start_date ) >= '2022-10-14' AND DATE( event_start_date ) <= '2023-10-14' AND event_all_day=1 )
                    OR
                    ( event_end_date IS NOT NULL AND DATE( event_start_date ) <= '2023-10-14' AND DATE( event_end_date ) >= '2022-10-14' AND event_all_day=1 )
                    OR
                    ( event_end_date IS NULL AND event_start_date >= '2022-10-14 00:00:00' AND event_start_date <= '2023-10-13 22:00:00' AND event_all_day=0 )
                    OR
                    ( event_end_date IS NOT NULL AND event_start_date <= '2023-10-13 22:00:00' AND event_end_date >= '2022-10-14 00:00:00' AND event_all_day=0 )
                ) AND event_latitude IS NOT NULL AND event_longitude IS NOT NULL AND calendar_events.event_approved < 2 AND calendar_events.event_approved!=-2 AND calendar_events.event_approved!=-3 AND calendar_events.event_calendar_id IN(1,2,3) HAVING distance < 500 ORDER BY distance ASC
IPS\Db\Exception: Incorrect parameter count in the call to native function 'radians' (1582)
#0 /var/www/html/107305/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*r273762::r273...', Array, true)
#1 /var/www/html/107305/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 [internal function]: IteratorIterator->rewind()
#4 /var/www/html/107305/applications/calendar/sources/Event/Event.php(2164): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#5 /var/www/html/107305/applications/calendar/modules/front/calendar/view.php(503): IPS\calendar\_Event::retrieveEvents(Object(IPS\calendar\Date), Object(IPS\calendar\Date), NULL, 6, false, Object(IPS\Member), NULL, false, Array, false)
#6 /var/www/html/107305/applications/calendar/modules/front/calendar/view.php(126): IPS\calendar\modules\front\calendar\_view->_viewOverview(Object(IPS\Helpers\Form))
#7 /var/www/html/107305/system/Dispatcher/Controller.php(118): IPS\calendar\modules\front\calendar\_view->manage()
#8 /var/www/html/107305/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#9 /var/www/html/107305/index.php(13): IPS\_Dispatcher->run()
#10 {main}

I've cleared caches etc. .

[Marc Stridgen]

Please ensure we can access that location with the user we just created, and we can take a look for you

[Akademika]

Hi Marc! I can't see any new members created 🙂

[Marc Stridgen]

We actually no longer need the account there.

Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.

 

[Marc Stridgen]

There has been a patch created for this issue. If you go to Support within your admin CP, you will see "Optional" updates, which will fix this problem.

[Akademika]

Patch applied, but unfortunatly did not fix our issue 😕

[Jim M]

Please be advised I have moved this to a ticket so we can further investigate. Please watch your email for further correspondence.

[Marc Stridgen]

Another patch has been released for this, so if you are still having problems, please see the new patch

[Anja Müller]

3 hours ago, Marc Stridgen said:

Another patch has been released for this, so if you are still having problems, please see the new patch

Thank you. Worked in my community 🙂 

[Mark H]

Glad to hear the problem is resolved. 🙂