WordPress.org

Ready to get started?Download WordPress

Forums

Categories/Blogroll Links problems after upgrading (3 posts)

  1. nikita2471
    Member
    Posted 7 years ago #

    I upgraded my WP version through Fantastico to 2.2.1 the other day and noticed that I would get the following error if I wanted to select a category to for my post on the "Write" page:

    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

    I also cannot get any of my Blogroll Links to show up on my blog. I get the following error:

    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

    This shows up, even if I am using the WP default template. If I go to the Blogroll section in the admin panel, these errors show up:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Now, I have gone through the support forum and read as much as I could find on these error problems and I haven't found an actual solution to this. I manually upgraded my blog from 2.2.1 to 2.2.2 just now and I still get the same errors.

    Can anyone help? I can't update my blog without selecting what category to put each post in.

    Blog: http://www.silent-r.com/eyes

  2. moshu
    Member
    Posted 7 years ago #

    Did you upgrade your theme?
    Most likely it is using template tags that were deprecated.
    see the list: http://codex.wordpress.org/Template_Tags#Category_tags
    and
    http://codex.wordpress.org/Template_Tags#Links_Manager_tags

  3. nikita2471
    Member
    Posted 7 years ago #

    I just uploaded the classic & default themes from the 2.2.2 version and I still get the same error.

    Edit: Ok, I think I understand what is going on with the Blogroll Links part. It's the Link categories that I was using. If I don't use them, then I don't get the error.

    I still need a solution for the problem with the categories error I get on my Write page tho.

Topic Closed

This topic has been closed to new replies.

About this Topic