smackfoo.com | I find your lack of faith disturbing.

If you are a text-link-ads publisher and provide a canvas for the display of fine hypertext wares via the tla wordpress plugin, might I point out a small, but somewhat pivotal part of the process. Within the wp-options table is the row tla_last_update.

This little beasty stores the surprisingly boring yet none-the-less critical-for-functionality last update time — that is, the last time the publisher’s XML feed was fetched and ‘anything’ happened as a result.

Now, in the typical boring world we live in, this little dohicky will quietly update, in the background, every so often. But what might happen if the update time is wrong?

Well, obviously if the date and time was something like 2003-08-13 17:16:18, then obviously a check of the XML feed will happen pretty much as soon as the very next GET occurs for any template that carries the <?php tla_ads() > plugin hook. Because that date falls well outside the ~700 second update cycle, as of now.

“Ahh, but what happens if the date is in the future, yo?” — that’s a damn good question.. and here’s the answer.

Nothing. Nada. Zip. Zilch. Zero.

At least until well after the date rolls around. So if the date is incorrect, or the local server’s time is erroneous, such as 2009-08-13 17:16:18 then there will be no further updates until that date.

That’s a bit of a problem, particularly in this author’s instance, when TLA sent an email, indicating a newly minted sponsor’s listing hadn’t updated, thus they would immediately HOLD my account, for at least 24 hours, assuming the issue is cleared. If not, another 24 hours will roll past.

Thus the above was discovered after carefully inspecting the tla_last_update table and the discovery of the specific row and it’s erroneous content.

So the next question, obviously, is how can I prevent this from happening again? And that’s a little tricky, because how does one ‘know’ when the date is wrong? And how does one then fix the problem?

Well, from a SQL perspective, a way to touch the row and update it, might be expressed thus:

UPDATE `wp_options` SET `option_value` = '2007-08-13 19:05:01' WHERE `option_name` =tla_last_update AND `blog_id` =0 AND CONVERT( `option_name` USING utf8 ) = 'tla_last_update' LIMIT 1 ;

Obviously we want to ‘force’ an update - so setting the date and time to zero should do the job nicely. Creating a whole new db query seems a little overkill — indeed the task has already been done for us. So let’s take advantage of two get and update functions that already exist and simply updates the tla options in table wp_options:

< ?php
    // reset tla options to enforce update
    require("../wp-config.php");
    echo 'Updating TLA table..';  // fetch date
    $current = get_option('tla_last_update');
    echo 'Last update time was: '.$current;   // update date
    update_option('tla_last_update', '0000-00-00 00:00:00');
    $current = get_option('tla_last_update');  // echo results
    echo 'New update time is: '.$current;
    // add any further option updates as needed below
?>

In my case, I have dropped this in a php file, in a .htaccess protected directory, thus restricting the php to internal calls only. Create a weekly (or daily) cron job to access that via wget or some such other contrivance and you are done. Indeed this opens up a number of ‘options’ as far as automated option changes are concerned.

Indeed I have a small handful of db related cleanup jobs run weekly to help improve overall performance as it is, so this slotted right in. Or, you could simply drop the code into a suitable wp-cron accessed file if your web host does not provide cron access.

I’ve already sent feedback to text-link-ads suggesting they build in some date sanity checking to ensure a malformed future date (say > 3 days) is reset. So hopefully this will become redundant - but, well, until then.. I have it covered.

I’ve been using an admin bar plugin for some time now, which sadly hasn’t been particularly friendly under wordpress 2.1.

Thus, I present to you Admin Strip 2, the rejuvenated version of the wildly successful admin bar.

In order to better track changes to the plugin code, I’ve started a google code project - check it out for more details

From the ashes of sig2feed, comes RSS Signature ((.. insert dramatic music, here.)), which should happily function in Wordpress 2.0.x and above (including the shiny new 2.1.0 release).

I would recommend the update, due in part to some code clean-up ((..not to mention the sexy new plugin name ;) )), combined with the options panel moving under ‘Manage’ in the Wordpress admin interface.

The ‘foo has just been upgraded to Wordpress 2.1, with nary an issue in sight ((.. yes, I was going to hold off, but all credit to the WP team - 2.1 upgrade was flawless)). Well done Matt and the team, the upgrade was surprisingly bump free and the new features ((.. such as auto-save)) are very well received.

Granted — Whilst I still cannot bring myself to use the WYSIWYG editor, the rest of the improvements look particularly solid.

An additional upside is that sig2feed appears ((provisionally, at least)) to be quite operational under 2.1, so it should be ready for you on the ‘other side’ of the upgrade — another win for the day!

In the words of Kosh Naranek “..and so it begins”:

“On behalf of the WordPress.org community of commiters, contributers, and volunteers, I’m very proud to announce the immediate availability of WordPress 2.1 ‘Ella’, named for jazz vocalist Ella Fitzgerald.” ~ via Development Blog

There are simply too many “new and improved” features to mention, however I would strongly advise that a quick check of plugin compatibility should be the first order of business, followed by a complete backup of everything^tm before any upgrade is attempted.

A recent addition to my ipod podcast list has been the wordpress podcast, which is a great way to keep tabs on news and events surrounding wordpress development and the community in general.

In the latest episode - Episode 8: Dealing with splogs, posting by e-mail and more a goodly number of plugins are covered, including sig2feed and a little coverage of the joy that is splogging.

After the amazing demand whipped by by
sig2feed, I’m pleased to announce it’s gone beta!
Code named ’snarf’ — sig2feed has had some small sections of code cleaned up, the admin panel is a little less, well, ugly and a new feature has been bedded down.
If you wish to add your custom sig2feed block on a […]

It never ceases to amaze me how much of an impact it can heave have, releasing a
wordpress related
theme or
plugin.
The move to
(mt) Media Temple from
dreamhost has been the single best hosting move bar none. I cannot emphasise strongly enough just the staggering difference of having a rock solid hosting service means […]