nikita2471I 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_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 16 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 19 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 12 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 14 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 13 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 18 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 20 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 10 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 22 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 11 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 21 ORDER BY category_idWordPress database error: [Table 'silentl_wrdp2.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 17 ORDER BY category_idWordPress 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.
