500-SQL Server错误的内部服务器错误 [英] 500 - Internal server error for SQL Server error

问题描述

我有一个新的VPS帐户，而在我一直在共享服务器上运行我的网站之前。

I have a new VPS account, whereas before I've always been running my sites on a shared server.

我已选中启用可靠的异常信息，并选中启用请求调试输出。

I have "Enable Robust Exception Information" checked, and "Enable Request Debugging Output" checked.

我遇到500-内部服务器错误，不是很有帮助。

I'm getting a 500 - Internal server error, which isn't very helpful.

我可以在application.log中看到以下错误：

And I can see in the application.log the following error:

错误执行数据库查询。[Macromedia] [SQLServer JDBC
驱动程序] [SQLServer]在SET子句中为列名 AttachmentDesc指定的
多于一次。

Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]The column name 'AttachmentDesc' is specified more than once in the SET clause.

所以我看到了错误，但是如果页面显示错误而不是我必须在application.log中找到它，那会更好。

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

问：还有其他设置我需要帮助在页面上显示错误吗？

Q: Is there another setting that I'm missing to help display errors on the page itself?

推荐答案

好像IIS隐藏了来自您的错误。在IIS的错误页面下，选择500个错误，然后单击编辑功能设置，然后选择详细错误-您现在应该看到完整的错误信息（提供的调试是在n CF上进行的。）

Looks like IIS is hiding the errors from you. Under 'Error Pages' in IIS, select the 500 error and click 'Edit feature settings' and select 'Detailed errors' - you should now see the full error info (provided debugging is on n CF).

这篇关于500-SQL Server错误的内部服务器错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！