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 JDBCDriver][SQLServer]列名 'AttachmentDesc' 指定更多在 SET 子句中不止一次.

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屋！