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

[Vfrloos]

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?

[Jim M]

Unfortunately, the query is present but not the error which the query is resulting in. Could you please provide the whole error message?

[Vfrloos]

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}

[Jim M]

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. 

 

[Vfrloos]

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

 

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

Edited October 15, 2022 by Vfrloos

[Jim M]

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?

[Vfrloos]

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.  

[Jim M]

Yes, you'll want to ensure your language pack is up to date and compatible with the release.

[Vfrloos]

Thanks for the support, I can now start to fix this 

[Richard Arch]

Quote

IPS\Db\Exception: Incorrect parameter count in the call to native function 'radians' (1582)

https://www.w3resource.com/mysql/mathematical-functions/mysql-radians-function.php

The radians function accepts one parameter.  Should those commas be a decimal?

 

[Richard Arch]

Is the language settings swapping decimals to commas?

[Vfrloos]

Could be, Dutch and US have different use of commas and points. 

[Richard Arch]

This sounds like a bug.

[BURCIN ARIKAN]

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.

Edited October 16, 2022 by BURCIN ARIKAN
*typo

[Jim M]

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.

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.

[Marc Stridgen]

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.

[Vfrloos]

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 😀

[Jim M]

Glad to hear it fixed it 🙂 .

[BURCIN ARIKAN]

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

 

Edited October 19, 2022 by BURCIN ARIKAN

[Marc Stridgen]

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

 

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