[wp-trac] [WordPress Trac] #4069: query_posts('category_name=test') = database error

WordPress Trac wp-trac at lists.automattic.com
Mon Apr 2 17:17:40 GMT 2007


#4069: query_posts('category_name=test') = database error
-----------------------+----------------------------------------------------
 Reporter:  devil1591  |       Owner:  anonymous
     Type:  defect     |      Status:  new      
 Priority:  high       |   Milestone:  2.2      
Component:  General    |     Version:  2.2      
 Severity:  blocker    |    Keywords:           
-----------------------+----------------------------------------------------
 If you make a
 {{{
 <?php query_posts('category_name=test'); ?>
 }}}
 before your loop, you will have this error
 {{{
 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 ') AND rel_type = 'category' AND (post_type = 'post' AND
 (post_st]
 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_post2cat
 ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON
 (wp_post2cat.category_id = wp_categories.cat_ID) WHERE 1=1 AND category_id
 IN () AND rel_type = 'category' AND (post_type = 'post' AND (post_status =
 'publish' OR post_status = 'private')) GROUP BY wp_posts.ID ORDER BY
 post_date DESC LIMIT 0, 10
 }}}

 Tested on a fresh trunk install

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4069>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list