[wp-hackers] change in database name variable?

Russ Gilman-Hunt (YAR) gilmanhunt at comcast.net
Sat Jan 13 15:37:47 GMT 2007

Good morning.
I've upgraded a few installations of WP 2.0.5 to the new svn version,
and it results in two plugins throwing mysql errors; both Event
Calendar 3 and Auto Close Comments. Basically, they're now reporting

WordPress database error: [You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near ' WHERE post_date >= '2007_1_1' AND post_date <
'2007_2_1' ' at line 8] SELECT DISTINCT post_title, post_date,
DAYOFMONTH(post_date) AS day, MONTH(post_date) AS month,
YEAR(post_date) AS year, (category_id = 1) AS is_event FROM , WHERE
post_date >= '2007_1_1' AND post_date < '2007_2_1' AND post_status =
'publish' AND id = post_id AND (post_date_gmt<='2007-01-13 15:33:59' OR
category_id=1) ORDER BY post_date ASC

That is to say, for some reason both of these plugins have lost the
table name. (select * from where). Has there been a change recently in
what variables are available for the plugins?
Russ Gilman-Hunt
gilmanhunt at comcast.net

More information about the wp-hackers mailing list