Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter awfief

    (@awfief)

    Aha!

    I found the problem — I was using viewlevel as a plugin, and I’d made at least 9 protected posts. So it was retrieving all the posts, they just were protected.

    Well, you could modify the query in

    wp-content/plugins/montharchive.php

    on or about line 33 (I have v 0.1):
    $query = mysql_query(“SELECT *, year(post_date) as year, month(post_date) as month FROM $tableposts WHERE year(post_date)=’$year’ AND month(post_date)=’$date[month]’ ORDER BY id desc”) or die(mysql_error());

    You can add

    AND post_category=#

    where post_category is the number of the category, which you can find in the wp_categories table. So, for instance, if you want only the category “General” you’d do the following in your database to find the #:

    select cat_ID from wp_categories where cat_name=”General”;

    The result, in my case, is 1. (not surprising)

    So I’d change the query to:
    $query = mysql_query(“SELECT *, year(post_date) as year, month(post_date) as month FROM $tableposts WHERE year(post_date)=’$year’ AND month(post_date)=’$date[month]’ AND post_category=1 ORDER BY id desc”) or die(mysql_error());

    Hope this is helpful, I was looking for a different question/answer and found this one.

    Thread Starter awfief

    (@awfief)

    If by reset, you mean going to Options->Permalinks, clicking “Update Permalink Structure” with the current values already there, and then copying the .htaccess again, then yes, I’ve done that. 🙁 It’s weird, because the links on the right hand side work, in the menu, but not in the articles themselves. It almost sounds like a function issue.

    (ie, link looks like this:
    General

    )

    the_category() is what’s failing, even though wp_list_cats() shows up correctly. (ie, the function called from the article just after “Filed under” is the_category(), whereas for the category listings, it’s wp_list_cats().

    the_category calls get_the_category_list. The function get_category_link gets the link, and the object function cat_name gets the name. So it looks like get_category_link is the problem, but I don’t know how to debug it. . .

    Thread Starter awfief

    (@awfief)

    Yes, I know that, that’s why I said twice that I have posts in the categories. I read up on all that stuff, there were many posts of “why can’t I see my category?” as well as a FAQ, I think. That wasn’t my problem. Although none of those addressed private vs. public.

    Meanwhile, any ideas about why the category links for “Filed under:” aren’t working? Something wrong with the_category or something?

    Thread Starter awfief

    (@awfief)

    Eeenteresting. It seems that only PRIVATE posts count for the sub-sub-category problem. That’s annoying, but understandable why that feature is there. Any way to get around that? I want people to see the category even if they can’t see the post.

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