Title: Stupid WordPress SQL Last modified: August 18, 2016 --- # Stupid WordPress SQL * [netmasa](https://wordpress.org/support/users/netmasa/) * (@netmasa) * [19 years, 4 months ago](https://wordpress.org/support/topic/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) 1 [2](https://wordpress.org/support/topic/stupid-wordpress-sql/page/2/?output_format=md) [3](https://wordpress.org/support/topic/stupid-wordpress-sql/page/3/?output_format=md) [→](https://wordpress.org/support/topic/stupid-wordpress-sql/page/2/?output_format=md) * [Chris_K](https://wordpress.org/support/users/handysolo/) * (@handysolo) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507239) * Was this before or after you ran http://yoursite.com/blog/wp-admin/upgrade.php? * [spartikus](https://wordpress.org/support/users/spartikus/) * (@spartikus) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507246) * I’m getting the same thing. I ran upgrade.php and the problem is still there. * Thread Starter [netmasa](https://wordpress.org/support/users/netmasa/) * (@netmasa) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507251) * 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. * [arboltsef](https://wordpress.org/support/users/arboltsef/) * (@arboltsef) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507259) * I´m having the same errors. * Thread Starter [netmasa](https://wordpress.org/support/users/netmasa/) * (@netmasa) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507264) * Arg. Could this please be fixed? * [spartikus](https://wordpress.org/support/users/spartikus/) * (@spartikus) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507265) * netMASA & arboltsef, * Did you use WP-Manage to upgrade to 2.1? * Thread Starter [netmasa](https://wordpress.org/support/users/netmasa/) * (@netmasa) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507352) * no. I didn’t * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507358) * MySQL version should be 4.0 or higher. Is that the problem? * [http://wordpress.org/about/requirements/](http://wordpress.org/about/requirements/) * [arboltsef](https://wordpress.org/support/users/arboltsef/) * (@arboltsef) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507383) * 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. * [spartikus](https://wordpress.org/support/users/spartikus/) * (@spartikus) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507387) * 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. * [Trent Adams](https://wordpress.org/support/users/trent/) * (@trent) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507389) * 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: * `` * or simply just: * `` * Trent * [arboltsef](https://wordpress.org/support/users/arboltsef/) * (@arboltsef) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507413) * 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? * [foolswisdom](https://wordpress.org/support/users/foolswisdom/) * (@foolswisdom) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507414) * 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. * Thread Starter [netmasa](https://wordpress.org/support/users/netmasa/) * (@netmasa) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507549) * Alright, I reinstalled. Then I updated and I got the same thing again * [spartikus](https://wordpress.org/support/users/spartikus/) * (@spartikus) * [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/#post-507559) * 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) 1 [2](https://wordpress.org/support/topic/stupid-wordpress-sql/page/2/?output_format=md) [3](https://wordpress.org/support/topic/stupid-wordpress-sql/page/3/?output_format=md) [→](https://wordpress.org/support/topic/stupid-wordpress-sql/page/2/?output_format=md) The topic ‘Stupid WordPress SQL’ is closed to new replies. ## Tags * [sql](https://wordpress.org/support/topic-tag/sql/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 35 replies * 14 participants * Last reply from: [protechs](https://wordpress.org/support/users/protechs/) * Last activity: [19 years, 4 months ago](https://wordpress.org/support/topic/stupid-wordpress-sql/page/3/#post-507814) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics