Make WordPress Core

Opened 17 years ago

Closed 17 years ago

#3707 closed defect (bug) (invalid)

error msg replaces blogroll

Reported by: longhand's profile longhand Owned by: matt's profile matt
Milestone: Priority: normal
Severity: normal Version: 2.1
Component: Site Keywords: sql syntax mysql
Focuses: Cc:


Where the blogroll usually is in my right margin (, 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

Change History (1)

#1 @foolswisdom
17 years ago

  • Milestone 2.3 deleted
  • Resolution set to invalid
  • Status changed from new to closed

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. does not currently say that is supports 2.1

Aside, the WordPress site does not currently host themes.

Note: See TracTickets for help on using tickets.