Matt Banks
Forum Replies Created
-
Forum: Plugins
In reply to: List Posts with Certain Tag by Month/YearThanks 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?
Forum: Plugins
In reply to: List Posts with Certain Tag by Month/YearOk, 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?
Forum: Plugins
In reply to: [Plugin: Simple Tags] Keyboard Navigation of Tag Suggestions in SafariSame 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.
Forum: Fixing WordPress
In reply to: v2.1 Write Post with Firefox SpellCheckTerrific! I didn’t even see that option there now. Solves my problem completely!
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingMy webhost, afer denying a problem twice, FINALLY admitted it was their issue.
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingI 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?
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingI 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.
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingOnly 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?
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingOk 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?
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingI 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.
Forum: Fixing WordPress
In reply to: WP 2.0.6 Errors after UpgradingI’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,
MattForum: Plugins
In reply to: Author Image Plugin?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!