[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: "Cannot prepare error statement" error
- Subject: Re: "Cannot prepare error statement" error
- From: "David A. Bandel" <..hidden..>
- Date: Thu, 16 Oct 2008 11:36:12 -0500
On Thu, Oct 16, 2008 at 11:24 AM, Chris Travers <..hidden..> wrote:
> On Thu, Oct 16, 2008 at 9:19 AM, David A. Bandel <..hidden..> wrote:
>
>> I've seen this with a client. They _insist_ on double-clicking on everything.
>
> Ok. A couple of other questions occur to me.
>
> 1) Are either of these installations running mod_perl?
No.
>
> 2) Are either of these installations running apache with an MPM other
> than prefork? IIS? Any other multi-threaded web server?
No. Apache 1.3 plain vanilla install with -ssl.
>
> Currently we support the latter but not the former (the scripts must
> be run via CGI), but if this is a concurrency problem, this would
> suggest a shared process space.
Chris, I didn't submit this as a bug because I don't consider it a
bug. This is PEBCAK, plain and simple. It is 100% reproducible if
you quickly click twice or more on a link that executes a SQL query.
I discovered this when a client told me they got this error a lot, but
I couldn't reproduce it. Drove out, and when I saw their finger
bounce twice on the mouse button I realized what was happening. After
that I could reproduce it anywhere, anytime just by doing the same
thing (as long as the link executed a SQL query).
I fixed the problem with a hammer (threatened to use it on their
fingers if they clicked more than once).
Ciao,
David A. Bandel
--
Focus on the dream, not the competition.
- Nemesis Air Racing Team motto