Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Vfrloos Posted October 15, 2022 Posted October 15, 2022 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? BURCIN ARIKAN 1
Jim M Posted October 15, 2022 Posted October 15, 2022 Unfortunately, the query is present but not the error which the query is resulting in. Could you please provide the whole error message?
Vfrloos Posted October 15, 2022 Author Posted October 15, 2022 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 Posted October 15, 2022 Posted October 15, 2022 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 Posted October 15, 2022 Author Posted October 15, 2022 (edited) 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 Posted October 15, 2022 Posted October 15, 2022 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 Posted October 15, 2022 Author Posted October 15, 2022 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 Posted October 15, 2022 Posted October 15, 2022 Yes, you'll want to ensure your language pack is up to date and compatible with the release. Vfrloos 1
Vfrloos Posted October 15, 2022 Author Posted October 15, 2022 Thanks for the support, I can now start to fix this
Richard Arch Posted October 15, 2022 Posted October 15, 2022 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? BURCIN ARIKAN 1
Richard Arch Posted October 15, 2022 Posted October 15, 2022 Is the language settings swapping decimals to commas?
Vfrloos Posted October 15, 2022 Author Posted October 15, 2022 Could be, Dutch and US have different use of commas and points.
Richard Arch Posted October 15, 2022 Posted October 15, 2022 This sounds like a bug. teraßyte and BURCIN ARIKAN 2
BURCIN ARIKAN Posted October 16, 2022 Posted October 16, 2022 (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. Edited October 16, 2022 by BURCIN ARIKAN *typo
Jim M Posted October 16, 2022 Posted October 16, 2022 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.
Solution Marc Posted October 17, 2022 Solution Posted October 17, 2022 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 1
Vfrloos Posted October 18, 2022 Author Posted October 18, 2022 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 1
BURCIN ARIKAN Posted October 19, 2022 Posted October 19, 2022 (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 Edited October 19, 2022 by BURCIN ARIKAN
Marc Posted October 19, 2022 Posted October 19, 2022 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
Recommended Posts