(-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
