The Boston Diaries

The ongoing saga of a programmer who doesn't live in Boston, nor does he even like Boston, but yet named his weblog/journal “The Boston Diaries.”

Go figure.

Tuesday, Debtember 18, 2007

I still contend it's the bloody PHP programmers …


Sad that the easiest way to fix The Error From Hell was to use a search-and-replace function to “fix” the SQL query.


$sql = preg_replace("/\s+\'\s+\'\s+([a-z]+)/"," ' ' AS \\1",$sql);

It's not perfect. It'll break if there's an SQL statement with a lowercase AS. But it'll have to do for now until I find a better regular expression.

To top it all off, I received the following from someone who has worked on porting SugarCRM to PostgreSQL:

The SugarFolk, I think due to rather obtuse source management and procedural policies, aren't interested in folding in my many improvements and PostgreSQL support. I moved on to other employment having nothing at all to do with SugarCRM or PHP (and very little to do with PostgreSQL), so I haven't worked on it. So it's officially dormant.


“Ah, I see you have the machine that goes ‘ping!’”

“No, it was really stupid.” Erik sighed. “I just had the idea that a CD ROM drive in an old system could eject and hit the reset button. It was a ridiculous idea.”

“Wait,” Laura began, “could you really do that?”

It was another uncomfortable moment for Erik, but she seemed serious, so he just went for it. “Uh, yeah, I could, but it's hardly the best solution … I mean, I'd have to position the servers just right, somehow get the heights and alignment correct, and update the polling script to eject the CD ROM drive any time it didn't respond to ping.”

And that was exactly what Erik found himself spending the rest of the afternoon setting up.


Yeah, I can relate

Obligatory Picture

[“I am NOT a number, I am … a Q-CODE!”]

Obligatory Contact Info

Obligatory Feeds

Obligatory Links

Obligatory Miscellaneous

You have my permission to link freely to any entry here. Go ahead, I won't bite. I promise.

The dates are the permanent links to that day's entries (or entry, if there is only one entry). The titles are the permanent links to that entry only. The format for the links are simple: Start with the base link for this site:, then add the date you are interested in, say 2000/08/01, so that would make the final URL:

You can also specify the entire month by leaving off the day portion. You can even select an arbitrary portion of time.

You may also note subtle shading of the links and that's intentional: the “closer” the link is (relative to the page) the “brighter” it appears. It's an experiment in using color shading to denote the distance a link is from here. If you don't notice it, don't worry; it's not all that important.

It is assumed that every brand name, slogan, corporate name, symbol, design element, et cetera mentioned in these pages is a protected and/or trademarked entity, the sole property of its owner(s), and acknowledgement of this status is implied.

Copyright © 1999-2024 by Sean Conner. All Rights Reserved.