Support » Fixing WordPress » Stupid WordPress SQL

  • AH!

    I updated to the latest version of wordpress (AFTER I CHECKED WHAT’S NEEDED AND WHAT PLUGINS DON’T WORK). And after doing so I get this for my blogroll (there are 5 blogs for 5 errors):

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

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

    And this shows up in the category box when I make a post. However the categories show up fine on the site:

    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

Viewing 15 replies - 1 through 15 (of 35 total)
  • Was this before or after you ran http://yoursite.com/blog/wp-admin/upgrade.php ?

    I’m getting the same thing. I ran upgrade.php and the problem is still there.

    after I ran upgrade.php. then I ran it again (because I found one small setting that was causing the whole site not to show [I checked all the files except for akiment and found it didn’t update]) and now I still have these errors.

    I´m having the same errors.

    Arg. Could this please be fixed?

    netMASA & arboltsef,

    Did you use WP-Manage to upgrade to 2.1?

    no. I didn’t

    MySQL version should be 4.0 or higher. Is that the problem?

    http://wordpress.org/about/requirements/

    WP-Manage? how does it help to solve the problem? (googling right away).

    MichaelH, my version of SQL is 4.0.26
    PHP Version 4.3.11.

    It doesn’t solve the problem. I thought it might have caused the problem.

    I reinstalled manually as well, following the instructions scrupulously, and the same thing happens.

    The blogroll call for 2.1 is a little different than on previous versions. Try something like this in your sidebar instead of what you have:

    <?php wp_list_bookmarks('title_after=&title_before='); ?>

    or simply just:

    <?php wp_list_bookmarks(); ?>

    Trent

    Well, that could solve the problem in the side bar.

    But when I click Blogroll, in the admin panel, it gives me this error:

    WordPress database error: [Table ‘arbolts_wp.att_link2cat’ doesn’t exist]
    SELECT category_id FROM att_link2cat WHERE link_id = 507 ORDER BY category_id

    WordPress database error: [Table ‘arbolts_wp.att_link2cat’ doesn’t exist]
    SELECT category_id FROM att_link2cat WHERE link_id = 506 ORDER BY category_id

    The errors that get netMASA in his first post, happen when I try to add a new link.

    I was wondering, I had a category called “links” before doing the upgrade and now it’s gone. It has anything to do with whats happening?

    Also, when I check “Categories”, in the admin panel… it doesn´t state a default category for links. Is it part of the problem?

    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.

    Alright, I reinstalled. Then I updated and I got the same thing again

    I’ve reinstalled manually 2x now – errors remain. upgrade.php was very quick. Is it supposed to be?

Viewing 15 replies - 1 through 15 (of 35 total)
  • The topic ‘Stupid WordPress SQL’ is closed to new replies.