Hi Creic,

some timezone issues has been fixed at our newest version. But still not sure related with your issues or not.
Maybe you can try by using dev site, with newest jomsicial version.

Regards,
Albert

Hi Creic,

your issue has been passed to our developer again, and still on investigate. but for the fixes always for the newest version. if you can't upgrade it, if the fixes had a lot changes it's hard for me patch it. if the changes is small, no big deal to patch your site.

as reference:
www.jomsocial.com/forum/bugfixes-and-upg...social-3-2-0-4#82474

Regards,
Albert

Albertus

Jomsocial has been upgraded ( as you required)
Issue is not solved.

Hi Creic,

We are looking into the problem of events and the timezone and i have been able to replicate some of the things you reported. I need some clarification on a few things though

when i create an event, then click on the all events menu link it shows every event that the time has not passed for yet. Do you get the same result?
When the event is within 24 hours hours of the time of the event the words "ongoing"

My question is does the event not show in the all events menu list or is the ongoing label not following the timezone and displaying correctly.

Paul
when i create an event, then click on the all events menu link it shows every event that the time has not passed for yet. Do you get the same result?
My answer YES exactly as you described
When the event is within 24 hours hours of the time of the event the words "ongoing"
My question is does the event not show in the all events menu list or is the ongoing label not following the timezone and displaying correctly.

My Answer;
No for "does the event not show in the all events menu list"
Event is showing in all events menu

Yes to is the ongoing label not following the timezone and displaying correctly.

Exactly as you described is showing "ongoing' and then expires based on the UTC time not on the time defined in the event MTD

I hope this helps

Hi Creic,

I have looked again there are a few different things

1. The "ongoing" word that appears doesn't follow the time of the event but the day of the event. After speaking with the designers this looks like it is a design issue. my tests on my own test site shows it is not consistently appearing in relation to the event so i will be raising a ticket for this issue
2. I have looked at all the events on your site and the total shown in the categories matches the events in the All events list. What i have noticed though is you have some private groups. Events in private groups do NOT show in the all events list as they follow the "private group" privacy. Where there is an issue though is with the counting of events in the categories list.

Here is an example. You have 20 events created and all show in the all events list. the count in the categories also says 20. You then go to a private group and create a new event. This event will NOT show in the All events page but is included in the category counting, The category counting is something that is going to be addressed by our design team as this is not logical to me. If you click on a category that says 21 events you will only see 20 because 1 is private.

So from this example i am wondering if the missing events are events created in private groups. If this isn't the case can you let me know if its OK for me to create some test events on your live site or can you create them and give some specific examples (URLS) of what is not appearing. At the moment the total events is matching what is in the list of all events

This is the issue
Every time when members are coming to see, particular event (webinar) this event is gone and showing in expired events. Members want to get info about location or webinar link and this is mostly happening just before even starts. How they can any info when timezone is not respected and event is long time expired.

So please focus on that this is major concern.

You found additional "on going" issue too. And that would be good to fix.

About your point 2)

I have no idea why you are pointing this out. That wasn't our ticket.

Our issue is that events they do not respect time zone and expire based on UTC time instead of Mountain time which is set for all events.
This is major issue because in 2weeks we will have events in 3 other Canadian time zones and the will disappear 6 or 7 or 8 and 9 hours before real event.

Hi Creic,

about all events menu please try this:
edit the code at: /components/com_community/models/events.php line 246:

from
$extraSQL .= ' AND a.' . $db->quoteName('enddate') . ' >= ' . $db->Quote($now->toSql());

to
$extraSQL .= ' AND a.' . $db->quoteName('enddate') . ' > ' . $db->Quote($now->toSql());

Albertus wrote: Hi Creic,

about all events menu please try this:
edit the code at: /components/com_community/models/events.php line 246:

from
$extraSQL .= ' AND a.' . $db->quoteName('enddate') . ' >= ' . $db->Quote($now->toSql());

to
$extraSQL .= ' AND a.' . $db->quoteName('enddate') . ' > ' . $db->Quote($now->toSql());

seem there is a bug with joomla JDate API. we still investigating this hard issue.

Regards,
Albert

Hi Creic,

really sorry for this inconvenience, the problem with JDate of Joomla! somehow for now returned without offset even jomsocial code added it. Our developer still struggle for this.

Regards,
Albert

Albertus wrote: Hi Creic,

really sorry for this inconvenience, the problem with JDate of Joomla! somehow for now returned without offset even jomsocial code added it. Our developer still struggle for this.

Regards,
Albert

Hi Creic,

Our dev did the changes. But before official release, we want make sure the solution will resolve your issue.
please edit components/com_community/models/events.php line 357:

from
$extraSQL .= ' AND a.' . $db->quoteName('enddate') . ' > ' . $db->Quote($pastDate->format('Y-m-d H:i:s', true, false));

to
$extraSQL .= ' AND a.' . $db->quoteName('enddate') . ' >= ' . $db->Quote($pastDate->format('Y-m-d H:i:s', true, false));

Disappointment

I waited to change file to see changes for the event already showing on going

www.canadareic.com/investors/events

Now is June 5 11 PM
event is on 6 June at 7 PM and is already showing Ongoing

Cache cleared , cloudflare cleared . No changes

Is there a way to make this issue solved ?
I will give you root access to entire server. I will help you with everything is needed to make sure that issue is solved ?????

This is 2 Months since we submitted support request, we are not on shared hosting so you can have access to all resources. Please do it right .

I;m already looking at other event alternatives and that is not good sign.