Too many categories > problems

  • 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:

    https://www.ads-software.com/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: https://www.neveryetmelted.com
    Version: 2.0.2

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

  • 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.

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

    Either that, your host deleted it or something…

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

    Thread Starter venator48

    (@venator48)

    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?

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

    Thread Starter venator48

    (@venator48)

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

    Any suggestions on how to go about using it?

    Thread Starter venator48

    (@venator48)

    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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Too many categories > problems’ is closed to new replies.