The Daily WTF: Curious Perversions in Information Technology

Pretty Basic Validation

by Alex Papadimoulis in CodeSOD on 2009-11-30

"For reasons beyond my comprehension," Kristof writes, "one of my coworkers has managed to keep his job after more than eighteen months of messing about. His latest project was to build an import feature in the admin module of our web application. The idea behind the feature was that the administrators could upload a tab-delimited text file containing a list of products, and the application would insert or update the products in the database."

"Of course, the import feature required some pretty basic validation," Kristof continued. "Is it actually a text file? Is it tab delimited? Are the columns correct? And so on."

174 comments - Last comment @ 2010-12-07

Classic WTF: Smooth, Like a Factory

by Alex Papadimoulis in Feature Articles on 2009-11-27

It's Black Friday! For those of you stuck at work (or not in the US), here's a fun classic. Smooth, Like a Factory was originally published on November 9th, 2006.

Daren S knew that his days were numbered. He was a troublemaker bent on changing The Way Things Were and The Director was hot on his tail. Though Daren worked discreetly, improving his coworkers' productivity a little bit at a time, it only was inevitable that The Director would eventually find out. One does not become The Director by letting such things slide.

70 comments - Last comment @ 2009-12-07

Starring The Admin

by Alex Papadimoulis in CodeSOD on 2009-11-23

We've all been there before. You spend all this time building a kick-ass, ultra-awesome, super-sweet web application and then you realize you need to build some stupid "administration" module that needs to do the boring, run-of-the-mill things like maintain users, groups, privileges, and so on.

There are several different magnitudes of complexity that can be involved with an administration module, ranging from the full-on set of tables including users, groups, roles, tasks, operations, etc., to a simple IsAdmin column on the users table. Actually, it turns out there's an even simpler way, and that Adam P's predecessor discovered and implemented it for their client's fairly large ecommerce website.

136 comments - Last comment @ 2024-06-13

Protocol Droid Processing

by Alex Papadimoulis in Error'd on 2009-11-20

"As much as I detest Novell GroupWise," wrote Ben P, "it is reasuring to that they use the much-loved protocol droid to process commands."

117 comments - Last comment @ 2009-12-13

Introducing Bad Code Offsets

by Alex Papadimoulis in Feature Articles on 2009-11-18

I have never written a bad line of code.

When I tell people that, they often scoff and offer replies like “so you’re not a programmer then?” and “let me guess, you’re a coding deity or something?” Well let me say, I am a programmer and I am not Codethulu, but in the same manner that Al Gore can fly around the world in a private jet without polluting, I have negated my bad code footprint through the purchase of Bad Code Offsets.

119 comments - Last comment @ 2010-08-28

modHmm

by Alex Papadimoulis in CodeSOD on 2009-11-18

"I was put on a new Microsoft Access project recently," Stuart A writes, "and I've slowly been finding my way around the system as the need arises (read: as bugs are reported). As my eyes drifted over the numerous modules, one stopped me in my tracks. It was a module named 'modHmm'. I guessed the programmer was in a ponderous mood?. So naturally, I had a look inside..."

Option Compare Database
Option Explicit

Global t1qq
Global t2qq
Global t3qq
...

87 comments - Last comment @ 2016-12-05

For the Ease of Maintenance

by Alex Papadimoulis in CodeSOD on 2009-11-16

Ryan Thompson works on a project where all database queries had to go through "stored procedures". Now before you call me out on extraneous quotes or wonder, so what's wrong with stored procedures?, I'm not talking about those kind of stored procedures. I'm talking about "stored procedures" — i.e., the technique developed by Ryan's predecessors for the ease of maintenance.

You see, in Ryan's world, there are hundreds of different procedures, each with a unique identifier such as FNACL0023 or ADUSR0012, all which are stored in a database table named "RawQuery", which, for ease of maintenance, contained the actual SQL queries to be performed. In order to call one of these queries, you'd need to call one of several actual stored procedures — Query0(), Query1(), Query2(), Query4(), Query12(), etc. — depending on the number of "parameters" needed by the query.

