error msg replaces blogroll
|Reported by:||longhand||Owned by:||matt|
|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