[wp-trac] [WordPress Trac] #3707: error msg replaces blogroll

[WordPress Trac]

#3707: error msg replaces blogroll
---------------------------+------------------------------------------------
 Reporter:  longhand       |       Owner:  matt            
     Type:  defect         |      Status:  new             
 Priority:  normal         |   Milestone:  2.3             
Component:  WordPress.org  |     Version:  2.1             
 Severity:  normal         |    Keywords:  sql syntax mysql
---------------------------+------------------------------------------------
 Where the blogroll usually is in my right margin
 (www.benpollock.com/brick/), the following message has appeared, since I
 upgraded this past week to WordPress 2.1 from 2.07:

 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 message agove appears in any of the browsers I use: Safari, Firefox
 and Internet Explorer.

 I always upgrade using Fantastico from my host service, Hosting Matters.
 The MySQL version is 4.1.21-standard, and PHP version is 4.4.2, which are
 within the parameters for WordPress 2.1, according to your Web site. I
 have done absolutely no code customization or augmentation of it, other
 than activating Akismet. I use a standard "theme" I got off the WordPress
 site.

 While I have FTP software on my home computer and thus can access the
 remote files, I have no experience in PHP etc., just straight html, so if
 I am to fix this, I'll need some electronic hand-holding.

 However, I'm hoping this is a common problem with a common fix I can
 access from something like 2.1.1 real soon. -Ben

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3707>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software