[wp-hackers] change in database name variable?
r at robm.me.uk
Sat Jan 13 15:49:06 GMT 2007
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
> 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
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
"Recently" as in "ages ago", yeah. All table_* variables were removed;
use $wpdb->prefix, $wpdb->posts, etc. instead.
More information about the wp-hackers