strottrot

The same thing happened to our client’s site.
When we updated to 2.7.7 on our staging site, we did not get the button to ‘Upgrade’ database. On production, we did.

I, too, am trying to order posts on a category page based on a custom field.
What I would like is:
Get all posts for the category. If the custom field with a key of phs-post-order is assigned, order first by that key’s value, then by date.
(The only custom field I have is ‘phs-post-order’)

However, when I remove the where statement restricting the query to only posts with
AND $wpdb->postmeta.meta_key = ‘phs-post-order’
then I get redundant listings of posts in the page.

I’d appreciate any help on the SQL.
This is what I’m using:

$querystr = “
SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE $wpdb->term_taxonomy.term_id = 8
AND $wpdb->term_taxonomy.taxonomy = ‘category’
AND $wpdb->posts.post_status = ‘publish’
AND $wpdb->postmeta.meta_key = ‘phs-post-order’
ORDER BY ABS(0 + $wpdb->postmeta.meta_value) ASC
“;

Thanks!