Mar 30 2008

WordPress 2.5 Early Reactions – Sticky Post + WordPress Automatic Upgrade Plugins

Category: Personal,WordPressChrisM @ 3:49 pm

[UPDATE AT END OF POST]

OK, I have upgraded my test blog site to WordPress 2.5, to see if any problems occur with my current plugins etc., before committing myself to upgrading my 19 other blogs.
It would appear that a couple of things may be of interest to others…

1) Using the WordPress Automatic Upgrade plugin, the process bombed out at the ‘cleanup stage’. To clarify, the upgrade proceeded as normal, but the procedure halted when the process attempted to delete its temporary files. I was able to continue (WordPress had me login in again), click on the Manage link, go to Automatic Upgrade, and finish off the process successfully (AFAI can tell). Go here for the general plugin page, and here for the latest update info.

2) The Sticky Post plugin (previously found at http://blog.vishalon.net/Post/88.aspx, though that page is now removed or perhaps the permalink structure over there changed?), that enables you to keep a specific post on the front page for as long as you want, without constantly fiddling the time stamp, appears to be temporarily broken by WordPress 2.5 . I suspect this was due to code changes within WordPress that deal with handling which posts should be displayed. If you have the plug in installed, upgrade to WordPress 2.5, and find that none of your posts appear, along with an error of WordPress database error: [Table 'wp_posts' from one of the SELECTs cannot be used in global ORDER clause]
( SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 2 AS N FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') ) UNION ALL ( SELECT wp_posts.*, 1 AS N FROM wp_posts INNER JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type = 'post' AND wp_postmeta.meta_key = 'STICKY' AND wp_postmeta.meta_value = '1' ORDER BY wp_posts.post_date_gmt DESC LIMIT 1) ORDER BY N, wp_posts.post_date DESC LIMIT 0,10
at the top of your page, login as normal, and deactivate the Sticky Post plugin.

I still want to carry out further testing before upgrading my other blogs, but I’m reasonably happy, so far at least.

For further info on the final release of WordPress 2.5, see here, here, here, here, here, here and here.

[UPDATE]
See this post for further details on plugin compatibility testing with WordPress 2.5

Tags: , , , , , , ,

6 Responses to “WordPress 2.5 Early Reactions – Sticky Post + WordPress Automatic Upgrade Plugins”

  1. Testing… 123 » Blog Archive » Wordpress 2.5 Installed says:

    […] have just finished upgrading this blog to WP 2.5, see this post on my main blog for further details. Basically, all went well, though I’ve had to […]

  2. Brad Hart says:

    I am running my WP 2.5 tests. I am not sure which Sticky plugin you use, but I use adhesive and it is broken too. If you let me know which you use, i will add it to the list of broken plugins on my blog.

  3. ChrisM says:

    The one linked to in my post, lol
    http://blog.vishalon.net/Post/88.aspx – Sticky Post 🙂

    Good job on compiling a list. I’ll be making another post in a couple of days, once I’ve installed all the plugins I use on different blogs, and try installing them on the sacrifical lamb that is http://test.chrismerriman.com 🙂 Then if things progress smoothly I’ll probably upgrade them all.
    Then scream and tear my hair out and wish I’d waited…

  4. WordPress Wednesday News: WordPress 2.5, Security Issues, Plugins Updated, WordPress vs WordPressMU, and More : The Blog Herald says:

    […] WordPress 2.5 Early Reactions – Sticky Post + WordPress Automatic Upgrade Plugins […]

  5. surya-lab says:

    thanks, its very help me..
    😉

  6. ChrisM says:

    You’re very welcome, check out the other WordPress related posts if you get a chance.