Geeklog Forums

On our site, events that occur on the current day are not showing.

Any idea where that would be controlled? We're using Geeklog 1.4.1 and don't believe any changes have been made to code that would affect that, but since we've got the problem figure it might have happened.

This appears to be a bug, as discussed here earlier.

bye, Dirk

Thank you. I had searched the archives, but somehow didn't find that.

Per your comments regarding where the code was:
function phpblock_calendar() in /public_html/plugins/calendar/functions.inc

And Craig's about changing

$eventSql = 'SELECT eid,title,url,datestart,dateend,group_id,owner_id,perm_owner,perm_group,perm_members,perm_anon '
. "FROM {$_TABLES['events']} "
. "WHERE dateend >= NOW() AND (TO_DAYS(datestart) - TO_DAYS(NOW()) < $range) "
. 'ORDER BY datestart,timestart';

to

$eventSql = 'SELECT eid,title,url,datestart,dateend,group_id,owner_id,perm_owner,perm_group,perm_members,perm_anon '
. "FROM {$_TABLES['events']} "
. "WHERE dateend >= (NOW() - INTERVAL 24 HOUR) AND (TO_DAYS(datestart) - TO_DAYS(NOW()) < $range) "
. 'ORDER BY datestart,timestart';

Even after you pointed that out, my other problem was that when I upgraded the site a while ago, I'd forgotten to download all the changed files to my computer at home and while I've been able to muck with some things, couldn't find the Calendar's functions.inc file. Thankfully the brain kicked in. Figured giving the path as well might help someone else.

Many thanks for your speedy reply!