Matt Banks

Thanks MichaelH!

Is there any way to make that an unordered list instead of paragraphs for each item? I tried it myself but I’m unsure where to put the closing ul tag?

Also, is it possible to display the full month name instead of the abbreviation?

Ok, I kinda got it, and here’s the code I’m using (copied from various sources plus things of my own)…

<?php
	$months = $wpdb->get_results("SELECT DISTINCT MONTH(post_date) AS month , YEAR(post_date) AS year
		FROM $wpdb->posts
		WHERE post_status = 'publish' and post_date <= now( ) and post_type = 'post' GROUP BY month, year ORDER BY post_date DESC");

	$posts = $wpdb->get_results("SELECT id, post_title, MONTH(post_date) AS month , YEAR(post_date) AS year
		FROM $wpdb->posts wposts, $wpdb->terms wterms, $wpdb->term_relationships wterm_relationships, $wpdb->term_taxonomy wterm_taxonomy
		WHERE wterm_relationships.object_id = wposts.ID
		AND wterm_relationships.term_taxonomy_id = wterm_taxonomy.term_taxonomy_id
		AND wterms.term_id = wterm_taxonomy.term_id
		AND wterm_taxonomy.taxonomy = 'post_tag'
		AND wterms.name = 'Reviews'
		AND wposts.post_status = 'publish'
		AND wposts.post_type = 'post'
		ORDER BY post_date DESC");

  foreach($months as $this_month){ ?>

	<p><?php echo date("F", mktime(0, 0, 0, $this_month->month, 1, $this_month->year)); ?> <?php echo $this_month->year; ?></p>
	<ul>
	<?php for ($i = 0; $i <= count($posts); $i++){?>
	  <?php if(($this_month->year == $posts[$i]->year)&&($this_month->month == $posts[$i]->month)){?>
	  <li><a href="<?php echo get_permalink($posts[$i]->id); ?>"><?php echo $posts[$i]->post_title; ?></a></li>
	  <?php } ?>
	<?php } ?>
	</ul>
  <?php } ?>

It’s showing up properly, however I’d like it to NOT show month names if there are no posts that month, which I can’t seem to figure out.

Any ideas?

Same thing here. I was excited that 2.5+ meant that TinyMCE worked in Safari, but I have to keep reverting to Firefox to post because of the tag issue with Simple-Tags.

Terrific! I didn’t even see that option there now. Solves my problem completely!

My webhost, afer denying a problem twice, FINALLY admitted it was their issue.

I may have to do that. I just noticed a new thing: Sometimes I’ll click something and get a full page of errors, all starting with:

WordPress database error: [Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)]

But at the bottom of the page, I get:

Your database is out-of-date. Please upgrade.

Does this mean there’s a problem with my database? Or is there a problem with the server?

I deleted everything except what was stated in the detailed upgrade instructions, and did everything like it said. I’m baffled. Never had any problems with upgrades.

Only thing I did different with this upgrade was delete wp-content/cache, as per the detailed upgrade instructions on this site. Could that have done it?

Ok so after doing the upgrade again, I can’t even access wp-admin. I get an error screen saying it get access the database connection. I read somewhere that I should try manually changing the database user password? Or does it seem like there’s an error with the database server?

I ran the upgrade a couple times and it said it was fine. I’m going through now and redoing all the files and doing the upgrade again. All plugins are deactivated and I’m uploading files now. I’ll see if that makes any difference.

I’ll also get in touch with my host about the mysql errors.

I’d like to update. I’m getting more database connection errors in both Firefox and IE7. However, it’s very weird how I’m getting them. I can log into wp-admin, go to Write, go to Manage. I clicked on Edit for a post under Manage. The post shows up in the editor, all the categories are there. Under the Save button, there’s a bunch of errors about connecting to the database, same as with the Post Preview section.

Here’s some of the errors (username and partial paths removed for safety):

WordPress database error: [Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)]
SELECT * FROM wp_users WHERE user_login = ‘<user>’

WordPress database error: [Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)]
SELECT * FROM wp_users WHERE user_login = ‘<user>’

Warning: Cannot modify header information – headers already sent by (output started at /<path>/wp-includes/wp-db.php:104) in /<path>/wp-includes/pluggable-functions.php on line 270

I need to get this fixed ASAP.

Thanks,
Matt

mlanger – would you mind sharing where you put the code and all that? I want to do something similar on my site (users are begging for it). Thanks so much!