WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (243, 242, 241, 239, 240, 237, 236, 228, 227, 226) ORDER BY t.name ASC

wordlog.com » 2007 » May

A weblog authored by Carthik about the latest in the WordPress world.

Wednesday, May 23, 2007

Plugin to Restore Preview Post in Write Post Form

Filed under: Uncategorized — Carthik @ 6:05 pm

There are at least two people in the world who definitely will appreciate the plugins I mention in this post, and that, I think is reason enough to write here. Prior to WordPress 2.1 here was a neat little “Preview” link to the Top Right of the Write Post form. Clicking on that took you straight to the bottom of the Write Post page where you could preview the post as it would appear on the site in an IFrame. 2.1 took that away from us, annoying many. So someone filed a bug, which is now marked as Fixed. The Fix in 2.2 has been to include a link in the same place as before, but which opens the post in a new window/tab. If that does not fix it for you, here’s a plugin that surely will. This adds back the IFrame.

Read about and download the Preview Frame plugin.

I apologize for not being able to try it before mentioning it, but please do let me know how well it works for you, if you choose to use it.

Update: You may need the Preview Post Navigation plugin to add the “Preview” link on top. This will work for WordPress 2.1.3. For 2.2 you will have to edit the Preview Frame plugin to add a line “<a name=”preview-post”/>” just above the IFRAME line in the plugin source to make the “Preview” link work. I would have made the change and re-released the plugin, but the original plugin does not specify the license it is released under, so I desist.

Thursday, May 17, 2007

WordPress 2.2 “Getz” Security Upgrade

Filed under: Uncategorized — Carthik @ 6:13 pm

I had written in the post describing 2.2’s arrival that there was no mention, and it wasn’t clear from the WordPress bug tracker whether 2.2 included any security updates.

The recently married Mark has left us a comment saying WordPress 2.2 Getz includes some security fixes. As with all upgrades that include security fixes, you are encouraged to upgrade to this release as soon as you can. You don’t want any holes, big or small in your WordPress blog. The reason I upgraded WordLog and resumed posting is because someone used a hole in the old, un-upgraded version to upload copies of movies, including Hannibal Returns to my VPS. Yes, it can get that ugly! So upgrade now.

Wednesday, May 16, 2007

Go Get Getz – WordPress 2.2 Arrives

Filed under: Uncategorized — Carthik @ 2:09 am

WordPress 2.2 codenamed “Getz” has been released. Read the official announcement for details.

This is all part of the new experiment to release often, and release regularly. Finally Matt’s 2005 resolution seems to be kicking in :)

Widgets in the core, that annoying bug where marking comments as spam in the admin page causes the number of displayed comments to keep decreasing has been fixed, and loads of cookies for developers, and lots of bugs including some “Highest OMG BBQ” bugs fixed.

What’s unclear is if this is just a feature-upgrade release or if it includes any security fixes? Do we all have to upgrade to be secure? It would be nice if a small note were added regarding security in the official release blog posts.

Monday, May 14, 2007

Supplemental Results and WordPress

Filed under: Uncategorized — Carthik @ 7:46 am

I happened upon a curious trick to find out all your pages listed as “supplemental results” in google, and some other associated supplemental result tricks. A lot of you might already know these tricks, but I think reading the rest of this article might get you thinking about these supplemental results in a new way. I spent a good part of 1.5 hours playing with this stuff and reading up on it, which I try to summarize here.

To start off, let us look at the tricks.

Finding all supplemental results for your blog

The trick is to do a search for the string “site:wordlog.com *** -spght” in google. That gives you all the pages on your wordpress blog listed as supplemental results. The search result that google returns will have a “Supplemental Result” in the text that follows the url and the short excerpt, and as you can see, all the results for the string I refer to above have that after the results. The spghy can be changed to some other random characters – it doesn’t matter.

Finding all results that are not supplemental results

The following query will show all results that are not supplemental results:
site:wordlog.com -allinurl:wordlog.com“.

So, for wordlog.com, there are 227 non-supplemental results and 196 supplemental results. However, a search for “site:wordlog.com” returns 325 results, and 196+227 = 423. So I think some of the results returned for “site:wordlog.com” are supplemental results. At the time this article was written, page 25 of the results has two supplemental results right at the top.

What are Supplemental Results?

According to Google,

A supplemental result is just like a regular web result, except that it’s pulled from our supplemental index.

and, additionally, Google maintains that

…the index in which a site is included is completely automated; there’s no way to select or change the index in which a site appears. Please also be assured that the index in which a site is included doesn’t affect its PageRank.

So we know that there is no way to formally request supplemental index pages to be moved to the main results pages. However, one thing bothers me, sort of.

Most of the non-supplemental results for wordlog.com are the archive and category pages. I believe the individual posts should be there in stead. I have noticed, many times, that when I search for a term, I am most often led to the category or date-based archives of a blog, and then I have to manually search for the term again in Firefox, and then, since many themes display only excerpts in these pages, i have to click the article to read it to get the information I need. This is annoying, to say the least.

