Jump to content

New events page just gives an error-msg


Akademika
 Share

Recommended Posts

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

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...