鈥?鈥濆簲鐢ㄧ▼搴忎腑鐨勬湇鍔″櫒閿欒銆侟hr width=100% size=1 color=silver>

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 '-24, 12' at line 1

璇存槑: 鎵ц褰撳墠 Web 璇锋眰鏈熼棿锛屽嚭鐜版湭缁忓鐞嗙殑寮傚父銆傝妫€鏌ュ爢鏍堣窡韪俊鎭紝浠ヤ簡瑙f湁鍏宠閿欒浠ュ強浠g爜涓鑷撮敊璇殑鍑哄鐨勮缁嗕俊鎭€

寮傚父璇︾粏淇℃伅: 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 '-24, 12' at line 1

婧愰敊璇?

鎵ц褰撳墠 Web 璇锋眰鏈熼棿鐢熸垚浜嗘湭缁忓鐞嗙殑寮傚父銆傚彲浠ヤ娇鐢ㄤ笅闈㈢殑寮傚父鍫嗘爤璺熻釜淇℃伅纭畾鏈夊叧寮傚父鍘熷洜鍜屽彂鐢熶綅缃殑淇℃伅銆

鍫嗘爤璺熻釜:


[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 '-24, 12' at line 1]
   MySql.Data.MySqlClient.MySqlStream.OpenPacket() +243
   MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +63
   MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +45
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1037
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1298
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +180
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +126
   SqlDal.MySqlHelper.ExecuteDataSet(MySqlConnection connection, MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] parms) +262
   SqlDal.MySqlHelper.ExecuteDataSet(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] parms) +78
   SqlDal.MySqlHelper.ExecuteDataSet(String connectionString, CommandType commandType, String commandText, MySqlParameter[] parms) +126
   SqlDal.MySqlHelper.ExecuteDataTable(CommandType commandType, String commandText, MySqlParameter[] parms) +86
   SqlDal.ProductSql.GetProductPage(ProductQuery query) +2256
   SqlDal.ProductHelper.GetProductPage(ProductQuery query) +91
   Web_Api.Controllers.ProductController.List(Int32 id, Int32 pageNo, String keyWords) in E:\缃戠珯\婀樼爺2025-2\婀樼爺涓枃鐗圽Web\Controllers\ProductController.cs:52
   lambda_method(Closure , ControllerBase , Object[] ) +250
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
   System.Web.Mvc.Async.<>c.b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +39
   System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +77
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass11_0.b__0() +80
   System.Web.Mvc.Async.<>c__DisplayClass11_2.b__2() +396
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass3_5.b__4() +46
   System.Web.Mvc.Async.<>c__DisplayClass3_0.b__1(IAsyncResult asyncResult) +180
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +431
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +75
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +158


鐗堟湰淇℃伅: Microsoft .NET Framework 鐗堟湰:4.0.30319; ASP.NET 鐗堟湰:4.8.4676.0
XML 地图