[EventCalendar] database error message
Isaac Hunter Dunlap
IH-Dunlap at wiu.edu
Mon Oct 16 23:41:57 UTC 2006
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
More information about the EventCalendar
mailing list