Discuz!NT官方社区

首页 » Discuz!NT交流与讨论 » BUG 反馈 » MYSQL版自动激活个人空间出错
zuii - 2008-2-10 13:35:00
很奇怪,管理员申请不会出错,会员申请显示错误页面(自动激活),手动激活正常,出现错误页面后刷新次错误的页面,系统提示空间已经申请。。。但有个错误页面很不友好吧。出错信息:


Server Error in '/' Application. 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 ') ORDER BY `tid` DESC' at line 1 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: 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 ') ORDER BY `tid` DESC' at line 1

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

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

or:

2) Add the following section to the configuration file of your application:

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

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[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 ') ORDER BY `tid` DESC' 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.ExecuteReader(CommandBehavior behavior) +7  Discuz.Data.DbHelper.ExecuteReader(DbConnection connection, DbTransaction transaction, CommandType commandType, String commandText, DbParameter[] commandParameters, DbConnectionOwnership connectionOwnership) +385  Discuz.Data.DbHelper.ExecuteReader(CommandType commandType, String commandText, DbParameter[] commandParameters) +239  Discuz.Data.DbHelper.ExecuteReader(CommandType commandType, String commandText) +6  Discuz.Data.MySql.DataProvider.GetTopicsByUserId(Int32 userId, Int32 pageIndex, Int32 pageSize) +1007  Discuz.Forum.Topics.GetTopicsByUserId(Int32 userId, Int32 pageIndex, Int32 pageSize, Int32 newmin, Int32 hot) +73  Discuz.ForumPage.spaceregister.ShowPage() +3081  Discuz.Web.UI.Pages.BasePage..ctor() +4137  Discuz.ForumPage.spaceregister..ctor() +58  ASP.aspx_1_spaceregister_aspx..ctor() +10  __ASP.FastObjectFactory_app_web_a7k8tpcz.Create_ASP_aspx_1_spaceregister_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
zuii - 2008-2-22 15:44:00
Source Error:


[No relevant source lines]


Source File: c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\7bb0197a\2aadc164\App_Web_vvdz0wvs.19.cs    Line: 0
1
查看完整版本: MYSQL版自动激活个人空间出错