MySQL error after upgrade to 2.1

  • My host has WordPress available for automatic install/upgrade. I used their upgrade service (after backing some things up myself just in case) and everything seems to have gone smoothly, apart from this error which displays in the sidebar, under the archives list, where all my links should be (they don’t display):

    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

    I am using the veryplaintxt theme.
    The error occurred before I had activated any plugins so it can’t be due to that, I think.

    My post categories display properly in the sidebar, but none of the links, nor their categories, show up.

    https://www.language-global.com/blog

Viewing 2 replies - 16 through 17 (of 17 total)
  • driveafastercar

    (@driveafastercar)

    PERFECT! Before the link code was <?php get_links_list(‘id-‘); ?>. All I had to do was change it to <?php get_links_list(‘id’); ?> and it was fixed! All that for a little ‘-‘! Thank you!

    (This was in the veryplaintxt theme post-upgrade, fyi.)

    Yes, i had the exact same problem. I was using a modified version of veryplaintxt theme.

    Go to sidebar.php file in Theme editor and replace <?php get_links_list(‘id-‘); ?> with <?php get_links_list(‘id’); ?>

    It works great now. Thanks.

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘MySQL error after upgrade to 2.1’ is closed to new replies.