Title: Archives Database Error
Last modified: August 19, 2016

---

# Archives Database Error

 *  [mwalsh](https://wordpress.org/support/users/mwalsh/)
 * (@mwalsh)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/archives-database-error/)
 * Hi,
 * I’ve noticed the archives on my WordPress 2.7 installation are no longer working.
   I’ve also upgraded to 2.7.1 which did not fix the problem.
 * The error is:
 * 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”
   at line 1 for query SELECT COUNT(DISTINCT ID) FROM made by require, require_once,
   include
 * The rest of the blog is functioning correctly so it’s just the archives. I’m 
   running MySQL 5.1.11.
 * Any advice you can offer would be gratefully received as I need to get this fixed
   ASAP!
 * Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [mwalsh](https://wordpress.org/support/users/mwalsh/)
 * (@mwalsh)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/archives-database-error/#post-1026354)
 * Any ideas on this?
 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/archives-database-error/#post-1026355)
 * I would run a repair on the database tables with your host’s phpmyadmin

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Archives Database Error’ is closed to new replies.

## Tags

 * [archives](https://wordpress.org/support/topic-tag/archives/)
 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Samuel B](https://wordpress.org/support/users/samboll/)
 * Last activity: [17 years, 2 months ago](https://wordpress.org/support/topic/archives-database-error/#post-1026355)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics