Opened 18 years ago
Closed 18 years ago
#3707 closed defect (bug) (invalid)
error msg replaces blogroll
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| Milestone: | Priority: | normal | |
| Severity: | normal | Version: | 2.1 |
| Component: | WordPress.org Site | Keywords: | sql syntax mysql |
| Focuses: | Cc: |
Description
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
Hello Ben, thank you for a detailed bug report!
Marking INVALID without confirming as likely issue is theme has not been updated to WordPress 2.1 .
A first step in our investigation should be trying to reproduce in a default installed theme.
http://www.plaintxt.org/themes/veryplaintxt/ does not currently say that is supports 2.1
Aside, the WordPress site does not currently host themes.