WordPress.org

Support

Support » How-To and Troubleshooting » Categories/Blogroll Links problems after upgrading

Categories/Blogroll Links problems after upgrading

  • 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

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Categories/Blogroll Links problems after upgrading’ is closed to new replies.
Skip to toolbar