WordPress.org

Ready to get started?Download WordPress

Forums

Too many categories > problems (8 posts)

  1. venator48
    Member
    Posted 7 years ago #

    I have a great many categories (hundreds). For some time, I have had a gap in the categorties listing in the WRITE window.

    Today, a posting with new categories proved to produce really one too many categories and categories ceased to come up, and I got an SQL 127 error.

    I found here:

    http://wordpress.org/support/topic/57065?replies=7
    ---------------------
    the reply:

    aprilprincesse
    Member
    I've been searching for the answer to this question for the past week and I finally fixed my problem, maybe this can help you guys.

    In the admin-functions.php (in your wp-admin) folder find this:

    function return_categories_list($parent = 0) {
    global $wpdb;
    return $wpdb->get_col("SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent ORDER BY category_count DESC LIMIT 100");

    See where it says LIMIT 100? I think that limits the number of categories shown to 100, I changed it to 1000 and all my categories appear now in my "Write Post" page. Hope this helps someone!

    Posted: 2006-03-14 17:34:54 #

    -------------------

    I edited the file, and increased the limit to 5000 (from 100).

    Now categories load on my blog, but I find in the WRITE
    window, this error:

    WordPress database error: [File './wp/wp_comments.MYD' not found (Errcode: 13)]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    Blog is: http://www.neveryetmelted.com
    Version: 2.0.2

  2. Chris_K
    Member
    Posted 7 years ago #

    Hmm... errcode: 13 would seem to indicate a MySQL issue. My understanding is that it is related to mysql and permissions. You probably want to contact your host.

  3. Just repair the MySQL table (wp_comments). It got corrupted it appears.

    Either that, your host deleted it or something...

  4. vkaryl
    Member
    Posted 7 years ago #

    And you really need to upgrade to the latest wp version.

  5. venator48
    Member
    Posted 7 years ago #

    I'll try. Unfortunately, I have to ask my host (Yahoo) to do the repair. Yahoo's service has been terrible.

    I need to find somebody to do some work for me. I need those categories linked, but off the main page. I guess that would be a Theme modification. Any advice on where to find somebody?

  6. If you have phpMyAdmin, just use that. Otherwise, it's probably worth installing it yourself (and it's not hard either). :)

  7. venator48
    Member
    Posted 7 years ago #

    I have phpMyAdmin. Not hard, he says! (The Comments database is the broken one.)

    Any suggestions on how to go about using it?

  8. venator48
    Member
    Posted 7 years ago #

    Current error reads:

    WordPress database error: [File './wp/wp_comments.MYD' not found (Errcode: 13)]
    SELECT * FROM wp_comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT 0,20

    Somehow this is caused by

    --------------------
    In the admin-functions.php (in your wp-admin) folder find this:

    function return_categories_list($parent = 0) {
    global $wpdb;
    return $wpdb->get_col("SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent ORDER BY category_count DESC LIMIT 100");

    See where it says LIMIT 100? I think that limits the number of categories shown to 100, I changed it to 1000 and all my categories appear now in my "Write Post" page. Hope this helps someone!

    Posted: 2006-03-14 17:34:54 #

    -------------------

    I edited the file, and increased the limit to 5000 (from 100).
    ---------------------------------

    editing that limit, and changing it from 100 to 5000.

    Presumably upgrading from 2.0.2 to 2.0.4 will make that limit 100 again.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags