500 - Internal Server Error for SQL Server Error

Question

I have a new VPS account, whereas before I always ran my sites on a shared server.

I have the option "Enable reliable exception information" and "Enable debug request" enabled.

I get an internal server 500 error. This is not very useful.

And I see the following error in application.log:

Error executing database query. [Macromedia] [SQLServer JDBC Driver] [SQLServer] The column name "AttachmentDesc" is specified more than once in the SET clause.

So, I see the error, but it would be better if the page displayed the error, and not me, to find it in application.log.

Q: Is there another parameter that I am missing to display errors on the page itself?

Answer 1

IIS seems to be hiding errors from you. In the "Error Pages" section in IIS, select error 500 and click "Change Settings" and select "Detailed Errors". You should now see full error information (if debugging is on n CF).

Answer 2

You can enable debugging by going to the ColdFusion administrator and turning on the "Enable reliable exception information" option. In CF10, this option can be found in the Debug and Logging section of the Output Debugging Options section.

Here is the link for CF 8 http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Debug_02.html and for CF 9 http://help.adobe.com/en_US/ColdFusion/9.0/ Admin / WSc3ff6d0ea77859461172e0811cbf3638e6-7fe0.html .

Answer 3

IIS may hide errors from you (see azawaza answer). You can stop this at the ColdFusion level by disabling the ColdFusion administrator → Settings → “Enable HTTP status codes”. Then even pages with an error will give out a code 200 for success, and IIS will not replace the result.

Answer 4

I had a similar problem (error 500 instead of detailed debugging), but also on shared hosting. Customization

<httpErrors errorMode="Detailed" /> 

in web.config did the job.