• Resolved cube

    (@cube)


    I have some Problems with my Feeds. My Main Feed under 72quadrat.de/blog/wp-rss.php works fine, but any kind of custom Feed like Entry-Comment- or Category-Feed doesn’t work!

    For example a category-Feed like 72quadrat.de/blog/category/magazin/feed/ gives a MySQL Error like
    WordPress database error: [Not unique table/alias: 'wp2_post2cat']
    SELECT DISTINCT * FROM wp2_posts LEFT JOIN wp2_post2cat ON (wp2_posts.ID = wp2_post2cat.post_id) LEFT JOIN wp2_categories ON (wp2_post2cat.category_id = wp2_categories.cat_ID) LEFT JOIN wp2_post2cat ON (wp2_posts.ID = wp2_post2cat.post_id) WHERE 1=1 AND (category_id = '17' OR category_id = 3 OR category_id = 5 OR category_id = 25 OR category_id = 28 OR category_id = 29) AND post_date_gmt <= '2006-06-23 13:49:59' AND...

    Same Problem on Entry-Feeds like this

    If i don’t youse the Permalink-Structure i get a XML Error for example on this Category Feed.

    Has Anyone an Idea what went wrong?!?!

Viewing 6 replies - 1 through 6 (of 6 total)
  • What plugins are you running? If you selectively disable them, does it start working?

    What’s controlling the “mini blog” in the sidebar?

    Thread Starter cube

    (@cube)

    O.K., the Category-Feed Problem is fixed thank you it was my Sideblog-Plugin :-). Now I’ve updated to Version 3.3 of “Sideblog WordPress Plugin” and my Category-Feeds work!

    But my Comment Feed does not! 🙁

    Thread Starter cube

    (@cube)

    I’ve triggered out that for my Comment-Feeds there seems to be a Permalink-Structure Error.

    For example, my newest Entry with the ID 334 got a nice Comment-RSS Feed if i use the Url 72quadrat.de/blog/wp-commentsrss2.php?p=334 but not if i use the permalink like here.

    My Permalink Stuff looks like that:
    # BEGIN FAlbum
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteRule ^flickr/?([^/]*)?/?([^/]*)?/?([^/]*)?/?([^/]*)?/?([^/]*)?/?([^/]*)?/?([^/]*)?/?([^/]*)?/?$ /blog/wp-content/plugins/falbum/wp/album.php?$1=$2&$3=$4&$5=$6&$7=$8 [QSA,L]
    </IfModule>
    # END FAlbum
    RewriteEngine On

    Options +SymLinksIfOwnerMatch

    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /blog/
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /blog/index.php [L]
    </IfModule>

    # END WordPress
    ErrorDocument 404 ../error404.html

    Does anybody see any Failure in that?!? I’m a newbie in Rewrite Urls…

    Thread Starter cube

    (@cube)

    O.K. I’ve checked a little bit the MYSQL Query:
    SELECT * FROM wp2_posts
    LEFT JOIN wp2_post2cat ON (wp2_posts.ID = wp2_post2cat.post_id)
    <strong>LEFT JOIN wp2_categories ON (wp2_post2cat.category_id = wp2_categories.cat_ID)
    LEFT JOIN wp2_post2cat ON (wp2_posts.ID = wp2_post2cat.post_id)</strong>
    WHERE 1=1
    AND YEAR(post_date)='2006'
    AND MONTH(post_date)='6'
    AND DAYOFMONTH(post_date)='19'
    AND post_name = 'fast-fehlerfrei-und-teils-neu'
    AND (category_id = '2')
    AND (post_status != "static")
    AND post_status != "attachment"
    GROUP BY wp2_posts.ID
    ORDER BY post_date DESC

    And it seems that there are too much Left joins?!?!?

    If i delete the bold Lines it’s O.K.

    Thread Starter cube

    (@cube)

    O.K. It’s the f**** Sideblog-Plugin!! There is a second LEFT JOIN in that Plugin… Not so nice, seems I have to find another way to implement my sideblog…

    Ah ha! And Bummer.

    I was dabbling with that plugin again this morning and gave up again. I’m back to using the hand-coded sidebar asides from here instead: http://codex.wordpress.org/Adding_Asides

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Strange Commet or Category RSS Problems’ is closed to new replies.