Jump to content

Calendar broke after update. (4.3.6 - 4.7.3) php Version 7.4.32


Go to solution Solved by Marc,

Recommended Posts

Posted

Correct, long overdue but updated at last.    (Was also waiting for skin updates Sherri, never came)

So before update: removed skins / removed plugin's and other customize settings. Look ok, default forum no problem.

Performed upgrade, looks ok. 

However calendar seems nog to work:

SELECT calendar_events.*, ( 3959 * acos( cos( radians(52,5) ) * cos( radians( event_latitude ) ) * cos( radians( event_longitude ) - radians( 5,75 ) ) + sin( radians( 52,5 ) ) * sin( radians( event_latitude) ) ) ) AS distance, author.*, core_tags_cache.tag_cache_text FROM `ibf_calendar_events` AS `calendar_events`  LEFT JOIN `ibf_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT('calendar;calendar;',calendar_events.event_id))  LEFT JOIN `ibf_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 ( etc etc

 

Any idea? I will upgrade php but have to do some upgrades also to other software running on this host. 

For now disabled calendar and forum is running without problems.  Loaded new skins from ipsfocus also no problems. 

Any ideas, or just wait until php 8 upgrade?

Could contain: Text, Document, Page

Posted

Here it is:

SELECT calendar_events.*, ( 3959 * acos( cos( radians(52,5) ) * cos( radians( event_latitude ) ) * cos( radians( event_longitude ) - radians( 5,75 ) ) + sin( radians( 52,5 ) ) * sin( radians( event_latitude) ) ) ) AS distance, author.*, core_tags_cache.tag_cache_text FROM `ibf_calendar_events` AS `calendar_events`  LEFT JOIN `ibf_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT('calendar;calendar;',calendar_events.event_id))  LEFT JOIN `ibf_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-15' AND DATE( event_start_date ) <= '2023-10-15' AND event_all_day=1 )
                    OR
                    ( event_end_date IS NOT NULL AND DATE( event_start_date ) <= '2023-10-15' AND DATE( event_end_date ) >= '2022-10-15' AND event_all_day=1 )
                    OR
                    ( event_end_date IS NULL AND event_start_date >= '2022-10-15 00:00:00' AND event_start_date <= '2023-10-14 22:00:00' AND event_all_day=0 )
                    OR
                    ( event_end_date IS NOT NULL AND event_start_date <= '2023-10-14 22:00:00' AND event_end_date >= '2022-10-15 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) HAVING distance < 500 ORDER BY distance ASC
IPS\Db\Exception: Incorrect parameter count in the call to native function 'radians' (1582)
#0 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*deb115391_V4-...', Array, true)
#1 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 [internal function]: IteratorIterator->rewind()
#4 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/applications/calendar/sources/Event/Event.php(2164): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#5 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/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 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/applications/calendar/modules/front/calendar/view.php(126): IPS\calendar\modules\front\calendar\_view->_viewOverview(Object(IPS\Helpers\Form))
#7 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/system/Dispatcher/Controller.php(118): IPS\calendar\modules\front\calendar\_view->manage()
#8 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#9 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/index.php(13): IPS\_Dispatcher->run()
#10 {main}

 

Backtrace:

#0 /home/deb115391/domains/vfroc.nl/public_html/forumVFR/init.php(1029): IPS\_Log::log('SELECT calendar...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

Posted

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

Posted (edited)

Done, was also very old, created also admin account.  

 

(hope mail adres is correct, but it wil work with login)

Edited by Vfrloos
Posted

I enabled the Events application (aka calendar) and its module, all seems to be working fine when accessing Events index, calendars, and events. Could you please clarify where you're seeing this?

Posted

Still a problem, but that gives me a hint.

Switched lang to US and no problem, switch back to Dutch, booomm.

So problem is in the lang setting probably then.  

Posted (edited)

Yes, correct. This is a bug !

We just updated the system to v4.7.3
We are getting an error when we use the new events app.
When we try to use it in English it works, however it doesn't work in other languages. 
I said about blank (new, unmodified) language packs provided by Invision Community !
 
Invision Community automatically assigns English values to empty language packs in language settings. The problem here is not the language pack itself, it's because the localization of language packs other than English is not compatible with the latest update. As @Richard Arch said, it's not configured correctly (date localization error - decimal etc.)

But @Jim M - for some reason - just doesn't accept it and is not focused on problem solving. This problem needs to be directed to the developer team.

We reported this issue via email and @Jim M ignores it even though @Vfrloos also shared the technical details in the first post of this thread.

As a result,

With the last update, Eventes application crashes in languages other than English(US) and languages that use the same DATE localization setting as English(US)!

We request that this problem be taken seriously and forwarded to the developer team.

Could contain: Document, Text, Page, File

Could contain: File, Text, Webpage, Page, Document

Edited by BURCIN ARIKAN
*typo
Posted
2 hours ago, BURCIN ARIKAN said:

Yes, correct. This is a bug !

We just updated the system to v4.7.3
We are getting an error when we use the new events app.
When we try to use it in English it works, however it doesn't work in other languages. 
I said about blank (new, unmodified) language packs provided by Invision Community !
 
Invision Community automatically assigns English values to empty language packs in language settings. The problem here is not the language pack itself, it's because the localization of language packs other than English is not compatible with the latest update. As @Richard Arch said, it's not configured correctly (date localization error - decimal etc.)

But @Jim M - for some reason - just doesn't accept it and is not focused on problem solving. This problem needs to be directed to the developer team.

We reported this issue via email and @Jim M ignores it even though @Vfrloos also shared the technical details in the first post of this thread.

As a result,

With the last update, Eventes application crashes in languages other than English(US) and languages that use the same DATE localization setting as English(US)!

We request that this problem be taken seriously and forwarded to the developer team.

Could contain: Document, Text, Page, File

Could contain: File, Text, Webpage, Page, Document

Apologize, looking at your ticket history, it looks like one of my colleagues was working with you. This is one of the benefits of the community rather than tickets is that there is a little more opportunity for conversation like this to clarify something that may have been overlooked prior and outline multiple instances of it happening so thank you for bringing this up. I have re-opened your ticket on this and escalated for further investigation.

I have also transferred the OP's conversation to a ticket for further investigation so we have 2 instances of this happening we can investigate.

Posted
On 10/17/2022 at 3:05 PM, Marc Stridgen said:

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 fixed the problem, quick fix, happy 😀

Posted (edited)
15 hours ago, Vfrloos said:

Patch fixed the problem, quick fix, happy 😀

Unfortunately problem doesn't solve completely. Even we installed 2nd patch.

We couldn't translate short month name eg. OCT, NOV

 

Could contain: Text, Page, Number, Symbol

Edited by BURCIN ARIKAN
Posted
34 minutes ago, BURCIN ARIKAN said:

Unfortunately problem doesn't solve completely. Even we installed 2nd patch.

We couldn't translate short month name eg. OCT, NOV

 

Could contain: Text, Page, Number, Symbol

I have answered this on your other ticket. This isnt related to the issue on the topic here

  • Recently Browsing   0 members

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