WordPress.org

1. illuminen
   Member
   Posted 2 years ago #

   My blogroll managemnt doesn't seem to work. Actually anything concerning categarized links doesn't seem to work at all. I've just upgraded...I really don't know why it's doing this. When I go to management page I get this:

   WordPress database error: [Table 'diioxyd_wrdp1.wp_link2cat' doesn't exist]
SELECT category_id FROM wp_link2cat WHERE link_id = 26 ORDER BY category_id

   And when I go to display my links I get this:

   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

   Anyone knows why it's doing that?

2. foolswisdom
   Moderator
   Posted 2 years ago #

   That is strange. Your database did not get upgraded. Neither table link2cat nor wp_categories column link_count where in WP 2.0, but are in 2.1 .

   My guess is that you did not completely replace the relevant files (including the file that contains the version which triggers the appropriate upgrade). Please explicitly work through the upgrade instructions.

3. illuminen
   Member
   Posted 2 years ago #

   Is there an official way to upgrade? Maybe I did the upgrade the wrong way. Is it possible that it's a new way different from the ones before?

4. illuminen
   Member
   Posted 2 years ago #

   I did the upgrade as it says in the codex...nothing has changed.

5. natthedem
   Member
   Posted 2 years ago #

   I did the same thing and I'm getting the same error:

   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

6. svgal
   Member
   Posted 2 years ago #

   I have the same error, and I have uploaded and installed WP 2.1 three times.

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

7. rashid
   Member
   Posted 2 years ago #

   I'm getting this too.

   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

   I've totally removed every file - started with an empty directory and reinstalled everything (except the db of course)

   I get the error on the standard kubrick theme.

   This is what appears in Manage/Blogroll

   WordPress database error: [Table 'wp.wp_link2cat' doesn't exist]
   SELECT category_id FROM wp_link2cat WHERE link_id = 9 ORDER BY category_id
   Revealed Resources
   revealedresources.com Yes Edit Delete
   WordPress database error: [Table 'wp.wp_link2cat' doesn't exist]
   SELECT category_id FROM wp_link2cat WHERE link_id = 8 ORDER BY category_id
   Selling to big companies
   sellingtobigcompanies.blogs.com Yes Edit Delete
   WordPress database error: [Table 'wp.wp_link2cat' doesn't exist]
   SELECT category_id FROM wp_link2cat WHERE link_id = 10 ORDER BY category_id

8. adam8281
   Member
   Posted 2 years ago #

   Similar problem, using the Durable theme, here is what appears under Pages & Links:

   WordPress database error: [Incorrect table name '']
   SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit FROM wp_links LEFT JOIN ON (link_category = cat_id) WHERE link_visible = 'Y' AND list_limit <> 0 ORDER BY cat_name

9. adam8281
   Member
   Posted 2 years ago #

   I think I may have found the locus of the problem. In my functions.php I have this text:

   // Fetch the link category data as an array of hashesa
   $cats = $wpdb->get_results("
   SELECT DISTINCT link_category, cat_name, show_images,
   show_description, show_rating, show_updated, sort_order,
   sort_desc, list_limit
   FROM $wpdb->links
   LEFT JOIN $wpdb->linkcategories ON (link_category = cat_id)
   WHERE link_visible = 'Y'
   AND list_limit <> 0
   ORDER BY $cat_order $direction ", ARRAY_A);

   Do I need to change something in there to get 2.1 to recognize categories?

10. svgal
    Member
    Posted 2 years ago #

    I fixed the problem by changing the line that calls the links in sidebar.php. Another member posted this answer for the link problem: http://wordpress.org/support/topic/101683#post-502865

11. adam8281
    Member
    Posted 2 years ago #

    I fixed my problem by changing a function call in sidebar.php as well. I also had to change a function in the "durable" theme that made categories appear as a category cloud, but now no longer works.

12. fangohr
    Member
    Posted 2 years ago #

    I have the same problem. My homepage comes up with no content, and I get this message: "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"

    The theme is a slightly modified default (kubick, I think it was called)

    http://guckenheim.org

    Does anybody know how to fix this?

13. fangohr
    Member
    Posted 2 years ago #

    Strange it magically works now.

14. johnbakeronline
    Member
    Posted 2 years ago #

    I'm getting something similar.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
    SELECT cat_id, cat_name FROM

    Can anyone interpret this? Surely someone has got the links working by now?

15. henkmsncam
    Member
    Posted 2 years ago #

    I am having the sme and upgraded like i should!

16. fivemcclungs
    Member
    Posted 2 years ago #

    I'm getting the same issue on the Write Post Categories sidebar:

    `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`

    Can someone please help.

17. kshipp
    Member
    Posted 2 years ago #

    I have the same error, and I have uploaded and installed latest WP three times.

18. MichaelH
    moderator
    Posted 2 years ago #

    kshipp-please continue on thread you commented on: http://wordpress.org/support/topic/115353?replies=2

19. paar
    Member
    Posted 2 years ago #

    I have this same problem in my categories.
    I finally found this problem is:
    I used a mysql db user that has not enough permission to upgrade my WP database.
    I solved it this way:
    1. get wordpress-2.0.2
    2. change wordpress-2.0.2/wp-config.php, DB_USER="root" (of course change its passwd)
    3. use wordpress-2.0.2/wp-admin/upgrade.php, it will downgrade back to version 2.0.2's DB.
    4. change wordpress-2.2//wp-config.php, DB_USER="root"
    5. use wordpress-2.2/wp-admin/upgrade.php, everything is OK.
    6. change back wp-config.php's DB_USER.
    have fun!

20. rdhyee
    Member
    Posted 2 years ago #

    I had the same problem, which I solved by updating to the latest version of the durable theme: http://www.blazenewmedia.com/projects/durable

Topic Closed

This topic has been closed to new replies.