Discuz!NT官方社区

首页 » Discuz!NT交流与讨论 » BUG 反馈 » NT2.0个人空间出现错误
JMcn - 2007-11-15 23:49:00


“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10 `tid`, `title` FROM `dnt_topics` WHERE `displayorder`>=0 AND `closed`<>1 ORD' at line 1
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10 `tid`, `title` FROM `dnt_topics` WHERE `displayorder`>=0 AND `closed`<>1 ORD' at line 1

源错误:

只有在调试模式下进行编译时,生成此未处理异常的源代码才会显示出来。若要启用此功能,请执行以下步骤之一,然后请求 URL:

1. 在产生错误的文件的顶部添加一条“Debug=true”指令。例如:

<%@ Page Language="C#" Debug="true" %>

或:

2. 将以下的节添加到应用程序的配置文件中:







请注意,第二个步骤将使给定应用程序中的所有文件在调试模式下进行编译;第一个步骤仅使该特定文件在调试模式下进行编译。

重要事项: 以调试模式运行应用程序一定会产生内存/性能系统开销。在部署到生产方案之前,应确保应用程序调试已禁用。

堆栈跟踪:


[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10 `tid`, `title` FROM `dnt_topics` WHERE `displayorder`>=0 AND `closed`<>1 ORD' at line 1]
MySql.Data.MySqlClient.MySqlStream.OpenPacket() +267
MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +55
MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +48
MySql.Data.MySqlClient.MySqlDataReader.NextResult() +468
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +865
MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
Discuz.Data.DbHelper.ExecuteDataset(DbConnection connection, CommandType commandType, String commandText, DbParameter[] commandParameters) +202
Discuz.Data.DbHelper.ExecuteDataset(CommandType commandType, String commandText, DbParameter[] commandParameters) +215
Discuz.Data.DbHelper.ExecuteDataset(String commandText) +13
Discuz.Data.MySql.DataProvider.GetWebSiteAggForumHotTopicList() +33
Discuz.Aggregation.ForumAggregationData.GetForumHotTopicList() +136
Discuz.ForumPage.spaceindex.ShowPage() +146
Discuz.Web.UI.Pages.BasePage..ctor() +4002
Discuz.ForumPage.spaceindex..ctor() +97
ASP.aspx_4_spaceindex_aspx..ctor() +9
__ASP.FastObjectFactory_app_web_7pitvqfd.Create_ASP_aspx_4_spaceindex_aspx() +20
System.Web.Compilation.BuildResultCompiledType.CreateInstance() +49
System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +115
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +31
System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +139
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +120
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155




--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.832; ASP.NET 版本:2.0.50727.832


NT版本:NT2.0正式版
Windows版本:XP
数据库:Mysql
.NET:2.0
旭雨 - 2007-11-16 10:59:00
谢谢您反馈,问题已经收录
sunfly028 - 2007-11-30 9:56:00
请问这个问题处理好了吗,怎么解决?
1
查看完整版本: NT2.0个人空间出现错误