[EventCalendar] Today's events

[Adams, Keith]

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


http://theatredate.com/

Any ideas?

Thanks,

Keith


-----Original Message-----
From: Adams, Keith 
Sent: Monday, October 16, 2006 3:19 PM
To: 'Support for EventCalendar plugin'
Subject: RE: [EventCalendar] Today's events

I think I found it; the example has an extra comma (between j and
MONTH).

Keith

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

I am getting a parse error when I try to use one of the example event
functions:


  <li><?php
    _e('Events');
    ec3_get_events(3,'%DATE%: <a
href="%LINK%">%TITLE%</a>','','j',,"%MONTH%:");
  ?> </li> 


Copied/pasted from lines 153-156 of readme.txt

Any ideas?

Thanks,

Keith

-----Original Message-----
From: eventcalendar-bounces at firetree.net
[mailto:eventcalendar-bounces at firetree.net] On Behalf Of Adams, Keith
Sent: Friday, October 13, 2006 4:14 PM
To: Support for EventCalendar plugin
Subject: RE: [EventCalendar] Today's events

Thanks Alex!  I am using pre16; I just hadn't set my timezone yet.

Keith

-----Original Message-----
From: eventcalendar-bounces at firetree.net
[mailto:eventcalendar-bounces at firetree.net] On Behalf Of Alex Tingle
Sent: Friday, October 13, 2006 3:39 PM
To: Support for EventCalendar plugin
Subject: Re: [EventCalendar] Today's events

On Fri, 13 Oct 2006 15:17:34 -0700
"Adams, Keith" <KAdams1 at csuchico.edu> wrote:

> EventCalendar seems to show events starting with events taking place
> tomorrow.  How do I make it show events starting with today instead?

Keith, you don't say which version of the plugin you are using.

If you would like to try the latest **BETA** version (3.1._pre16), it
has proper support for timezones. If you set your timezone correctly,
then it should work properly for you.

Download it here:
  http://sf.net/project/showfiles.php?group_id=176316

-Alex

-- 
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763 

_______________________________________________
EventCalendar at firetree.net mailing list
Unsubscribe: http://penguin.firetree.net/eventcalendar
Download: http://sf.net/projects/wpcal

_______________________________________________
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