86 comments - Last comment @ 2013-04-09

Currency Conversion

by Alex Papadimoulis in Error'd on 2009-11-13

"Now I keep thinking," Staszek noted, "if I only had my 5 EUR bill left after my last trip to Slovakia, I could have exchanged it for +Infinity PLN and planned for retirement."

81 comments - Last comment @ 2013-06-11

The Long Week

by Alex Papadimoulis in CodeSOD on 2009-11-11

Turns out that I'm The Real WTF, since the Code SOD from earlier today was already posted... last week. Whoops; consequences of posting realllly late at night in a hotel room while at The Business of Software conference I suppose. Anyway, here's one that I'm pretty sure wasn't from last week.

"We recently started using a new CRM system," Gavin Watkinson writes, "and wanted to write some custom functionality for it."

117 comments - Last comment @ 2009-11-17

Classic WTF: Don't Worry, We'll Fix It!

by Alex Papadimoulis in Feature Articles on 2009-11-10

I'm at the Business of Software conference in San Francisco this week and thought it'd be the perfect opportuntunity to revisit a classic. Don't Worry, We'll Fix It! was originally published on November 28, 2006.

We're in a bit of a jam, an email to the support desk read, we accidentally ran an entire day's worth of transactions for 11 Oct 2009 instead of 11 Oct 2006. Can you fix this?

92 comments - Last comment @ 2010-04-08

Reading Comprehension

by Alex Papadimoulis in CodeSOD on 2009-11-09

"After nearly eight years working as a C++ developer," Rik V writes, "a certain coworker of mine was finally laid off. One of his jobs was to run an application that he wrote which would compare two directories and put any files that had changed into a third. This was a semi-frequent task, and one that he needed to devote quite a bit of time to each month. On his departure, the task fell to me."

"The first time I ran the application, I noticed that it was taking an exorbitant amount of time to complete. After five minutes, it barely scratched the surface of the directories, so I took off for lunch and returned later to see it took over forty minutes to complete. Curious as to how a directory comparison could take so long, I peeked at the code.

121 comments - Last comment @ 2010-07-06

Unexpected Accessory

by Alex Papadimoulis in Error'd on 2009-11-06

"While shopping for dishwashers," Eric Steele writes, "I came across a dishwasher that had a somewhat unexpected accessory."

92 comments - Last comment @ 2009-12-15

Classic WTF: Keepin' It Cool

by Alex Papadimoulis in Feature Articles on 2009-11-05

Keepin' It Cool was originally published on October 4, 2006

A few years ago, Phil was working as a developer on a wire transfer application at a large bank. To make sure that nothing technical would prevent the bank from extracting maximum amounts of money from its operations, every part of their system had a redundancy with fast failovers and clustering. In fact, there was even one server (and a backup of that server) whose only function was to monitor the other server and send notifications if anything fell out of the operations norm.

When a system or process failed, the monitoring server would page the on-call support administrator, who would then log in and restore the errant system to its rightful state. On rare occasions, an actual visit to the server room was required.

123 comments - Last comment @ 2009-11-30

Slightly OverSQL'd

by Alex Papadimoulis in CodeSOD on 2009-11-04

"A certain coworker of mine likes to do everything in SQL," Christoffer Hoel writes, "and I mean everything."

"Of course, since our management is non-technical, there's very little any of us can do aside from just toletarting the code. After all, his code runs about the same as ours... and that's all that matters, right?"

116 comments - Last comment @ 2023-08-08

The Utility Package

by Alex Papadimoulis in CodeSOD on 2009-11-02

"It took months of low quality, late delivered code," Scott C writes, "but a certain coder on our team was finally let go."

"I was the lucky one assigned to clean up some of his old code and noticed that several classes of his made reference to a particular utility package. I opened the package and found a single class with 24 methods filled with sad code."

122 comments - Last comment @ 2013-04-08