Support » Installing WordPress » MySQL error after update to 2.1

  • Resolved obscure


    Just upgraded my site ( and am getting an error. Something in the sidebar to the left isn’t happy.

    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 ‘ASC’ at line 1]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_id- ASC

    The theme I am using is veryplaintxt ( and it says it is 2.1 compat.

    My host is running MySql v5.0

    Anyone have any ideas as to the cause?


Viewing 8 replies - 1 through 8 (of 8 total)
  • when upgrading to 2.1, have you deactivated all plugins that you have?? normally, that’s what happens if you still have a plugin or two activated when upgrading…

    Yes I deactivated them all, deleted the old blog files and then uploaded 2.1.

    The exact code causing the problem is the Blogroll.

    <?php get_links_list(‘id-‘); ?>

    I don’t think that theme is 2.1 ready.

    Replace that with wp_list_bookmarks.

    I think WordPress is becoming a complete joke, 6 zillion programs, that don’t have instructions with no centralization that break tons of things.

    I’m having this same problem. obscure, what version of the theme so you have installed? I sent you an e-mail, please AIM or Skype me.

    Thanks for that Handy. Seems an update to the theme slipped out without me noticing (which may not have the problem). However I updated my version of the theme with your tip and it works great.

    but why was it necessary to change this code at all? It’s not fun upgrading wordpress, it’s a chore due to a lack of caring about the user experience by Matt.

    Well the Theme was the problem and that isn’t under WPs control. It is up to the Theme author to keep it up to date and working.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘MySQL error after update to 2.1’ is closed to new replies.