RSS Feeds

Oh, the embarrassment!

I’ve just discovered a bug in my blog: any comment posts get thrown into the bit-bucket and are never passed to me for acceptance / publishing if the user making the comment is a guest (that is not a blog author) and accessing the public instance on my blog.ellisons.org.uk domain rather than my private and locally installed development system. 

I can only plea in mitigation is that this combination made it easier to miss this bug in my module and integration tests.  I did a quick check on my access logs (I've got the last 18 months archived), and I've work out how many comment posts were made in this period – roughly 4 a week.  If I ignore the 21 spammer probes that were 404'ed, there were a total of 295 reader comments.  The comments themselves are gone forever, but appended an article league table for comments, with a cut at 5 comments.  My sincere apologies to all these blog readers, and I really regret losing this valuable feedback.

There were a couple of factors that helped my missing this.  The first is that I decided to do a complete reimplementation of the blog engine based on some of the conclusions that I've come to in these articles on PHP performance, and I've been working on that on my development system.  The second is that I had some heavy commitments in apache.org that took most of my spare time for a couple of months. Both of these will be the subject of future articles.  However, I first needed to fix this bug before I could publish this article from my test system to live – otherwise I would have whithered with shame!

A postscript one month on

I continued to track the Apache logs and saw regular POSTs to articles but none were arriving on my administration queue for approval, so I added small diagnostic to dump any POSTs to the article page to a debug file.  Yup lots of posts but all spam, which my "simple sum" validation was defeating.  Nobody loves me after all :-(


League table of lost comments

Article

No of posts

VBA vs OOo Basic Performance II

46

A PHP Cache Overview and Cache Tuning

27

Building a VMware Appliance Playpen

17

My blog’s templating engine

16

phpBB Performance – Reducing the data cache overhead

16

Migrating the OpenOffice.Org forums to a common code-base

11

phpBB Performance – Reducing the script load overhead

11

VBA vs OOo Basic Performance

11

Using .htaccess files on a Webfusion shared service

10

Access and Permissions on a Webfusion shared service

9

Error Handling in VBScript - Part I

8

Use cases for phpBB

8

An example of how to use VBA/COM over Outlook

7

So why CSS Sprites?

7

Differences in Error Handling between VBA and OOo Basic

6

Performance in a Webfusion shared service and guidelines for optimising PHP applications

6

More on optimising PHP applications in a Webfusion shared service

6

A miserable case of ME/CFS – three years on

5

Putting it all together: my blog engine architecture

5


Post a comment

Please note that your name is required and that all posts will not be visible until authorised by an administrator.

  Required
  A valid mail address must be supplied
A cookie will store your name/url for three months
 Sorry, but you must answer this easy sum as a SPAM prevention measure.
 
 

You should be aware that all information on blog site is © Terry Ellison 2010 and made open access under the Creative Commons Artistic Licence.

Your comments will only publicly available after you have carried out email confirmation. Your email address will only used for this purpose and is not made public.

Comments that are not confirmed will be automatically deleted after 7 days.

The blog author reserves the right to delete comments which breach copyright or the rules of site etiquette as he determines (such as unnecessary use of obscenity or spam content).