Discuz!NT官方社区

首页 » Discuz!NT交流与讨论 » BUG 反馈 » 个人空间的bug,大问题..管理员来解决下..
whisper - 2007-11-27 12:09:00
在论坛LOGO边上的个人空间图标点击就报MYSQL异常..可是点菜单栏的我的空间就能进空间..这是为什么..?希望管理员尽快解决..谢谢



“/”应用程序中的服务器错误。 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. 将以下节添加到应用程序的配置文件中:

<configuration>
  <system.web>
      <compilation debug="true"/>
  </system.web>
</configuration>

请注意,第二种方法将使给定应用程序中的所有文件在调试模式下进行编译。第一种方法只使特定文件在调试模式下进行编译。

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

堆栈跟踪:

[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]  MySql.Data.MySqlClient.PacketReader.CheckForError() +156  MySql.Data.MySqlClient.PacketReader.ReadHeader() +229  MySql.Data.MySqlClient.PacketReader.OpenPacket() +107  MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId) +17  MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) +57  MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) +128  MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) +394  MySql.Data.MySqlClient.MySqlDataReader.NextResult() +287  MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +180  MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5  System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304  System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77  System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38  Discuz.Data.DbHelper.ExecuteDataset(IDbConnection connection, CommandType commandType, String commandText, IDataParameter[] commandParameters) +236  Discuz.Data.DbHelper.ExecuteDataset(CommandType commandType, String commandText, IDataParameter[] commandParameters) +251  Discuz.Data.DbHelper.ExecuteDataset(String commandText) +13  Discuz.Data.MySql.DataProvider.GetWebSiteAggForumHotTopicList() +33  Discuz.Aggregation.ForumAggregationData.GetForumHotTopicList() +156  Discuz.ForumPage.spaceindex.ShowPage() +144  Discuz.Web.UI.Pages.BasePage..ctor() +4086  Discuz.ForumPage.spaceindex..ctor() +50  _ASP.spaceindex_aspx..ctor() +6[TargetInvocationException: 调用的目标发生了异常。]  System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0  System.Activator.CreateInstance(Type type, Boolean nonPublic) +65  System.Web.UI.TemplateControlParser.GetCompiledInstance(String virtualPath, String inputFile, HttpContext context) +164[HttpException (0x80004005): 未能创建类型为“_ASP.spaceindex_aspx”的页。]  System.Web.UI.TemplateControlParser.GetCompiledInstance(String virtualPath, String inputFile, HttpContext context) +340  System.Web.UI.PageParser.GetCompiledPageInstanceInternal(String virtualPath, String inputFile, HttpContext context) +43  System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String url, String path) +44  System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig) +698  System.Web.MapHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +95  System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +173

版本信息: Microsoft .NET Framework 版本:1.1.4322.2407; ASP.NET 版本:1.1.4322.2407
旭雨 - 2007-11-27 17:27:00
已经发现了这个问题,我们修正了!
bighead - 2007-11-29 16:27:00
该问题已修正稍后我们将提供补丁给大家
sunfly028 - 2007-11-30 9:59:00


引用:
原帖由 bighead 于 2007-11-29 16:27:00 发表
该问题已修正稍后我们将提供补丁给大家


请问补丁出来了吗?
1
查看完整版本: 个人空间的bug,大问题..管理员来解决下..