Tuesday, Debtember 18, 2007
I still contend it's the bloody PHP programmers …
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.
“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 …
