I am still thinking that the proper place would be the Allaire Beta Forum.
Go to http://beta.allaire.com and log in to report the issue. If you are not
set up then you will need to apply. I presume though that since you have the
beta that you are already a member.
----- Original Message -----
From: "O'Connor-Rose, Joshua" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 2:29 PM
Subject: RE: Bug in CF5 (Using CFQUERY to insert data)
> (-hmm, well that didn't work again)
> forcing plain text now to see if that works.
>
>
> The following was posted on the CF forums about a week ago, this is a real
> bug. Does anybody know how I can tell Macromedia about this:
> It's not urgent, we do have a work around, but I just wanted to post this
> bug somewhere. (Where should we post bugs?)
>
>
> ------------------------------------------------------------------
> First for the searchers out there: Unexpected exception[3]
> (this is the error that comes up in the server log when this error occurs)
>
> I can crash CF5 for sure every time the following conditions exists.
>
> 1. My application uses a datasource for client management. (either by
> default as set up in the administrator or defined by the clientStorage
> attribute of the cfapplication tag). And also has client management turned
> on.
>
> 2. I use cfquery to insert a row into a table where:
> -the datasource is the same datasource that clientStorage is pointing to
> -A value that is not being set in the insert statement does not accept
nulls
> and has no default value set in the database.
> -the database is either MS-SQL7 or MS-SQL2000 and the connection is ODBC
>
> 3. This is the strange one
> CFPARAM is set on the page to certain named values (not all will make it
> crash)
> So far the only names I have tested are "test" and "legalReferers" (both
> will crash CF5) and "subButton" (won't crash cf5) (maybe it's the letter
> 'e'?)
>
> -------------------------------------------------------------------
> Symptoms: (to describe how this bug acts)
> You call a page that has the conditions above set on it:
>
> Instead of getting the expected error:
>
>
> <<
> ODBC Error Code = 23000 (Integrity constraint violation)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value
NULL
> into column 'NoDefault', table 'testCFcrash.dbo.CrashTest'; column does
not
> allow nulls. insert fails. >>
>
> (etc.)
>
> You get something that looks like this:
>
>
> <<
> Error Diagnostic Information
> Error occurred for unknown cause.
>
> Normally the reason for this error is that a critical system resource
(such
> as memory or disk space) has been expended. You should check the available
> disk space on all of your drives to make sure you have not run out. You
> should also make sure that you are not running out of memory by running
the
> Performance Monitor and observing the effect of your application on free
> system memory.
>
> Another reason for this error may be that your ODBC driver is generating a
> general protection fault. To help verify that your driver is funtioning
> properly you should attempt to submit the query which is causing this
error
> to the data source using another ODBC application (such as MS Access or MS
> Query).
> >>
>
>
>
> Eventually if this page is called repeatedly or similar inserts are
> attempted repeatedly. Other messages may show up:
>
>
>
> <<
> Request canceled or ignored by serverServer busy or unable to fulfill
> request. The server is unable to fulfill your request due to extremely
high
> traffic or an unexpected internal error. Please attempt your request again
> (if you are repeatedly unsuccessful you should notify the site
> administrator). (Location Code: 26)
> >>
>
>
>
> or similar server unavailable messages will happen. Sometimes while I was
> testing CF would recover all on it's own (actually most times) by
restarting
> the service itself. There were other times when we had to start the server
> ourselves (but that may have been a test of patience) In either case it
> really shouldn't have gotten that far.
> -------------------------------------------------------end of symptoms
>
> I've attached a zipped version of my test page (cfapplication included in
> the page for testing.) ---this is on the allaire forums site---
> --------------------------------------------------------------------------
--
> ---------
>
> Oh and be careful when you are updating your site and removing variables
no
> longer needed that still exist in the database.
>
>
>
> Could some one follow this up with where we should post bugs.
>
> Joshua O'Connor-Rose
> Cognitive Arts
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
