2025-09-01 09:32:43,045 [19] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'内蒙古自治区乌海市乌达区',''),'内蒙古自治区',''),'乌海市',''),'内蒙古自治区乌海',''),'乌海市乌达区',''),'乌海乌达','')) as Score from OrderInfo where CreateTime <= '2025-08-13 11:22:48' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128352 and Region = '内蒙古自治区|乌海市|乌达区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 09:32:43,050 [19] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 09:32:43,053 [19] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 09:32:43,053 [19] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 10:48:16,374 [22] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省佛山市高明区',''),'广东省',''),'佛山市',''),'广东佛山',''),'佛山市高明区',''),'佛山高明','')) as Score from OrderInfo where CreateTime <= '2025-09-01 10:47:05' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128350 and Region = '广东省|佛山市|高明区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 10:48:16,377 [22] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 10:48:16,377 [22] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 10:48:16,377 [22] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 11:41:58,031 [143] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 11:41:58,032 [143] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:41:58,032 [143] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:41:58,032 [143] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:42:53,468 [243] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 11:42:53,469 [243] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:42:53,469 [243] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:42:53,469 [243] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:21,546 [422] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 11:43:21,548 [422] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:21,548 [422] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:21,548 [422] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:33,722 [21] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 11:43:33,723 [21] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:33,723 [21] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:33,723 [21] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 14:55:47,663 [342] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-01 14:54:48' and Status in (4,5,6) and UserId is not null and UserId <> 1006 and CustomerId is not null and CustomerId <> 128350 and Region = '山西省|大同市|矿区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 14:55:47,666 [342] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 14:55:47,668 [342] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 14:55:47,668 [342] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 15:49:10,095 [127] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 15:49:10,097 [127] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:49:10,097 [127] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:49:10,097 [127] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:50:24,573 [34] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 15:50:24,575 [34] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:50:24,575 [34] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:50:24,575 [34] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:56:24,818 [341] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 15:56:24,820 [341] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:56:24,820 [341] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:56:24,820 [341] ERROR NHibernate.Util.ADOExceptionReporter - 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 ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1