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.


Obligatory Picture

[The future's so bright, I gotta wear shades]

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.