Bryan Davis

Thanks for the followup. That’s very disappointing.

It would be great if the auto-update could only include changed files. If that’s too much to hope for, would it be possible to not include /wp-content/ or wp-config-sample.php in the update? Themes like Twenty Ten can be upgraded through the Dashboard anyway. It is also mildly irritating to have to re-delete “Hello Dolly” from the plugins folder every time too!

Like I said, it was only a dozen-or-so sites yesterday but will be about 3 more by the time 3.1.1 comes around, and who-knows-how-many by 3.2!

Not meaning to bitch at you personally, but I see no other way to get a support ticket in the system.

Happy New Year!

I figured as much. Thanks for responding.

MichaelH – Thankyou so much. That’s it exactly. I’m extremely grateful for your help – you’ve saved what remains of my hair and my sanity!!

I’m not having any joy with this so far. After trying your version, I compared your query string to the examples in Displaying Posts Using A Custom Select Query and it seems that I should be using the $wpdb variable to ensure the correct table prefix. I rewrote the query based on the example to:

SELECT wposts.*
FROM $wpdb->posts wposts
INNER JOIN $wpdb->term_relationships ON (wposts.ID = $wpdb->term_relationships.object_id)
INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE 46=46
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->term_taxonomy.term_id IN ('46')
AND wposts.post_type = 'post'
AND (wposts.post_status = 'publish')
GROUP BY wposts.ID
ORDER BY wposts.post_title, wpost.post_date ASC

I’d really appreciate if you could take a look and tell me where I went wrong. The category number in question happens to be ’46’.

Thanks for your help on this.

There is. Currently the post title is in the form:
Artist_name – “CD_title”.

I might also opt to simply make the post title the Artist_name and add the “CD Title” as a custom field.

Thanks Michael. Yes, I’m needing to order based on the ‘author name’ part of the title and put the results in chronological order as well. Sorry to be unclear.

Auto update isn’t working for me either. After clicking “Proceed” it hangs for a while and eventually switches to the following:

Downloading update from https://www.ads-software.com/wordpress-2.8.5.zip.

Unpacking the update.

Verifying the unpacked files

Installing the latest version

Could not copy file: /httpdocs/wp-admin/upgrade-functions.php

Installation Failed

Any ideas?

Also getting a fatal error message using WP2.5RC2 on OS X/Firefox2.0.0.13. Tried updating plugin via auto-update and manually – same result.

Something like this might do the trick:

$cat = get_the_category();
if ($cat->cat_parent = 0) {
$cat_parent = $cat->cat_ID;
} else {
$cat_parent = $cat->cat_parent;
}
echo $cat_parent; // add that into the class/id of your post

Certainly your solution will involve get_thecategory() which you can look up in the Codex

Take the # out of the code for the header.php. In CSS, # is used to reference an ID from (X)HTML.

i.e. #bck-cat-1 = id="bck-cat-1"

Do you have posts in Multiple categories? This may further confuse this method…

Using an FTP client or the File Manager of your web hosting’s Control Panel, upload your plugin file/folder to /wp-content/plugins. Once the file(s) are there they will appear in the Plugins page on your WP-Admin where you can activate them

Looks like you’ve accidentally uploaded your theme’s index.php file to the root of your site, rather than the wp-content/themes directory.

Upload a copy of the index.php from the top-level of the wordpress folder to your site root and see if this does the trick.

This is because the post content isn’t available to get_posts() by default.

See this page in the Codex for the solution.

Are the pages for the sidebar “children” of the current page? If so, you can list them as such. Check out this page in the Codex.

You’re welcome. Please mark this topic as resolved.