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. .

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

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

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.

 

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.

Patch applied, but unfortunatly did not fix our issue 😕

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

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

 

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 🙂 

Glad to hear the problem is resolved. 🙂