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

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 ':parentid="|" and is_show=1  order by sort desc,id asc' at line 1

说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Exception: 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 ':parentid="|" and is_show=1  order by sort desc,id asc' at line 1

源错误:

执行当前 Web 请求期间生成了未经处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。

堆栈跟踪:


[Exception: 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 ':parentid="|" and is_show=1  order by sort desc,id asc' at line 1]
   QWCMS.DBUtility.DbHelperMySQL.Query(String SQLString) in E:\work\晴网CMSV1.2\QWCMS_V1.2_MYSQL\DBUtility\DbHelperMySQL.cs:490
   QWCMS.MySQLDAL.Site_class.GetList(String strWhere) in E:\work\晴网CMSV1.2\QWCMS_V1.3_MYSQL\MySQLDAL\site_class.cs:595
   QWCMS.BLL.Site_class.GetModelList(String strWhere) in E:\work\晴网CMSV1.2\QWCMS_V1.3_MYSQL\BLL\site_class.cs:153
   QWCMS.Tag.Channel.ExplainList(String str) in E:\work\晴网CMSV1.2\103_svn\Tag\Channel.cs:109
   QWCMS.Tag.Channel.GetList(String htmlStr) in E:\work\晴网CMSV1.2\103_svn\Tag\Channel.cs:18
   QWCMS.Tag.Templets.GetHtml(String pathStr, Hashtable ht) in E:\work\晴网CMSV1.2\103_svn\Tag\Templets.cs:106
   QWCMS_V_1_1.Controllers.NewsController.<Show>b__7_0() in E:\work\晴网CMSV1.2\103_svn\Web\Controllers\NewsController.cs:163
   Web.Areas.QWCMS_V_1_1.Controllers.BaseController.ReturnDataAction(Action action) in E:\work\晴网CMSV1.2\103_svn\Web\Controllers\BaseController.cs:26
   QWCMS_V_1_1.Controllers.NewsController.Show() in E:\work\晴网CMSV1.2\103_svn\Web\Controllers\NewsController.cs:113
   lambda_method(Closure , ControllerBase , Object[] ) +62
   System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +157
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
   System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +22
   System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +34
   System.Web.Mvc.Async.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() +50
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +228
   System.Web.Mvc.Async.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +34
   System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +26
   System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +100
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +27
   System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +38
   System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +12
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +22
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +28
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
   System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +21
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +28
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9875181
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +48
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +159


版本信息: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.7.4087.0