WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] MySQL error after update to 2.1 (9 posts)

  1. obscure
    Member
    Posted 7 years ago #

    Just upgraded my site (www.obscure.co.uk/blog) 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 (http://www.plaintxt.org/themes/veryplaintxt/) and it says it is 2.1 compat.

    My host is running MySql v5.0

    Anyone have any ideas as to the cause?

    Thanks

  2. ChrisHaravata
    Member
    Posted 7 years ago #

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

  3. obscure
    Member
    Posted 7 years ago #

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

  4. obscure
    Member
    Posted 7 years ago #

    The exact code causing the problem is the Blogroll.

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

  5. Chris_K
    Member
    Posted 7 years ago #

    I don't think that theme is 2.1 ready.

    Replace that with wp_list_bookmarks.

  6. dsquared
    Member
    Posted 7 years ago #

    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.

  7. obscure
    Member
    Posted 7 years ago #

    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.

  8. dsquared
    Member
    Posted 7 years ago #

    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.

  9. obscure
    Member
    Posted 7 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags