[wp-testers] WP3.1 beta 2 - WordPress database error when viewing custom post type single post

scribu mail at scribu.net
Wed Dec 22 13:39:31 UTC 2010


On Wed, Dec 22, 2010 at 3:32 PM, Ade Walker <photofantaisie at gmail.com>wrote:

> Anyone else seen this?
>
> Since upgrading to WP 3.1 beta 2, custom post type single post views are
> generating this error message:
>
>
> 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 p.post_date < '2010-12-14 00:02:05' AND p.post_type =
> 'ade_cpt_products'' at line 1]
> SELECT p.* FROM ade_gtr_posts AS p INNER JOIN ade_gtr_term_relationships AS
> tr ON p.ID = tr.object_id INNER JOIN ade_gtr_term_taxonomy tt ON
> tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'category' AND
> tt.term_id IN () WHERE p.post_date < '2010-12-14 00:02:05' AND p.post_type
> =
> 'ade_cpt_products' AND p.post_status = 'publish' AND tt.taxonomy =
> 'category' ORDER BY p.post_date DESC LIMIT 1
>

That taxonomy SQL looks like it comes from a plugin. Core does it
differently now.


More information about the wp-testers mailing list