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:b4a6e18c-085c-4b57-b160-4b189dc6ae81
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1157 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1157,6,'{"status":"ok","response":{"player":{"pid":1157,"title":"Rashid Khan","short_name":"R Khan","first_name":"Rashid Khan","last_name":"","middle_name":"","birthdate":"1998-09-20","birthplace":"Nangarhar, Afghanistan","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rashidkhan_19","instagram_profile":"https:\/\/www.instagram.com\/rashid.khan19\/","debut_data":"","thumb_url":"","nationality":"Afghanistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":9,"notout":0,"runs":154,"balls":180,"highest":51,"run100":0,"run50":1,"run4":18,"run6":4,"average":"17.11","strike":"85.55","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":114,"innings":87,"notout":16,"runs":1384,"balls":1320,"highest":60,"run100":0,"run50":5,"run4":120,"run6":49,"average":"19.49","strike":"104.84","catches":33,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":96,"innings":59,"notout":25,"runs":467,"balls":370,"highest":48,"run100":0,"run50":0,"run4":31,"run6":28,"average":"13.73","strike":"126.21","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":477,"innings":284,"notout":93,"runs":2589,"balls":1773,"highest":79,"run100":0,"run50":5,"run4":188,"run6":170,"average":"13.55","strike":"146.02","catches":166,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":88,"notout":16,"runs":1405,"balls":1334,"highest":60,"run100":0,"run50":5,"run4":125,"run6":49,"average":"19.51","strike":"105.32","catches":34,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":13,"notout":1,"runs":279,"balls":347,"highest":52,"run100":0,"run50":2,"run4":36,"run6":4,"average":"23.25","strike":"80.40","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"19","innings":"6","notout":"1","runs":"56","balls":"38","highest":"21","run100":"0","run50":"0","run4":"7","run6":"2","average":"11.20","strike":"147.37","catches":"7","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":11,"balls":1864,"overs":310.4,"runs":920,"wickets":45,"bestinning":"7\/66","bestmatch":"11\/104","econ":"2.96","average":"20.44","strike":"41.4","wicket4i":2,"wicket5i":5,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":114,"innings":106,"balls":5741,"overs":956.5,"runs":4060,"wickets":199,"bestinning":"7\/18","bestmatch":"7\/18","econ":"4.24","average":"20.40","strike":"28.8","wicket4i":6,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":96,"innings":96,"balls":2192,"overs":365.2,"runs":2222,"wickets":161,"bestinning":"5\/3","bestmatch":"5\/3","econ":"6.08","average":"13.80","strike":"13.6","wicket4i":8,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":477,"innings":473,"balls":10918,"overs":1819.4,"runs":11975,"wickets":643,"bestinning":"6\/17","bestmatch":"6\/17","econ":"6.58","average":"18.62","strike":"16.9","wicket4i":16,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":108,"balls":5848,"overs":974.4,"runs":4148,"wickets":203,"bestinning":"7\/18","bestmatch":"7\/18","econ":"4.25","average":"20.43","strike":"28.8","wicket4i":6,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":19,"balls":3043,"overs":507.1,"runs":1447,"wickets":80,"bestinning":"8\/74","bestmatch":"12\/122","econ":"2.85","average":"18.08","strike":"38.0","wicket4i":3,"wicket5i":9,"wicket10m":4,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"19","innings":"11","balls":"126","overs":"21","runs":"174","wickets":"5","bestinning":"0\/18","bestmatch":"","econ":"8.29","average":"34.80","strike":"25.20","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"85dcc63334efd9262928e932c5ea6e56","modified":"2025-06-24 10:45:49","datetime":"2025-06-24 10:45:49","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1157,"title":"Rashid Khan","short_name":"R Khan","first_name":"Rashid Khan","last_name":"","middle_name":"","birthdate":"1998-09-20","birthplace":"Nangarhar, Afghanistan","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rashidkhan_19","instagram_profile":"https:\/\/www.instagram.com\/rashid.khan19\/","debut_data":"","thumb_url":"","nationality":"Afghanistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":9,"notout":0,"runs":154,"balls":180,"highest":51,"run100":0,"run50":1,"run4":18,"run6":4,"average":"17.11","strike":"85.55","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":114,"innings":87,"notout":16,"runs":1384,"balls":1320,"highest":60,"run100":0,"run50":5,"run4":120,"run6":49,"average":"19.49","strike":"104.84","catches":33,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":96,"innings":59,"notout":25,"runs":467,"balls":370,"highest":48,"run100":0,"run50":0,"run4":31,"run6":28,"average":"13.73","strike":"126.21","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":477,"innings":284,"notout":93,"runs":2589,"balls":1773,"highest":79,"run100":0,"run50":5,"run4":188,"run6":170,"average":"13.55","strike":"146.02","catches":166,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":88,"notout":16,"runs":1405,"balls":1334,"highest":60,"run100":0,"run50":5,"run4":125,"run6":49,"average":"19.51","strike":"105.32","catches":34,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":13,"notout":1,"runs":279,"balls":347,"highest":52,"run100":0,"run50":2,"run4":36,"run6":4,"average":"23.25","strike":"80.40","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"19","innings":"6","notout":"1","runs":"56","balls":"38","highest":"21","run100":"0","run50":"0","run4":"7","run6":"2","average":"11.20","strike":"147.37","catches":"7","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":11,"balls":1864,"overs":310.4,"runs":920,"wickets":45,"bestinning":"7\/66","bestmatch":"11\/104","econ":"2.96","average":"20.44","strike":"41.4","wicket4i":2,"wicket5i":5,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":114,"innings":106,"balls":5741,"overs":956.5,"runs":4060,"wickets":199,"bestinning":"7\/18","bestmatch":"7\/18","econ":"4.24","average":"20.40","strike":"28.8","wicket4i":6,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":96,"innings":96,"balls":2192,"overs":365.2,"runs":2222,"wickets":161,"bestinning":"5\/3","bestmatch":"5\/3","econ":"6.08","average":"13.80","strike":"13.6","wicket4i":8,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":477,"innings":473,"balls":10918,"overs":1819.4,"runs":11975,"wickets":643,"bestinning":"6\/17","bestmatch":"6\/17","econ":"6.58","average":"18.62","strike":"16.9","wicket4i":16,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":108,"balls":5848,"overs":974.4,"runs":4148,"wickets":203,"bestinning":"7\/18","bestmatch":"7\/18","econ":"4.25","average":"20.43","strike":"28.8","wicket4i":6,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":19,"balls":3043,"overs":507.1,"runs":1447,"wickets":80,"bestinning":"8\/74","bestmatch":"12\/122","econ":"2.85","average":"18.08","strike":"38.0","wicket4i":3,"wicket5i":9,"wicket10m":4,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"19","innings":"11","balls":"126","overs":"21","runs":"174","wickets":"5","bestinning":"0\/18","bestmatch":"","econ":"8.29","average":"34.80","strike":"25.20","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"85dcc63334efd9262928e932c5ea6e56","modified":"2025-06-24 10:45:49","datetime":"2025-06-24 10:45:49","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1157 AND DataTypeId = 6 END Player profile of Rashid Khan, Afghanistan
