Forums

2.2 Database Error (Blogroll and Categories) (10 posts)

  1. dlsmith
    Member
    Posted 4 years ago #

    I just upgraded to 2.2 and neither my blogroll nor my categories (when I am writing) will display properly. I followed the upgrade instructions to the letter, and I am having no other problems. The error code I am getting is below. Can anyone provide any advice?

    This is what I get:

    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

  2. moshu
    Member
    Posted 4 years ago #

    Probaby you re using a theme that is not compatible with 2.2!
    Check out the deprecated template tags and replace them with the new ones.
    http://codex.wordpress.org/Template_Tags#Category_tags
    http://codex.wordpress.org/Template_Tags#Links_Manager_tags

  3. Otto
    Tech Ninja
    Posted 4 years ago #

    [Unknown column 'link_count' in 'where clause']

    Your upgrade did not go well. The database did not get upgraded properly.

    Restore from your backup and try again.

  4. dlsmith
    Member
    Posted 4 years ago #

    Did two re-tries. Same result. Any other ideas?

  5. dlsmith
    Member
    Posted 4 years ago #

    Moshu, I did not realize your reply at first. I'll take a look and get back to you.

  6. dlsmith
    Member
    Posted 4 years ago #

    Moshu, I have tried several themes, all compatible with 2.2, and there is no change. I see the errors when I am logged into the database and writing, not just when a post has been published.

  7. moshu
    Member
    Posted 4 years ago #

    I am afraid my "diagnosis" was rushed a bit... Listen to Otto42, he knows way more about code :)

  8. Otto
    Tech Ninja
    Posted 4 years ago #

    Did two re-tries. Same result. Any other ideas?

    For whatever reason, your upgrade is simply not taking. The upgrade has to modify your database, and it's not doing that if you're getting that error.

    Figure out why it can't modify your database and you'll solve the problem. Short of that, I have no suggestions.

  9. dlsmith
    Member
    Posted 4 years ago #

    Thanks, Otto. I found the nature of my problem: http://wordpress.org/support/topic/111398?replies=2

  10. Dangerdom
    Member
    Posted 4 years ago #

    I am pretty sure that I am having the same problem with the deprecated template tags. However, I do not understand how to correct the problem. Any help?

Topic Closed

This topic has been closed to new replies.

About this Topic