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:5f05de76-90ab-452a-bed7-23fc98fbdac6
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53000 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53000,6,'{"status":"ok","response":{"player":{"pid":53000,"title":"Andile Phehlukwayo","short_name":"A Phehlukwayo","first_name":"Andile Phehlukwayo","last_name":"","middle_name":"","birthdate":"1996-03-03","birthplace":"Durban","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/m.facebook.com\/andile.phehlukwayo\/","twitter_profile":"https:\/\/twitter.com\/andileluck19","instagram_profile":"https:\/\/www.instagram.com\/andile_phehlukwayo\/","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"notout":2,"runs":19,"balls":39,"highest":9,"run100":0,"run50":0,"run4":3,"run6":0,"average":"9.50","strike":"48.71","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":85,"innings":57,"notout":19,"runs":883,"balls":1027,"highest":69,"run100":0,"run50":2,"run4":77,"run6":36,"average":"23.23","strike":"85.97","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":25,"notout":7,"runs":166,"balls":153,"highest":27,"run100":0,"run50":0,"run4":16,"run6":5,"average":"9.22","strike":"108.49","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":103,"notout":25,"runs":1027,"balls":878,"highest":39,"run100":0,"run50":0,"run4":85,"run6":44,"average":"13.16","strike":"116.97","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":154,"innings":114,"notout":27,"runs":2258,"balls":2553,"highest":100,"run100":1,"run50":10,"run4":184,"run6":88,"average":"25.95","strike":"88.44","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":82,"notout":12,"runs":1733,"balls":3445,"highest":107,"run100":1,"run50":10,"run4":221,"run6":35,"average":"24.75","strike":"50.30","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"1","notout":"0","runs":"0","balls":"1","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"0.00","strike":"0.00","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":4,"innings":8,"balls":250,"overs":41.4,"runs":147,"wickets":11,"bestinning":"3\/13","bestmatch":"5\/25","econ":"3.52","average":"13.36","strike":"22.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":85,"innings":79,"balls":3175,"overs":529.1,"runs":3041,"wickets":97,"bestinning":"4\/22","bestmatch":"4\/22","econ":"5.74","average":"31.35","strike":"32.7","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":39,"balls":748,"overs":124.4,"runs":1112,"wickets":50,"bestinning":"4\/24","bestmatch":"4\/24","econ":"8.91","average":"22.24","strike":"14.9","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":134,"balls":2242,"overs":373.4,"runs":3174,"wickets":121,"bestinning":"5\/26","bestmatch":"5\/26","econ":"8.49","average":"26.23","strike":"18.5","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":154,"innings":142,"balls":5677,"overs":946.1,"runs":5377,"wickets":177,"bestinning":"6\/27","bestmatch":"6\/27","econ":"5.68","average":"30.37","strike":"32.0","wicket4i":8,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":78,"balls":4531,"overs":755.1,"runs":2747,"wickets":69,"bestinning":"5\/62","bestmatch":"7\/82","econ":"3.63","average":"39.81","strike":"65.6","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"2","balls":"18","overs":"3","runs":"24","wickets":"2","bestinning":"1\/9","bestmatch":"1\/9","econ":"8.00","average":"12.00","strike":"9.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"0bd13898e18241200135b5c872fc707f","modified":"2025-06-24 12:17:13","datetime":"2025-06-24 12:17:13","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53000,"title":"Andile Phehlukwayo","short_name":"A Phehlukwayo","first_name":"Andile Phehlukwayo","last_name":"","middle_name":"","birthdate":"1996-03-03","birthplace":"Durban","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/m.facebook.com\/andile.phehlukwayo\/","twitter_profile":"https:\/\/twitter.com\/andileluck19","instagram_profile":"https:\/\/www.instagram.com\/andile_phehlukwayo\/","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"notout":2,"runs":19,"balls":39,"highest":9,"run100":0,"run50":0,"run4":3,"run6":0,"average":"9.50","strike":"48.71","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":85,"innings":57,"notout":19,"runs":883,"balls":1027,"highest":69,"run100":0,"run50":2,"run4":77,"run6":36,"average":"23.23","strike":"85.97","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":25,"notout":7,"runs":166,"balls":153,"highest":27,"run100":0,"run50":0,"run4":16,"run6":5,"average":"9.22","strike":"108.49","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":103,"notout":25,"runs":1027,"balls":878,"highest":39,"run100":0,"run50":0,"run4":85,"run6":44,"average":"13.16","strike":"116.97","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":154,"innings":114,"notout":27,"runs":2258,"balls":2553,"highest":100,"run100":1,"run50":10,"run4":184,"run6":88,"average":"25.95","strike":"88.44","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":82,"notout":12,"runs":1733,"balls":3445,"highest":107,"run100":1,"run50":10,"run4":221,"run6":35,"average":"24.75","strike":"50.30","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"1","notout":"0","runs":"0","balls":"1","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"0.00","strike":"0.00","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":4,"innings":8,"balls":250,"overs":41.4,"runs":147,"wickets":11,"bestinning":"3\/13","bestmatch":"5\/25","econ":"3.52","average":"13.36","strike":"22.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":85,"innings":79,"balls":3175,"overs":529.1,"runs":3041,"wickets":97,"bestinning":"4\/22","bestmatch":"4\/22","econ":"5.74","average":"31.35","strike":"32.7","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":39,"balls":748,"overs":124.4,"runs":1112,"wickets":50,"bestinning":"4\/24","bestmatch":"4\/24","econ":"8.91","average":"22.24","strike":"14.9","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":134,"balls":2242,"overs":373.4,"runs":3174,"wickets":121,"bestinning":"5\/26","bestmatch":"5\/26","econ":"8.49","average":"26.23","strike":"18.5","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":154,"innings":142,"balls":5677,"overs":946.1,"runs":5377,"wickets":177,"bestinning":"6\/27","bestmatch":"6\/27","econ":"5.68","average":"30.37","strike":"32.0","wicket4i":8,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":78,"balls":4531,"overs":755.1,"runs":2747,"wickets":69,"bestinning":"5\/62","bestmatch":"7\/82","econ":"3.63","average":"39.81","strike":"65.6","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"2","balls":"18","overs":"3","runs":"24","wickets":"2","bestinning":"1\/9","bestmatch":"1\/9","econ":"8.00","average":"12.00","strike":"9.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"0bd13898e18241200135b5c872fc707f","modified":"2025-06-24 12:17:13","datetime":"2025-06-24 12:17:13","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53000 AND DataTypeId = 6 END Player profile of Andile Phehlukwayo, South Africa