Fixing the supplemental results problems

There is a duplicate content cure plugin for wordpress that promises to reduce the duplicate content indexed by google by way of your archive and category pages. It does so by adding directives to google to not index archive and category pages by means of meta tags in the page headers. One would think this would cure the supplemental results problem too, and make all your blog posts preferred over the archive pages.

As a small experiment to test this theory that the duplicate content cure plugin will help alleviate the supplemental index problem, I did searches for supplemental and non-supplemental results for seologs.com, the site that published the plugin. Amazingly, seologs has 385 supplemental results and 243 non-supplemental results! So now it appears that the plugin is not the silver bullet for the problem. However, as promised by the plugin, the archive pages are missing from the pages indexed by google. Is this a good thing, though? If the number of indexed, non-supplemental pages are the metric, then it is not. Without the plugin, all of wordlog’s archives are indexed and probably will be returned as search results for some terms. The duplicate content cure plugin prevents some pages from being indexed, totally – it would be nice if it did not do that, really. It is better to have visitors find useful content via your archives if not via a direct link to the relevant article.

Ideally, I would love for the archives pages to be indexed too, with the blog posts being indexed in the main index. Heck, I would love to have all the pages in the supplemental index to be in the main index instead. There are lots of suggested tricks to avoid the supplemental index. The issue with archive pages in wordpress blogs being indexed more prominently is because all WordPress blogs have relative links to the archives pages that look like the following if you look into the source of the page:

"<link rel='archives' title='May 2007' href='http://wordlog.com/archives/2007/05/' />"

In addition to this, you also have links to the archives from the sidebar, which is probably displayed on all pages of your site. The indexing robots should think these pages are really important, since you seem to link to them from every page on your site.

So, a simple way to fix the problem, or at least try to get some pages in the main index might be to have a sitemap containing each and every post on every page in your blog. That would make the pages huge! An alternative would be to have an html sitemap and link to it from the the sidebar or footer. You could also link to posts you think are important from the sidebar. The important things to remember are that:
1) It’s better to have a page in the main index than the supplemental index.
2) It’s better to have a page in the supplemental index than to not have the page indexed at all!

I have a couple of ideas floating around in my brain that I will implement to accomplish item #1 above without violating item #2. I will try them out and let you know if the results are worth mentioning. Do you have any ideas that have worked, that can be verified in a straightforward manner? Blame it on what I do for a living, but I have come to trust verifiable results over speculation and hypothesis.

Sunday, May 13, 2007

Displaying HTML Source Code in Your Blog Posts

Filed under: Uncategorized — Carthik @ 2:16 pm

I badly wanted to display the following html code in a blog post that I am drafting:
“<link rel=’archives’ title=’May 2007′ href=’http://wordlog.com/archives/2007/05/’ />”

I tried putting the raw line of html between “code” tags and then even “pre” tags, but it just wouldn’t show up. Turns out you need to encode the html entities, like the “<” by replacing them with their html code equivalents – & lt ; is the equivalent for the left angle bracket.

There is a cute little encoder tool at wordpress.org written by The matt – however it seems to not want to work anymore. So I found a replacement Encode/Decode HTML entities tool at centricle.com. It works, as evidenced by the code displayed in this blog entry.

Friday, May 11, 2007

Can’t Find My Glasses (…but they are on your nose)

Filed under: Uncategorized — Carthik @ 1:34 am

I sure can’t be the first to notice this.

If you go to a feed url, say http://wordlog.com/feed/ and then click on the Google Reader Subscribe Bookmraklet, the poor thing can’t find the feed!
Oops - Can’t Find the Feed.

What do you mean you can’t find it? You’re at it!

I am talking about the authentic Google “Subscribe as you surf” bookmarklet which is available in the “Goodies” store at your reader settings page. Things closest to the eye are the easiest to overlook – even for a team of very competent engineers and developers.

Oh, and by the way, when you visit my feed, feel free to subscribe to it.

Wednesday, May 09, 2007

Download WordPress and Favorite Plugins in One Fell Swoop

Filed under: Uncategorized — Carthik @ 11:38 pm

WPZipper is one of those websites which I have thought of doing myself but never really got around to… Alright, well there is very little we all haven’t thought of and gone, “that would be so nifty!”.

What WPZipper does is pull your blog’s zipper to close shut.

Take 2: It is a service that provides a method for you to download one zip file with wordpress and all of your favorite plugins – plugins which you can select from a list. wpstar made it. I can think of a few small reasons I wouldn’t use it, based on the fact that unless you download it from wordpress.org, you can’t be sure it is the untainted, true, product, and that I might go over with the plugins I get. I manage my plugins, maintaining them at the bare minimum, and even for plugin-intensive blogs, it generally takes weeks to find the plugins I need and add them. But all this shouldn’t stop you from appreciating the effort behind the WPZipper service.

