id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
3707,error msg replaces blogroll,longhand,matt,"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",defect (bug),closed,normal,,WordPress.org site,2.1,normal,invalid,sql syntax mysql,