[EventCalendar] database error message

Brian Williams mixolyde at gmail.com
Mon Oct 16 23:52:12 UTC 2006


I'm getting similar syntax errors on a brand new install at
http://www.techhouse.us/wordpress/

On 10/16/06, Isaac Hunter Dunlap <IH-Dunlap at wiu.edu> wrote:
> Hello,
>
> Am running: WP 2.0.4 and EventCalendar BETA 3.1._rc2 and a fresh download
> of the Widgets plugin. Using default WP theme and configs (no widgets
> besides EC installed). Everything appears to install OK and is activated
> (tables are created).
>
> The calendar appears on the right sidebar via Widgets, but after repeated
> EC installations and even complete WP/EC installations, I continue to
> see database error messages
> appear just above the "October" calendar on the sidebar (see below).
>
> Any suggestions?  Thank you.  --Isaac
>
> http://www.wiu.edu/library/units/infosys/wp_dev2/
>
> 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, allday, 1
> AS is_event FROM wpdev2_posts,wpdev2_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 allday, 0 AS
> is_event FROM wpdev2_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, allday DESC, start_date, is_event DESC
>
>
> _______________________________________________
> 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



More information about the EventCalendar mailing list