Akademika

Patch applied, but unfortunatly did not fix our issue 😕

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

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

I agree. I am looking for the same thing for our community.

Hi! Forms looks like a good fit for us. But can you confirm that it would work for us? We use IPB as an internal community for our chain of stores, and our use-case is this: We want a form on a seperate page, where we want people to fill in info about gifts / prizes they give out in their respective store, and when they hit save, we want to relay that information to accounting via email.