As near as I can tell, this is an issue with CF Server v5, not with Studio.
CF Server is not a beta product (supposedly :)
----- Original Message -----
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 1:45 PM
Subject: Re: Bug in CF5 (Using CFQUERY to insert data)
> 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
