I'm stuck on a thorny problem, and I am offering fifty dollars to the first
person who can diagnose and fix it. The ColdFusion code and an Access
database can be downloaded from
http://autoparts.strategicbrains.com/autoparts.zip .
The application is an admin interface for an autoparts database. The
problem is intermittent; once in a while the code seems to run okay
(although very slowly) but most often it causes arcane ColdFusion errors
that don't contain very useful debug information (see below). The problem
is not due to a bad install of ColdFusion because I have tried it on three
different machines and the symptoms are the same on all. It does not seem
to be related to Access or its ODBC driver because the problem remains
unchanged if I import the database into SQL Server (ProductDetail.PD_ID may
need to manually be made an Identity field in SQL Server if you try that).
CF errors USUALLY occur when an existing record is updated but can then
more easily happen on any of the other templates once errors begin. The
most-offending template seems to be partupdate2.cfm, which is called from
partedit.cfm. ColdFusion returns errors like these:
-------------------------
Error Occurred While Processing Request
Error Diagnostic Information
unknown exception condition
CFMLInterpreterImp::writeEmergencyMessage
Date/Time: 05/06/01 16:19:10
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; BCD2000)
Remote Address: 64.135.30.238
-------------------------
Or, more commonly:
-------------------------
Error Occurred While Processing Request
Error Diagnostic Information
Just in time compilation error unknown parser error
The last successfully parsed CFML construct was dynamic text (a CFML
expression) occupying document position (17:22) to (17:37).
-------------------------
I figure there has to be some genius out there who likes an intellectual
challenge that will be able to solve this problem. Please note that the
application is not complete so the code is still a little makeshift, and
there is a fair amount of commented-out debug code. Fifty bucks is yours
if you diagnose and fix the underlying problem causing these errors, it is
not necessary to make the whole application work as it should ultimately.
Suggestion: start with index.cfm and click on the first Search button to
get a list of all the parts in the database on partsearchoutput.cfm. Then
click on any of the Edit graphical icons to load partedit.cfm. When you
click on either of the Save buttons, you should experience the problems I
have, maybe not the first time but after just a couple of iterations.
To win, just send me working code or even an explanation of your fix if
that will suffice. May the best coder win an easy fifty bucks!
Regards,
Karl Simanonok
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
