Showing error information?

[Guest]

I have a problem finding the cause of an error, the hosting company has disabled cfdump & the 'robust error reporting' so that when I get this error:

The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.

Null Pointers are another name for undefined values.

I have no idea where or why it is happening [actually I do know it seems to be session related]

is there any other troubleshooting method or tag or something I can use to show the extended error information? [i.e. the session/application/form/cgi values etc]

-thanks

-sean

[ilssac]

Without Robust and <cfdump...> you have two choices off the top of my head.

ONE

Ask the hosting company for the relevant log entries for the ColdFusion Application and|or Exception log files.  Depending on how good or bad a hosting company they are, they should be able to provide this for you.  But one that disables <cfdump....> about as innocuous of tag as it is useful is rather disturbing.

TWO role you own <cfdump...> anlog.

It is not that hard with the <cfloop....> tag.

Between

<cfloop collection="#structVar#" item="key">

<cfoutput>#structVar[key]#</cfoutput>

</cfloop>

AND

<cfloop array="#arrayVar#" index="ind">

<cfoutput>#arrayVar[ind]#</cfoutput>

<cfloop>

You should be able to output any variable you care to with some work.  You could either put a <cftry><cfcatch> block around suspected code and use the above output techniques on the #cfcatch# structure.  OR put a onError() Method in an Applicaiton.cfc file and output the argument structure it provides when it handles expceptions.

OR

You may want to find a hosting provider that understands ColdFusion and allows one to work properly with it.

[Upen1]

@ilssac

Hi ..

I am getting the same error during the simple querying data base.It was not showing the error when I was running the application in my local environment.

But when I deployed it at client site it shows the following error

"The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.Null Pointers are another name for undefined values."

By the way I have used the every DB call inside the function and when this error is occuring I am getting the cfcatch.message as null string but for other types of error it is getting the error string as the cfcatch.message value.So I checked the condition inside the catch block and making again function call to the same function when the condition is satisfied.

My code from where I was getting error is:

<cfquery name="qry_testDB" datasource="testDSN">
SELECT * FROM myTables WHERE pkID = 1;
</cfquery>
<cfdump var="#qry_testDB#">

So if you have any other better solution please suggest me .

NOTE: I am using My Sql 5.0 data base.

[Guest]

using cf9?

I got around this by disabling "                                                         Maintain connections across client requests." in the datasource setup....  apparently it's a well known-little-documented bug.... I had the same issue, worked here - didn't work there....

-sean

[Upen1]

Yes, in my developing environment I was using CF9 also I have tested it using CF8 and it was running without any error .But the hosting site provides us CF8 and in that environment it is showing error.Can you please write the steps which you have followed to solve this issue.The hosting site does not provides us the coldfusion admin interface to control all the things.There is a control panel of hosting site from there we can make request for DSN creation or mapping anything.

[Guest]

the host, had to disable the maintain connection settings, - support from them, I didn;t have access to the cfadmin either. [try that]

[mack_]

You can also copy the dump.cfm file from a local instalation of

ColdFusion to the remote server (search for dump.cfm in your CF

directory, it should be in a directory called cftags).

--

Mack