[EventCalendar] Today's events

Adams, Keith KAdams1 at csuchico.edu
Tue Oct 17 19:13:11 UTC 2006


Upgrading to 5.0.26 took care of the error.

Keith

-----Original Message-----
From: eventcalendar-bounces at firetree.net
[mailto:eventcalendar-bounces at firetree.net] On Behalf Of Adams, Keith
Sent: Tuesday, October 17, 2006 7:58 AM
To: Support for EventCalendar plugin
Subject: RE: [EventCalendar] Today's events

I have 3.23.58 

Keith

-----Original Message-----
From: eventcalendar-bounces at firetree.net
[mailto:eventcalendar-bounces at firetree.net] On Behalf Of Brian Williams
Sent: Tuesday, October 17, 2006 6:44 AM
To: Support for EventCalendar plugin
Subject: Re: [EventCalendar] Today's events

This appears to be my problem as well. phpinfo() is showing 3.23.49.
Damn!

On 10/17/06, Alex Tingle <alex at firetree.net> wrote:
> You need at least MySQL version 4 to run EventCalendar. Sorry. I'll
> go and put that in the FAQ.
>
> You could try setting "only show events" in the options screen. That
> will avoid this problem, but I'm pretty sure you'll find others.
>
> -Alex
>
> --
>
> On 17 Oct 2006, at 06:07, Isaac H Dunlap wrote:
>
> > Our campus system currently remains at MySQL version 3.23.32.
--Isaac
> >
> >
> > Quoting Alex Tingle <alex at firetree.net>:
> >> Keith, Isaac and Brian,
> >>
> >> That SQL works perfectly for me (MySQL v5.0.22). Can you say which
> >> version of MySQL you are running?
> >>
> >> I think that Darrell's alternative version changes the meaning of
the
> >> select, so that the results will come out in a different order.
That
> >> would mean that some posts wouldn't actually be shown on the
> >> calendar... The order of the results is vital to the logic further
> >> down.
> >>
> >> -Alex
> >>
> >> --
> >>
> >> On 17 Oct 2006, at 02:34, Darrell Schulte wrote:
> >>>
> >>> On Oct 16, 2006, at 5:57 PM, Adams, Keith wrote:
> >>>
> >>>> I'm getting a wordpress database error in the event calendar.
I've
> >>>> tried adding it by putting in ec3_get_calendar() and using the
> >>>> widget
> >>>> and I get the same thing either way.
> >>>>
> >>>>
> >>>> WordPress database error: [You have an error in your SQL syntax
> >>>> near '(
> >>>> SELECT DISTINCT id, post_title, GREATEST(start,'2006-10-0' at
> >>>> line 1]
> >>>> ( SELECT DISTINCT id, post_title, GREATEST(start,'2006-10-01
> >>>> 00:00:00')
> >>>> AS start_date, LEAST(end,'2006-11-01 00:00:00') AS end_date, 1 AS
> >>>> is_event FROM wp_posts,wp_ec3_schedule WHERE
post_status='publish'
> >>>> AND
> >>>> post_id=id AND end>='2006-10-01 00:00:00' AND start<'2006-11-01
> >>>> 00:00:00' ) UNION ( SELECT DISTINCT id, post_title, post_date AS
> >>>> start_date, post_date AS end_date, 0 AS is_event FROM wp_posts
> >>>> WHERE
> >>>> post_status='publish' AND post_date>='2006-10-01 00:00:00' AND
> >>>> post_date<'2006-11-01 00:00:00' AND post_date<NOW() ) ORDER BY
id,
> >>>> start_date, is_event DESC
> >>>
> >>> Keith, Isaac and Brian,
> >>>
> >>> I'm unable to reproduce the error you are experiencing on my local
> >>> development blog, however, taking the query and putting it into
> >>> phpMyAdmin does produce an error.
> >>>
> >>> If I take the UNION parts separately, I receive valid responses
> >>> from MySQL. So, I suppose it could be getting fouled up on those
> >>> parentheses. Try this -- go into template-functions.php and
replace
> >>> lines 130-143 with the following.
> >>>
> >>>     $sql=" $sql  UNION
> >>>       SELECT DISTINCT
> >>>          id,
> >>>          post_title,
> >>>          post_date AS start_date,
> >>>          post_date AS end_date,
> >>>          0 AS allday,
> >>>          0 AS is_event
> >>>        FROM $wpdb->posts
> >>>        WHERE post_status='publish'
> >>>          AND post_date>='$begin_date'
> >>>          AND post_date<'$end_date'
> >>>          AND post_date<NOW()
> >>>      ";
> >>>
> >>>
> >>> Give that a try. I could be completely wrong and possibly changing
> >>> the scope of the query, but it might be worth a try...
> >>>
> >>> Darrell Schulte
> >>> http://schulte.mn
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> Blog: http://wpcal.firetree.net/
> >>> EventCalendar at firetree.net mailing list
> >>> Unsubscribe: http://penguin.firetree.net/eventcalendar
> >>
> >>
> >> _______________________________________________
> >> Blog: http://wpcal.firetree.net/
> >> EventCalendar at firetree.net mailing list
> >> Unsubscribe: http://penguin.firetree.net/eventcalendar
> >>
> >
> >
> > ----------------------------------------
> > Isaac Hunter Dunlap, Associate Professor
> > Information Systems Coordinator
> > Western Illinois University Libraries
> > Macomb, IL 61455 * 309-298-2745
> > ih-dunlap at wiu.edu * www.wiu.edu/library
> >
> > _______________________________________________
> > Blog: http://wpcal.firetree.net/
> > EventCalendar at firetree.net mailing list
> > Unsubscribe: http://penguin.firetree.net/eventcalendar
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
>


-- 
Brian E. Williams
mixolyde at gmail.com
http://www.techhouse.us/Hosted/Brianw

"Never attribute to malice that which can be adequately
explained by stupidity." - Hanlon's Razor

_______________________________________________
Blog: http://wpcal.firetree.net/
EventCalendar at firetree.net mailing list
Unsubscribe: http://penguin.firetree.net/eventcalendar

_______________________________________________
Blog: http://wpcal.firetree.net/
EventCalendar at firetree.net mailing list
Unsubscribe: http://penguin.firetree.net/eventcalendar



More information about the EventCalendar mailing list