[Plugin: The Events Calendar] Today's event not displayed

I don’t think I have a fix for this, but I’ve found a workaround for my site (this will only work if you don’t display start/end times in the listings. I don’t on my site: https://bourbontheatre.com/)

Although I tried the suggested edit to the php file mentioned above, it didn’t really work so my php file is back to how it was originally.

Here’s what I have to do: When an item drops off the upcoming events list on the day it’s actually taking place, I just change it from an all day event and set a time for that night, even if it’s a day event. I’ve started doing this for all new events and it seems to work. For instance, if I have an event that starts at 2pm, I’ll just put in a start time of 8pm or so and an end time of 11:55 or something. It works with all-day events as well.

I assume there’s a fix for this in the paid version and am not holding my breath for the developers to throw us a bone. However, if a developer happens to see this, please be aware that assuring us you’ve fixed this and maybe other issues would definitely make us lean towards purchasing your new version. In fact, I’m putting together a site next week that needs a similar plugin but I might try something else due to this problem. Please respond to this thread with either “Yes, this is absolutely, positively fixed in the new version” or maybe “Sorry, no dice.” Should we take your silence as meaning the latter is the case?

I should clarify and say that when I have an event that starts at 2pm and enter in an 8pm start time, the actual start time is in the post content itself and no one ever sees the 8pm mention. Obviously if you’re listing your start times in the widget or something, you’re out of luck.

Let’s keep trying, though!

I think I found the reason, why it worked for some people and for some not.

In the code passage that amynmcgrath listed, replace

CURRENT_DATE() with date('Y-m-d')

This worked for me.

I tried these fixes and it drops today’s date. Looking for a new plugin. It’s too bad because this one has a nice set of lists and user features.

Agree. None of these fixes work.

What’s weird is that when I select all day for an event, the events are not on the list until about noon. Then they appear. I made sure my WordPress site was set the right time in the general settings, but it makes me wonder why it would start working at noon.

Hi people,

I think i found a solution.

At least one that works for me.

On the same file change:

const DBDATETIMEFORMAT = 'Y-m-d';

By doing that you will lose the ability of testing hours…

bye

Hi,

Not sure what “By doing that you will lose the ability of testing hours…” means but that code change seems to have worked.

Well done, tarikouz. Looks like this fix works… at least for now. Thanks a bunch!

Could someone restate the solution from the beginning? I’m not a programmer. It sounds simple, but I’m not sure what I need to change and what I need to change it to. Thanks.

Modify the-events-calendar.class.php

Find:
const DBDATETIMEFORMAT = 'Y-m-d G:i:s';

Change to:
const DBDATETIMEFORMAT = 'Y-m-d';

Thanks!

To answer ckueda:

I think you can only compare the event date with the current date without using hours.

So if we are 21 dec 2010 10 am and that your event ended 21 dec 2010 5 am I think (i should try it) your event will still show on your event list.

Modifying the-events-calendar.class.php
from:
const DBDATETIMEFORMAT = 'Y-m-d G:i:s';
into:
const DBDATETIMEFORMAT = 'Y-m-d H:i:s';
should work too

$query = “
SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
WHERE
$wpdb->postmeta.meta_key = ‘_EventStartDate’
AND $wpdb->postmeta.meta_value = CURRENT_DATE()”;

I have tried so and it’s worck fine
CURRENT_DATE() – INTERVAL 1 DAY