WordPress.org

Support

Support » How-To and Troubleshooting » Blogroll management

Blogroll management

  • My blogroll managemnt doesn’t seem to work. Actually anything concerning categarized links doesn’t seem to work at all. I’ve just upgraded…I really don’t know why it’s doing this. When I go to management page I get this:

    WordPress database error: [Table 'diioxyd_wrdp1.wp_link2cat' doesn't exist]
    SELECT category_id FROM wp_link2cat WHERE link_id = 26 ORDER BY category_id

    And when I go to display my links I get this:

    WordPress database error: [Unknown column 'link_count' in 'where clause']
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_name ASC

    Anyone knows why it’s doing that?

Viewing 15 replies - 1 through 15 (of 19 total)
  • foolswisdom

    @foolswisdom

    Moderator

    That is strange. Your database did not get upgraded. Neither table link2cat nor wp_categories column link_count where in WP 2.0, but are in 2.1 .

    My guess is that you did not completely replace the relevant files (including the file that contains the version which triggers the appropriate upgrade). Please explicitly work through the upgrade instructions.

    Is there an official way to upgrade? Maybe I did the upgrade the wrong way. Is it possible that it’s a new way different from the ones before?

    I did the upgrade as it says in the codex…nothing has changed.

    I did the same thing and I’m getting the same error:

    WordPress database error: [Unknown column ‘cat_1’ in ‘order clause’]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_1 ASC

    I have the same error, and I have uploaded and installed WP 2.1 three times.

    [Unknown column ‘cat_order’ in ‘order clause’]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_order ASC

    I’m getting this too.

    WordPress database error: [Unknown column ‘link_count’ in ‘where clause’]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_name ASC

    I’ve totally removed every file – started with an empty directory and reinstalled everything (except the db of course)

    I get the error on the standard kubrick theme.

    This is what appears in Manage/Blogroll

    WordPress database error: [Table ‘wp.wp_link2cat’ doesn’t exist]
    SELECT category_id FROM wp_link2cat WHERE link_id = 9 ORDER BY category_id
    Revealed Resources
    revealedresources.com Yes Edit Delete
    WordPress database error: [Table ‘wp.wp_link2cat’ doesn’t exist]
    SELECT category_id FROM wp_link2cat WHERE link_id = 8 ORDER BY category_id
    Selling to big companies
    sellingtobigcompanies.blogs.com Yes Edit Delete
    WordPress database error: [Table ‘wp.wp_link2cat’ doesn’t exist]
    SELECT category_id FROM wp_link2cat WHERE link_id = 10 ORDER BY category_id

    Similar problem, using the Durable theme, here is what appears under Pages & Links:

    WordPress database error: [Incorrect table name ”]
    SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit FROM wp_links LEFT JOIN ON (link_category = cat_id) WHERE link_visible = ‘Y’ AND list_limit <> 0 ORDER BY cat_name

    I think I may have found the locus of the problem. In my functions.php I have this text:

    // Fetch the link category data as an array of hashesa
    $cats = $wpdb->get_results(“
    SELECT DISTINCT link_category, cat_name, show_images,
    show_description, show_rating, show_updated, sort_order,
    sort_desc, list_limit
    FROM $wpdb->links
    LEFT JOIN $wpdb->linkcategories ON (link_category = cat_id)
    WHERE link_visible = ‘Y’
    AND list_limit <> 0
    ORDER BY $cat_order $direction “, ARRAY_A);

    Do I need to change something in there to get 2.1 to recognize categories?

    I fixed the problem by changing the line that calls the links in sidebar.php. Another member posted this answer for the link problem: http://wordpress.org/support/topic/101683#post-502865

    I fixed my problem by changing a function call in sidebar.php as well. I also had to change a function in the “durable” theme that made categories appear as a category cloud, but now no longer works.

    I have the same problem. My homepage comes up with no content, and I get this message: “WordPress database error: [Unknown column ‘link_count’ in ‘where clause’]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_name ASC”

    The theme is a slightly modified default (kubick, I think it was called)

    http://guckenheim.org

    Does anybody know how to fix this?

    Strange it magically works now.

    I’m getting something similar.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
    SELECT cat_id, cat_name FROM

    Can anyone interpret this? Surely someone has got the links working by now?

    I am having the sme and upgraded like i should!

    I’m getting the same issue on the Write Post Categories sidebar:

    `WordPress database error: [Unknown column ‘link_count’ in ‘where clause’]
    SELECT cat_ID FROM wp_categories WHERE category_parent = 0 AND ( link_count = 0 OR category_count != 0 OR ( link_count = 0 AND category_count = 0 ) ) ORDER BY category_count DESC`

    Can someone please help.

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Blogroll management’ is closed to new replies.
Skip to toolbar