Did you know wordlog.com is using only the Akismet plugin at the moment? Now that’s what I mean by “bare minimum”. :)

Addendum: I must say I am also using the Automattic stats plugin now – so that makes it two plugins. D’oh.

Sunday, May 06, 2007

Get WordPress.com Stats for Your Self-Hosted Blog

Filed under: Uncategorized — Carthik @ 6:39 pm

A blog statistics plugin has been announced at wordpress.com that allows you to have wordpress.com style stats on your own, self-hosted WordPress blog. Before we go any further, he’s a glance at the simple, efficient stats that await you:
Blog Stats - Flash

The Automattic stats plugin available at wordpress.org is real easy to install. You download it, upload the stats.php file to your “plugins” directory on your WordPress blog, and activate it. The plugin will then tell you that you need an API key for it to function. If you have an API key for akismet on your blog, you can use the same key for the automattic stats plugin. If you don’t have an API key, you can get one here. You just sign up as a user at wordpress.com and when you activate the account you get an email with the API key.

Once the plugin is installed, you get an extra tab on your blog’s Dashboard, and a half hour later, you can see the wonderful stats, the same way you see it on WordPress.com blogs. Besides the graph showing the number of visitors for the past month, there is also details regarding referrers, popular posts, popular exit links and incoming links – that’s about all the stats I care to know about my blog. Here’s the full screen of stats, for the Ubuntu Blog:
WordPress.com Stats Plugin Screenie

Now here’s the irony in all this: The day after I rekindled this blog, I decided that the first time-intensive article I will do would be one comparing different free blog/website statistics tools available out there. So I installed OneStat Free, Statisfy, Add Free Stats, HitTail, 103 bees, Extreme Stats, GoStats, ActiveMeter, StatCounter, Google Analytics, and Reinvigorate. I thought I’d let them run for a month or so and then compare them, all for your benefit. I left out mint, which seems to be popular among bloggers since I don’t have an expendable $30 to plunk down for fancy stats. I also left out sitemeter since they seem to add 3rd party tracking cookies that may violate browsers’ privacy.

I might as well go ahead and do it – in spite of the wordpress.com automattic stats plugin being available – I think there will be some merit in comparing these alternatives. I want to decide which stat tools to use and stick with them. Now I can compare these, and the wordpress.com stats, and find the best.

Saturday, May 05, 2007

Congratulations Mark!

Filed under: Uncategorized — Carthik @ 8:20 am

Please join me in wishing Mark and Sarah a happy married life. Mark has been a strong pillar of the WordPress community, with his Covered Web Services being the least of the ways he’s involved in the WordPress world.

Here’s wishing them joy and happiness, and a happy married life.

Wednesday, May 02, 2007

Back in Action…

Filed under: Uncategorized — Carthik @ 1:56 pm

First off – sorry for the really, really old posts from this blog that are

all over the WordPress Planet. I (finally) upgraded this blog to the latest and greatest WordPress from version 1.5.x-beta. Yeah, you heard me right.

So here’s a quick recap for all interested. I am carthik, and I used to very active in the WordPress world until somehwere around January 2006, first as a support forum volunteer, back when Matt was “allusion” and Mark was “Podz”, and the other Mark was single :) , then as a documentor and then a little bit of development, which never really took off.

I am grad student, and at any point in the past two years, I swear I haven’t been more than 6 months from graduating :) Unfortunately I have had to stick around in school for a little longer than I expected. I did not like that one bit, and so I came up with a plan to graduate – reduce all other activities drastically. That has, variously, made me unhappy, frustrated, bored and cut-off so I gave up on that.

Yesterday I passed a significant landmark – completed a major portion of work, and I had promised myself that as soon as I get that done, I will try and make an effort to at least upgrade my blogs and think about their future. So here I am.

The last post on this blog was made in September 2005. Yup, almost two years ago – so many of you who read this might not know about this blog, or me. This was the first WordPress-powered blog about WordPress. There are so many of these around now that keeping track of them all is difficult. Some pander to professional bloggers (back in 2005 there were no professional bloggers), some to theme hunters, some deliver WP-related news and gossip etc. I have read all of them, and have enjoyed reading some of them. I now have to figure out what WordLog can do in the coming future. The audience I used to address has upped and left – or perhaps not. If everything goes according to plan, I will post here infrequently, maybe once or twice a week, with stuff that deserves attention. That equation has worked out quite well in the past at the other Ubuntu blog I write.

Lots of things have changed around WordPress – in fact I wanted the first new post here to be a summary of the changes around the WordPress family – but then I had to write this one now to explain the sudden planet-flooding. So see you around the planet, but no so much as some of the other regulars! If you are an old WP-friend, or someone who remembers me, drop by and say hi!


Powered by WordPress

eXTReMe Tracker