Jump to content

Photo Club Paris

Clients
  • Posts

    44
  • Joined

  • Last visited

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by Photo Club Paris

  1. Hi Marc,

    I have patch but the problem exist again 

    SELECT calendar_events.*, ( 3959 * acos( cos( radians(48,8649) ) * cos( radians( event_latitude ) ) * cos( radians( event_longitude ) - radians( 2,2752 ) ) + sin( radians( 48,8649 ) ) * 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-17' AND DATE( event_start_date ) <= '2023-10-17' AND event_all_day=1 )
    					OR
    					( event_end_date IS NOT NULL AND DATE( event_start_date ) <= '2023-10-17' AND DATE( event_end_date ) >= '2022-10-17' AND event_all_day=1 )
    					OR
    					( event_end_date IS NULL AND event_start_date >= '2022-10-17 00:00:00' AND event_start_date <= '2023-10-16 22:00:00' AND event_all_day=0 )
    					OR
    					( event_end_date IS NOT NULL AND event_start_date <= '2023-10-16 22:00:00' AND event_end_date >= '2022-10-17 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) 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/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery()
    #1 /var/www/html/forum/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/forum/applications/calendar/sources/Event/Event.php(2164): iterator_to_array()
    #5 /var/www/html/forum/applications/calendar/modules/front/calendar/view.php(503): IPS\calendar\_Event::retrieveEvents()
    #6 /var/www/html/forum/applications/calendar/modules/front/calendar/view.php(126): IPS\calendar\modules\front\calendar\_view->_viewOverview()
    #7 /var/www/html/forum/system/Dispatcher/Controller.php(118): IPS\calendar\modules\front\calendar\_view->manage()
    #8 /var/www/html/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
    #9 /var/www/html/forum/index.php(13): IPS\_Dispatcher->run()
    #10 {main}

    Stephane

  2. Hi,

     

    I have upgrade IPB to version 4.3 but now the calendar his broken 😞

    SELECT calendar_events.*, ( 3959 * acos( cos( radians(48,8649) ) * cos( radians( event_latitude ) ) * cos( radians( event_longitude ) - radians( 2,2752 ) ) + sin( radians( 48,8649 ) ) * 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-16' AND DATE( event_start_date ) <= '2023-10-16' AND event_all_day=1 )
    					OR
    					( event_end_date IS NOT NULL AND DATE( event_start_date ) <= '2023-10-16' AND DATE( event_end_date ) >= '2022-10-16' AND event_all_day=1 )
    					OR
    					( event_end_date IS NULL AND event_start_date >= '2022-10-16 00:00:00' AND event_start_date <= '2023-10-15 22:00:00' AND event_all_day=0 )
    					OR
    					( event_end_date IS NOT NULL AND event_start_date <= '2023-10-15 22:00:00' AND event_end_date >= '2022-10-16 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) 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/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery()
    #1 /var/www/html/forum/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/forum/applications/calendar/sources/Event/Event.php(2164): iterator_to_array()
    #5 /var/www/html/forum/applications/calendar/modules/front/calendar/view.php(503): IPS\calendar\_Event::retrieveEvents()
    #6 /var/www/html/forum/applications/calendar/modules/front/calendar/view.php(126): IPS\calendar\modules\front\calendar\_view->_viewOverview()
    #7 /var/www/html/forum/system/Dispatcher/Controller.php(118): IPS\calendar\modules\front\calendar\_view->manage()
    #8 /var/www/html/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
    #9 /var/www/html/forum/index.php(13): IPS\_Dispatcher->run()
    #10 {main}

    Can you help me 🙂 ?

  3. hi,

    your module is still working fine on our forum but I have one question : is that possible to add one specific option ?
    Is that possible to show only the first image of the first post ?
    I use your module for a forum dedicated to photography and some users put several images on the first post.
    That cause some troubles on the galery.
    do you you have some ideas for that ?

    thanks

    best regards

    ugo

×
×
  • Create New...