System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:bcb1f8d9-285d-4828-9490-b44f80113cd6
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1018 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1018,6,'{"status":"ok","response":{"player":{"pid":1018,"title":"Mehidy Hasan Miraz","short_name":"MH Miraz","first_name":"Mehidy Hasan Miraz","last_name":"","middle_name":"","birthdate":"1997-10-25","birthplace":"Khulna","country":"bd","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/OfficialMehidyMiraz\/","twitter_profile":"https:\/\/twitter.com\/Officialmiraz","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Bangladesh"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":53,"innings":96,"notout":10,"runs":2068,"balls":4101,"highest":104,"run100":2,"run50":9,"run4":243,"run6":22,"average":"24.04","strike":"50.42","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":105,"innings":76,"notout":11,"runs":1617,"balls":2105,"highest":112,"run100":2,"run50":6,"run4":137,"run6":27,"average":"24.87","strike":"76.81","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":31,"innings":26,"notout":4,"runs":378,"balls":325,"highest":46,"run100":0,"run50":0,"run4":31,"run6":10,"average":"17.18","strike":"116.30","catches":16,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":155,"innings":133,"notout":18,"runs":2123,"balls":1790,"highest":87,"run100":0,"run50":7,"run4":186,"run6":79,"average":"18.46","strike":"118.60","catches":63,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":182,"innings":144,"notout":21,"runs":3077,"balls":3860,"highest":112,"run100":3,"run50":13,"run4":240,"run6":61,"average":"25.01","strike":"79.71","catches":75,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":124,"notout":16,"runs":2968,"balls":5612,"highest":104,"run100":2,"run50":18,"run4":356,"run6":31,"average":"27.48","strike":"52.88","catches":58,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":53,"innings":93,"balls":12576,"overs":2096,"runs":6560,"wickets":205,"bestinning":"7\/58","bestmatch":"12\/117","econ":"3.12","average":"32.00","strike":"61.3","wicket4i":9,"wicket5i":13,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":105,"innings":102,"balls":5037,"overs":839.3,"runs":4061,"wickets":110,"bestinning":"4\/25","bestmatch":"4\/25","econ":"4.83","average":"36.91","strike":"45.7","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":31,"innings":28,"balls":420,"overs":70,"runs":603,"wickets":16,"bestinning":"4\/12","bestmatch":"4\/12","econ":"8.61","average":"37.68","strike":"26.2","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":155,"innings":145,"balls":2600,"overs":433.2,"runs":3286,"wickets":109,"bestinning":"4\/12","bestmatch":"4\/12","econ":"7.58","average":"30.14","strike":"23.8","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":182,"innings":178,"balls":8515,"overs":1419.1,"runs":6604,"wickets":212,"bestinning":"5\/42","bestmatch":"5\/42","econ":"4.65","average":"31.15","strike":"40.1","wicket4i":6,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":129,"balls":18224,"overs":3037.2,"runs":8816,"wickets":304,"bestinning":"7\/24","bestmatch":"12\/117","econ":"2.90","average":"29.00","strike":"59.9","wicket4i":13,"wicket5i":21,"wicket10m":5,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"085e70a6e49aeb35286b04fa93025afc","modified":"2025-06-20 15:52:45","datetime":"2025-06-20 15:52:45","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1018,"title":"Mehidy Hasan Miraz","short_name":"MH Miraz","first_name":"Mehidy Hasan Miraz","last_name":"","middle_name":"","birthdate":"1997-10-25","birthplace":"Khulna","country":"bd","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/OfficialMehidyMiraz\/","twitter_profile":"https:\/\/twitter.com\/Officialmiraz","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Bangladesh"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":53,"innings":96,"notout":10,"runs":2068,"balls":4101,"highest":104,"run100":2,"run50":9,"run4":243,"run6":22,"average":"24.04","strike":"50.42","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":105,"innings":76,"notout":11,"runs":1617,"balls":2105,"highest":112,"run100":2,"run50":6,"run4":137,"run6":27,"average":"24.87","strike":"76.81","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":31,"innings":26,"notout":4,"runs":378,"balls":325,"highest":46,"run100":0,"run50":0,"run4":31,"run6":10,"average":"17.18","strike":"116.30","catches":16,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":155,"innings":133,"notout":18,"runs":2123,"balls":1790,"highest":87,"run100":0,"run50":7,"run4":186,"run6":79,"average":"18.46","strike":"118.60","catches":63,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":182,"innings":144,"notout":21,"runs":3077,"balls":3860,"highest":112,"run100":3,"run50":13,"run4":240,"run6":61,"average":"25.01","strike":"79.71","catches":75,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":124,"notout":16,"runs":2968,"balls":5612,"highest":104,"run100":2,"run50":18,"run4":356,"run6":31,"average":"27.48","strike":"52.88","catches":58,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":53,"innings":93,"balls":12576,"overs":2096,"runs":6560,"wickets":205,"bestinning":"7\/58","bestmatch":"12\/117","econ":"3.12","average":"32.00","strike":"61.3","wicket4i":9,"wicket5i":13,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":105,"innings":102,"balls":5037,"overs":839.3,"runs":4061,"wickets":110,"bestinning":"4\/25","bestmatch":"4\/25","econ":"4.83","average":"36.91","strike":"45.7","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":31,"innings":28,"balls":420,"overs":70,"runs":603,"wickets":16,"bestinning":"4\/12","bestmatch":"4\/12","econ":"8.61","average":"37.68","strike":"26.2","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":155,"innings":145,"balls":2600,"overs":433.2,"runs":3286,"wickets":109,"bestinning":"4\/12","bestmatch":"4\/12","econ":"7.58","average":"30.14","strike":"23.8","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":182,"innings":178,"balls":8515,"overs":1419.1,"runs":6604,"wickets":212,"bestinning":"5\/42","bestmatch":"5\/42","econ":"4.65","average":"31.15","strike":"40.1","wicket4i":6,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":129,"balls":18224,"overs":3037.2,"runs":8816,"wickets":304,"bestinning":"7\/24","bestmatch":"12\/117","econ":"2.90","average":"29.00","strike":"59.9","wicket4i":13,"wicket5i":21,"wicket10m":5,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"085e70a6e49aeb35286b04fa93025afc","modified":"2025-06-20 15:52:45","datetime":"2025-06-20 15:52:45","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1018 AND DataTypeId = 6 END Player profile of Mehidy Hasan Miraz, Bangladesh
