[wp-hackers] change in database name variable?

[Rob]

On 13/01/07, YAR Russ Gilman-Hunt <gilmanhunt at comcast.net> wrote:
> 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
> this:
>
> 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
> http://www.arghwebworks.com/
> gilmanhunt at comcast.net
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>

"Recently" as in "ages ago", yeah. All table_* variables were removed;
use $wpdb->prefix, $wpdb->posts, etc. instead.

-- 
Rob Miller
http://robm.me.uk/