Simple Machines Community Forum

SMF Development => Bug Reports => Topic started by: Chuck Baker on July 17, 2023, 06:43:22 PM

Title: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 17, 2023, 06:43:22 PM
Hi,

I searched for this issue, but the only thing I found was very old.
I'm running SMF version 2.1.4.

Some of the calendar event entries I've added are not showing up on the calendar.

I added an event for Saturday, August 5th.
I expected to see it on the August month calendar, but it's not there.
I tried displaying as LIST, MONTH and WEEK, but the event will not display.
I even tried adding another link to the calendar, but it's still not showing up.

And there is another multi-day event that only some of the days are displayed.
The event runs from Aug 3 to Aug 5, but the calendar only shows it on Aug 4 & 5.

Any help would be appreciated.

Thanks...
Chuck
Title: Re: Calendar entries not showing up on calendar
Post by: Kindred on July 17, 2023, 06:53:41 PM
Url?

Timezone setting on your server?
Timezone setting in your forum?
Timezone setting in your profile?
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 21, 2023, 05:20:41 PM
Our calendar is located here:
https://www.indyrcsouth.org/forum/index.php?action=calendar;viewmonth;year=2023;month=8;day=01

There are several events in the first weekend of August that aren't showing up:
https://www.indyrcsouth.org/forum/index.php/topic,3277.0.html
https://www.indyrcsouth.org/forum/index.php/topic,3274.0.html
https://www.indyrcsouth.org/forum/index.php/topic,3279.0.html

And one of the events is showing on the calendar, but only 2 of the 3 days - Aug 4 & 5 vs Aug 3-5.
https://www.indyrcsouth.org/forum/index.php/topic,3270.0.html

Chuck
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 21, 2023, 06:47:29 PM
Answers to your other questions, I think...   :)

Timezone setting on your server?
Our ISP is on Pacific Daylight Savings

Timezone setting in your forum?
Server setting -> PHP Info -> Default timezone = America/New York

Timezone setting in your profile?
Local time in my Profile Info is Eastern Daylight Savings

Chuck
Title: Re: Calendar entries not showing up on calendar
Post by: Aleksi "Lex" Kilpinen on July 22, 2023, 04:26:47 AM
That's odd. The individual topics seem fine, the calendar seems to show many many events, but not all of them quite apparently.

Do you know if your host has some caching running? What are the forum caching settings?
Does emptying the file cache do anything at all?
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 22, 2023, 11:35:29 AM
I do not know the answers to the caching questions...

I did add some more "test events" to the calendar, one each for Aug 1 thru Aug 12, and one on Aug 19.
All of them show up except for the ones on Aug 3 and Aug 5.

Aug 3 won't display the first day of a 3-day event or the test event, but does display another event.
Aug 5 won't display any of the newer events I've added, but does display a couple of other events.

Any idea what might be causing this?

Chuck
Title: Re: Calendar entries not showing up on calendar
Post by: Aleksi "Lex" Kilpinen on July 22, 2023, 11:57:16 AM
Can you check these, just to make sure, even though I'm doubtful we learn anything useful.

Admin -> Maintenance -> Server Settings -> Caching, what is the "Caching Level" set at, and what is selected as the "Caching Accelerator"? Don't change anything, just note the settings.

Then go to Admin -> Maintenance -> Forum Maintenance -> Routine, at the last option "Empty SMF's cache" select run now, and check the calendar again to see if anything changed. Probably will not help, but worth a try.

Lastly go to Admin -> Maintenance -> Logs -> Error log, and if you see any errors that could be related to the cache, the events, or the calendar, let us know.
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 22, 2023, 01:17:38 PM
Sure...

Admin -> Maintenance -> Server Settings -> Caching, what is the "Caching Level" set at, and what is selected as the "Caching Accelerator"? Don't change anything, just note the settings.
-> Caching Level is "No caching"
-> Caching Accelerator is "SMF file based caching"

Then go to Admin -> Maintenance -> Forum Maintenance -> Routine, at the last option "Empty SMF's cache" select run now, and check the calendar again to see if anything changed. Probably will not help, but worth a try.
-> No change

Lastly go to Admin -> Maintenance -> Logs -> Error log, and if you see any errors that could be related to the cache, the events, or the calendar, let us know.
-> There are currently no error log entries

So, what's the next step?
Title: Re: Calendar entries not showing up on calendar
Post by: Aleksi "Lex" Kilpinen on July 22, 2023, 01:26:16 PM
Was afraid so, it's at least not an issue with SMF caching. @shawnb61 @Sesquipedalian Good ideas welcome.
Seems like a random mystery to me.
Title: Re: Calendar entries not showing up on calendar
Post by: Illori on July 22, 2023, 01:49:19 PM
admin -> forum -> calendar -> calendar settings, what value do you have for max days in advance on board index?
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 22, 2023, 03:28:19 PM
Max days in advance on board index is set to "7".

But wouldn't this only affect the "LIST" view, not the "MONTH" or "WEEK" view?

I changed it to 14, but am still unable to see the missing events on Aug 3 and Aug 5.

Changed it back to 7.
Title: Re: Calendar entries not showing up on calendar
Post by: shawnb61 on July 22, 2023, 04:05:04 PM
Could you share the results of this query:
SELECT * FROM `smf_calendar` WHERE id_event IN (2745,2752,2749,2756);
Title: Re: Calendar entries not showing up on calendar
Post by: shawnb61 on July 22, 2023, 04:42:43 PM
Confirmed & logged here: https://github.com/SimpleMachines/SMF/issues/7803

I don't know WHY it's happening yet, but the date range logic definitely drops some under some circumstances.
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 22, 2023, 04:53:58 PM
Quote from: shawnb61 on July 22, 2023, 04:05:04 PMCould you share the results of this query:
SELECT * FROM `smf_calendar` WHERE id_event IN (2745,2752,2749,2756);

Where would I go to run this query?
Or do you still need me to?
Chuck
Title: Re: Calendar entries not showing up on calendar
Post by: shawnb61 on July 22, 2023, 04:58:10 PM
It may still be helpful to see the info, thanks.  You can run it in phpmyadmin, in the SQL tab.

If you can't, no big deal, as I was able to reproduce this issue locally.

Thanks,
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 22, 2023, 05:14:54 PM
Query results located here:
https://drive.google.com/file/d/1AXHkY8jVLO6angs2LEGP2mjAj1wKcFvj/view?usp=sharing
(https://drive.google.com/file/d/1AXHkY8jVLO6angs2LEGP2mjAj1wKcFvj/view?usp=sharing)
Title: Re: Calendar entries not showing up on calendar
Post by: shawnb61 on July 22, 2023, 05:17:40 PM
Thanks!

BTW, very cool & active site.  Looks like fun!
Title: Re: Calendar entries not showing up on calendar
Post by: Chuck Baker on July 22, 2023, 06:01:03 PM
Thanks, and thank you for looking into this issue.
Hopefully it will be an easy thing to fix. :)
Chuck