• I get the following errors (see below) when I try to use RSS from my site: https://dobovedo.com/?feed=rss2

    Oddly enough… the page loads fine if www. is added into the URL. However… I suspect this is causing errors with Google, MyYahoo! and Bloglines, all of which report that the file can’t be found or have a title but no entries.

    The suspected problem area reported by feedvalidator is a leading space before the call for current date/time, but I don’t know how to fix it.

    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 'SELECT ID FROM wp_posts INNER JOIN wp_post2cat ON ( wp_posts.ID]
    SELECT DISTINCT * FROM vedowp_posts WHERE 1=1 AND 0=1 AND post_date_gmt <= '2007-06-27 06:55:59' AND (post_status = "publish") AND post_status != "attachment" AND ID NOT IN ( SELECT ID FROM wp_posts INNER JOIN wp_post2cat ON ( wp_posts.ID = wp_post2cat.post_ID ) WHERE 0 = 1 OR vedowp_post2cat.category_id = 7 OR vedowp_post2cat.category_id = 8) GROUP BY vedowp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
    
    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 'SELECT ID FROM wp_posts INNER JOIN wp_post2cat ON ( wp_posts.ID]
    SELECT DISTINCT * FROM vedowp_posts WHERE 1=1 AND post_date_gmt <= '2007-06-27 06:55:59' AND (post_status = "publish") AND post_status != "attachment" AND ID NOT IN ( SELECT ID FROM wp_posts INNER JOIN wp_post2cat ON ( wp_posts.ID = wp_post2cat.post_ID ) WHERE 0 = 1 OR vedowp_post2cat.category_id = 7 OR vedowp_post2cat.category_id = 8) GROUP BY vedowp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/dobovedo/www/www/wp-includes/wp-db.php:102) in /home/dobovedo/www/www/wp-rss2.php on line 8
    https://www.dobovedo.com a place to document in mind-numbingly boring and excruciatingly painful detail something as basic as riding a bike Wed, 27 Jun 2007 06:38:01 +0000 https://www.ads-software.com/?v=2.0.2 en
  • The topic ‘RSS Feed error in PHP or in database query?’ is closed to new replies.