WordPress.org

Forums

2.1 RC1 link/blogroll problem (19 posts)

  1. stitzelj
    Member
    Posted 8 years ago #

    I just tried to upgrade to the 2.1 RC1 but ended up with a blogroll problem that's returning an error message:

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

    It initially told me that the link2cat table didn't exist, so I tried to set it up manually. The error message above is the result from that endeavor. Any ideas on how to fix it? I'm guessing that the link associations didn't transfer to the new table properly. Would some snippet of SQL code do the trick?

  2. stitzelj
    Member
    Posted 8 years ago #

    Add one more to this:

    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

    Apparently none of my post categories came over, either.

    Help!

  3. Trent Adams
    Member
    Posted 8 years ago #

    As Moshu explained earlier, 2.1 is not supported in these forums as it is for testers and unreleased but look at default template that comes with 2.1 for answers as 2.1 uses new call for blogroll.

    Trent

  4. maitri
    Member
    Posted 8 years ago #

    Just log out, log back in and upgrade your database just like you did the first time you installed WordPress. Once the upgrade takes, you're in business. Also make sure that you have done a clean install. Actually going in and deleting all old files and replacing them with the new content helps.

  5. foolswisdom
    Moderator
    Posted 8 years ago #

    The issue is that your database is not being updated. You do not have the 2.1 tables and columns. The database upgrade is triggered based only the installed files and then running upgrade, so be sure that all of the WordPress files have been installed.

  6. gimmeahug
    Member
    Posted 8 years ago #

    i have the same problem. i deleted all the files on the server (except for config and wp-content) and uploaded all data. i mean i've done dozens of updates, so i know what i'm doing, but this time i get the same error over and over. i logged out, logged back in, ran the upgrade script again and still... it's there. i replaced the tag with the wp_get_bookmarks tag and still! it's there. and it won't go away. what do i do?

  7. BinaryMoon
    Member
    Posted 8 years ago #

    This is definitely a problem and has nothing to do with not upgrading since I get the same errors and have now run the upgrade script three times.

  8. gimmeahug
    Member
    Posted 8 years ago #

    yea, i was upgrading 3 times as well. i got the files deleted first and then put the new ones up. then i got a blank screen. so i re-uploaded the files and overwrote them on the server. now it works but i get this f**k mentioned above. but there are aparently quite a few people out there having this problem.

  9. BinaryMoon
    Member
    Posted 8 years ago #

    I gave up and restored my backups. I will consider upgrading again in a couple of weeks (when all this is hopefully fixed)

  10. dreadPirateDru
    Member
    Posted 8 years ago #

    ok... yet another with the dreaded: "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"

    also all my pages are turning up as posts as well, and the categories are not being handled properly... i wish i knew what to fix, cuz i would... gonnah take a look at my copy this week...

    have the following plugins installed:
    -------------------------------------
    AJAX Comments 2.07
    Akismet 2.0
    Audio player 1.2.3
    Breadcrumb Navigation XT 1.6
    Category Tagging 1.3
    Democracy 2.0.1
    Event Calendar 3.1.0
    Event Calendar Widget 3.1.0
    Flash Tag Cloud 0.1
    Page Category Organiser 2.0
    Quick Stats 1.1
    Random Admin Taglines (Hello Dolly) 1.5
    Related Posts 2.02 + 404
    Ultimate Tag Warrior 3.14159
    Ultimate Tag Warrior: Tag Archive 1.0
    -------------------------------------

    now i know i am SURE that i could be doing sumptin' stupid... or am completely missing the issue because i have not looked deeper.

  11. adam8281
    Member
    Posted 8 years ago #

    Same problem, is there any good fix yet?!

  12. dreadPirateDru
    Member
    Posted 8 years ago #

    ??

  13. idogicat
    Member
    Posted 8 years ago #

    deleted.

    (I am sorry that I got here from google, didn't pay attention to that this is about 2.1 RC1 instead of the release...)

  14. idogicat
    Member
    Posted 8 years ago #

    deleted.

  15. icapdeville
    Member
    Posted 8 years ago #

    Just try this mysql query

    ALTER TABLE --database--.wp_categories ADD COLUMN link_count BIGINT(20) NOT NULL DEFAULT 0 AFTER category_count,
    ADD COLUMN posts_private TINYINT(1) NOT NULL DEFAULT 0 AFTER link_count,
    ADD COLUMN links_private TINYINT(1) NOT NULL DEFAULT 0 AFTER posts_private;

    work for me :)

  16. tomschuring
    Member
    Posted 8 years ago #

    worked for me as well, but why isn't this build into the update script ?

  17. thetoddblog
    Member
    Posted 8 years ago #

    How do you do that query? Myphpadmin won't work for me on Yahoo!

    (MySQL noob)

  18. ronchicago
    Member
    Posted 8 years ago #

    I am having v2.1 similar issues and four weeks have past and I have the following question in my mind...downgrade back to v2.0?

    Any thought here?

  19. Moominmama
    Member
    Posted 7 years ago #

    icapdeville, thanks for this -- it fixed my broken categories after my upgrade to 2.1.3

    I know this is an old post but wanted to bump it in case anyone else came looking!

    this woman's work

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags