May 28 2010

Broken 70k Barrier!

Category: PersonalChrisM @ 7:48 pm

The Alexa rank for this site is currently sitting at 66,752, which you can check out here. If you click around the various areas of information, you can see which countries this site is more popular in, as well as the country-specific rankings there. A fairly recent addition to Alexa’s site are the search queries and other SEO related information. If you were to compare sticky post to spitoons or Megaline Kazakhstan, you can tell which subjects visitors to this site (those that come from search engines, as opposed to regular visitors, at least) are most interested in. Some of them I can understand why they end up at, however tmzflights seems to be some sort of blip in the statistics. I’ve not written, or linked to them, as far I can remember, and I’ve seen the same alleged popular search terms in Alexa’s reports for other sites. Does anyone have information on how the term is appearing?

Tags: , , , , , , , , , , , ,

Mar 30 2008

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

Category: Personal,WordPressChrisM @ 3:49 pm


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, 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.

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

Tags: , , , , , , ,