Collin Lafrance
Hello Peter,
I seem to have an issue with Articles Anywhere that is really perplexing.
Our events pages, I only noticed this recently (so may have been a long time issue), is not respecting the actual time.
For example, we are in Toronto (EDT timezone). I have pages setup that show the events for Today, Tomorrow, 2 Days, 3 Days.... 7 Days.
The pages for Today and Tomorrow work fine. The other pages too, however for 2 Days... 7 Days, as soon as it becomes 8pm EDT, it will show the following date's events, rather than wait until 12am. This doesn't happen with Today or Tomorrow.
I have checked and we use the Calendar field in Joomla, so when we enter a date and time, in MySQL it seems to shift it ahead by 4 hours when saved, yet it shows fine in Joomla. Needless to say, none of them end up being within 4 hours of 8pm, and all the events for the following day show up at the same time as of 8pm EDT. So I don't necessarily think it saving +4 hours in MySQL is the issue since they all have different times, and they all show up a day ahead in the Articles Anywhere pages at the same time (8pm onward) anyways.
I have checked and confirmed my server settings. It is physically located in Toronto. The server timezone is set to Toronto (EDT), the mySQL timezone is set to Toronto (EDT). Joomla Global Config is set to Toronto, and even my user accounts are either Default or Toronto.
Really not sure what to do next. It's a bit of an issue though since the affected pages say for example : Events for November 4, 2022, yet for people visiting between 8pm-12am, it will show events underneath for November 5th.
Again what is odd is this will happen with the Today+2 Days .... Today+7 Days, but doesn't do this phenomenon with Today or Tomorrow.
Thank you for your help Peter.
Confidential information:
(hidden)