PostsInCategory 1669 limit?

  • HappyD

    (@happyd)


    19 years, 4 months ago

    I implemented the wordpress plugin PostsInCategory and it has worked well until I loaded all 10,000+ error messages for the Oracle database and tried to load them on a page using the PostsInCategory plugin. It displayed 1,000 results. After looking into the plugin I found this line:

    $query = ‘order=ASC&orderby=post_title&numberposts=1000&category=’ . $cat_ID;

    and edited it only to find the page would not load if the value is set above 1669. Is there any reason for this, or a work around that someone knows of? The page I am working with is:

    http://www.dbaplace.com/oracle-errors/

    Any help is very much appreciated. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    19 years, 4 months ago

    Do you have a link to that plugin?

    Thread Starter HappyD

    (@happyd)

    19 years, 4 months ago

    Michael, Thank you for your reply. The link in the source is http://www.sns.ias.edu/~cjm/wp/wordpress/posts-in-category/, but it no longer works, though this guy’s main page still does. It’s a plug in we’ve been using on a few sites for a few years, it may no longer be maintained? I have not had an issue before, but also don’t have another site that has 1000+ posts in one category. I emailed the author last night and he replied with:

    “Ken-

    It must besome limitation of the WordPress DB connection – I am just guessing here. Maybe there is a master configuration file in WordPress that limits max query size.. let me know if you find anything.

    -Chris”

    I checked into wp-includes/functions.php for “function get_posts” and did not see anything obvious. There is a limit clause in the SQL code, but the limit seems to be r[‘offset’],r[‘numberposts’], which numberposts seems to be grabbing the correct total.

    I’ve removed the oracle error code entries for another unrelated reason, but will be running my dump script to add them back in again tonight when I can work on it some more. I suppose it could be my style sheet? I’ve been slowly fixing other issues in my custom theme.

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

The topic ‘PostsInCategory 1669 limit?’ is closed to new replies.

Tags