dummy needs archive.php help

  • jgurley

    (@jgurley)


    20 years, 8 months ago

    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

    (@jonimueller)

    20 years, 8 months ago

    Why don’t you try this plugin:

    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

    (@jgurley)

    20 years, 8 months ago

    Actually, I would be very happy with that. I’ll download it and give it a whack. Thanks for the suggestion!

    Thread Starter jgurley

    (@jgurley)

    20 years, 8 months ago

    Bumped into a bit of a problem. When I go to my archive page 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