Title: dummy needs archive.php help
Last modified: August 18, 2016

---

# dummy needs archive.php help

 *  [jgurley](https://wordpress.org/support/users/jgurley/)
 * (@jgurley)
 * [20 years, 8 months ago](https://wordpress.org/support/topic/dummy-needs-archivephp-help/)
 * Despite having used WP for about two years now, I am constantly flummoxed by 
   the archive template. I want to accomplish a simple thing, I think: to display
   a reverse chronological list of all entries since the dawn of time. (With dates
   and possibly small excerpts.)
 * I’ve tried this a few times over the years and just kept getting so frustrated
   that I kept giving up. My site has a deep enough archive of posts, though, that
   it no longer makes sense to not have an archive.
 * Much as I like WordPress, I’m just not very good at it. Help?

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

 *  [jonimueller](https://wordpress.org/support/users/jonimueller/)
 * (@jonimueller)
 * [20 years, 8 months ago](https://wordpress.org/support/topic/dummy-needs-archivephp-help/#post-252789)
 * Why don’t you try this plugin:
 * [http://www.sporadicnonsense.com/2005/04/28/clean-archives-plug-in/](http://www.sporadicnonsense.com/2005/04/28/clean-archives-plug-in/)
 * You can see it at work at my blog; just click on “Archives” on the side bar. 
   Perhaps this will suffice until you can figure out something better?
 *  Thread Starter [jgurley](https://wordpress.org/support/users/jgurley/)
 * (@jgurley)
 * [20 years, 8 months ago](https://wordpress.org/support/topic/dummy-needs-archivephp-help/#post-252793)
 * Actually, I would be very happy with that. I’ll download it and give it a whack.
   Thanks for the suggestion!
 *  Thread Starter [jgurley](https://wordpress.org/support/users/jgurley/)
 * (@jgurley)
 * [20 years, 8 months ago](https://wordpress.org/support/topic/dummy-needs-archivephp-help/#post-252795)
 * Bumped into a bit of a problem. When I go to [my archive page](http://www.deeplyshallow.com/archive.php)
   I get the following error:
 * > 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 ‘
   > WHERE post_date <‘2005-08-23 00:51:34’ AND post_status=’publish]
   >  SELECT DISTINCT
   > YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM
   > WHERE post_date <‘2005-08-23 00:51:34′ AND post_status=’publish’ AND post_password
   > =” GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
 * This is where I’m a little out of my range… any ideas where the problem might
   lie? (I haven’t modified the clean archives plugin at all.)

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

The topic ‘dummy needs archive.php help’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [jgurley](https://wordpress.org/support/users/jgurley/)
 * Last activity: [20 years, 8 months ago](https://wordpress.org/support/topic/dummy-needs-archivephp-help/#post-252795)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics