Sad.
Sad that the easiest way to fix The
Error From Hell was to use a
search-and-replace function to “fix” the SQL query.
Sigh.
$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.
Sigh.
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: https://boston.conman.org/, then add the date you are
interested in, say 2000/08/01,
so that would make the final URL:
https://boston.conman.org/2000/08/01
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.
