triffid

I’ve just realised I can do what I need to do through the meta box system.

Nevermind, my theme had somehow been deactivated (but only in the admin panel!?).

Nevermind, I needed to set post_type to page as it defaults to post even if post_parent is set.

Try calling wp_cache_post_change($post_id).

See this support forum thread. It looks like you might need to update the Google Sitemap plugin.

Are you getting an error message? If so what?

Have you recently upgraded to WordPress 2.3? It might be that you have a plugin installed which hasn’t been updated for the new terms tables in 2.3.

So, ‘post-type’ isn’t used in 2.0.10, I should have used ‘post-status=static’.

Well, after staring at the taxonomy schema for half an hour I managed to put together the following query which seems to do what I need.

SELECT DISTINCT YEAR($wpdb->posts.post_date)
FROM $wpdb->posts, $wpdb->terms, $wpdb->term_taxonomy, $wpdb->term_relationships
WHERE $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'post'
AND $wpdb->terms.term_id = 3
AND $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id
AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
AND $wpdb->term_relationships.object_id = $wpdb->posts.ID
ORDER BY $wpdb->posts.post_date DESC

Perhaps someone who knows more about MySQL than me (and that would not be difficult) could tell me if this is a bad idea or not…

I’d guess you (haven’t and) need to change the ‘path/to/wp-blog-header.php’ in Whooami’s example to the actual path to that file in your WordPress installation.

I don’t know much about MySQL, but can you not just add a ‘post_category’ condition to your select?

Its probably too late to help you, but for anyone else trying to do this the following select works. An array of objects is returned from which you need the ‘category_id’ property.

$wpdb->get_results("SELECT * FROM $wpdb->post2cat WHERE post_ID = $post->ID ORDER BY category_ID");

It depends on your template. But, you’ll probably find a similar piece of code in your navigation bar php file (or in ‘header.php’) which you can remove.

Well, you might try (if you haven’t already) copying the ‘searchform.php’ file from the default theme folder to the folder your theme is in.

Well, I’ve just added the following line to the wpautop function for now. If anyone can suggest a better solution that would be really helpful.

$pee = preg_replace('|(<[^p]*>\s?<img[^>]*\s/>)</p>|','$1', $pee);