MySQL error after update to 2.1

  • Resolved obscure

    (@obscure)


    17 years, 2 months 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

Viewing 8 replies - 1 through 8 (of 8 total)
  • chrisharavata

    (@chrisharavata)

    17 years, 2 months 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…

    Thread Starter obscure

    (@obscure)

    17 years, 2 months ago

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

    Thread Starter obscure

    (@obscure)

    17 years, 2 months ago

    The exact code causing the problem is the Blogroll.

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

    Chris_K

    (@handysolo)

    17 years, 2 months ago

    I don’t think that theme is 2.1 ready.

    Replace that with wp_list_bookmarks.

    dsquared

    (@dsquared)

    17 years, 2 months 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.

    Thread Starter obscure

    (@obscure)

    17 years, 2 months 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.

    dsquared

    (@dsquared)

    17 years, 2 months 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.

    Thread Starter obscure

    (@obscure)

    17 years, 2 months 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.

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