********************************************************** Time Of Error : 05-05-2022 09:33:12 Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> 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 'where LedgerTransactionNo='012205040117'' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_DBFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab, String policyno, String mytokenno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2600 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 05-05-2022 09:33:20 Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> 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 'where LedgerTransactionNo='012205040117'' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_DBFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab, String policyno, String mytokenno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2600 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 05-05-2022 11:19:00 Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> 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 'where LedgerTransactionNo='012205040117'' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_DBFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab, String policyno, String mytokenno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2600 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 05-05-2022 15:11:07 Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Itdose\Naokon\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Itdose\Naokon\Design\Welcome.aspx.cs:line 287 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100