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:dc1ed4b3-4768-49fd-92b7-e2fcd4a951fa
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 31 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (31,6,'{"status":"ok","response":{"player":{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"New Zealand"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":105,"innings":186,"notout":17,"runs":9276,"balls":17913,"highest":251,"run100":33,"run50":37,"run4":1031,"run6":27,"average":"54.88","strike":"51.78","catches":90,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":173,"innings":165,"notout":18,"runs":7235,"balls":8853,"highest":148,"run100":15,"run50":47,"run4":664,"run6":60,"average":"49.21","strike":"81.72","catches":74,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":93,"innings":90,"notout":13,"runs":2575,"balls":2092,"highest":95,"run100":0,"run50":18,"run4":245,"run6":58,"average":"33.44","strike":"123.08","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":269,"innings":256,"notout":42,"runs":6849,"balls":5574,"highest":101,"run100":1,"run50":48,"run4":623,"run6":175,"average":"32.00","strike":"122.87","catches":116,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":235,"innings":223,"notout":26,"runs":9399,"balls":11564,"highest":148,"run100":19,"run50":59,"run4":833,"run6":82,"average":"47.71","strike":"81.27","catches":102,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":301,"notout":24,"runs":14151,"balls":27158,"highest":284,"run100":43,"run50":65,"run4":1651,"run6":47,"average":"51.08","strike":"52.10","catches":155,"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":105,"innings":67,"balls":2151,"overs":358.3,"runs":1207,"wickets":30,"bestinning":"4\/44","bestmatch":"4\/44","econ":"3.36","average":"40.23","strike":"71.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":173,"innings":65,"balls":1467,"overs":244.3,"runs":1310,"wickets":37,"bestinning":"4\/22","bestmatch":"4\/22","econ":"5.35","average":"35.40","strike":"39.6","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":93,"innings":12,"balls":118,"overs":19.4,"runs":164,"wickets":6,"bestinning":"2\/16","bestmatch":"2\/16","econ":"8.33","average":"27.33","strike":"19.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":269,"innings":54,"balls":770,"overs":128.2,"runs":909,"wickets":30,"bestinning":"3\/33","bestmatch":"3\/33","econ":"7.08","average":"30.30","strike":"25.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":235,"innings":99,"balls":2756,"overs":459.2,"runs":2383,"wickets":67,"bestinning":"5\/51","bestmatch":"5\/51","econ":"5.18","average":"35.56","strike":"41.1","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":142,"balls":6624,"overs":1104,"runs":3721,"wickets":86,"bestinning":"5\/75","bestmatch":"5\/59","econ":"3.37","average":"43.26","strike":"77.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"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":"54f081f73d40de124bd382880c97bd00","modified":"2025-06-25 22:20:26","datetime":"2025-06-25 22:20:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"New Zealand"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":105,"innings":186,"notout":17,"runs":9276,"balls":17913,"highest":251,"run100":33,"run50":37,"run4":1031,"run6":27,"average":"54.88","strike":"51.78","catches":90,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":173,"innings":165,"notout":18,"runs":7235,"balls":8853,"highest":148,"run100":15,"run50":47,"run4":664,"run6":60,"average":"49.21","strike":"81.72","catches":74,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":93,"innings":90,"notout":13,"runs":2575,"balls":2092,"highest":95,"run100":0,"run50":18,"run4":245,"run6":58,"average":"33.44","strike":"123.08","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":269,"innings":256,"notout":42,"runs":6849,"balls":5574,"highest":101,"run100":1,"run50":48,"run4":623,"run6":175,"average":"32.00","strike":"122.87","catches":116,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":235,"innings":223,"notout":26,"runs":9399,"balls":11564,"highest":148,"run100":19,"run50":59,"run4":833,"run6":82,"average":"47.71","strike":"81.27","catches":102,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":301,"notout":24,"runs":14151,"balls":27158,"highest":284,"run100":43,"run50":65,"run4":1651,"run6":47,"average":"51.08","strike":"52.10","catches":155,"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":105,"innings":67,"balls":2151,"overs":358.3,"runs":1207,"wickets":30,"bestinning":"4\/44","bestmatch":"4\/44","econ":"3.36","average":"40.23","strike":"71.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":173,"innings":65,"balls":1467,"overs":244.3,"runs":1310,"wickets":37,"bestinning":"4\/22","bestmatch":"4\/22","econ":"5.35","average":"35.40","strike":"39.6","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":93,"innings":12,"balls":118,"overs":19.4,"runs":164,"wickets":6,"bestinning":"2\/16","bestmatch":"2\/16","econ":"8.33","average":"27.33","strike":"19.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":269,"innings":54,"balls":770,"overs":128.2,"runs":909,"wickets":30,"bestinning":"3\/33","bestmatch":"3\/33","econ":"7.08","average":"30.30","strike":"25.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":235,"innings":99,"balls":2756,"overs":459.2,"runs":2383,"wickets":67,"bestinning":"5\/51","bestmatch":"5\/51","econ":"5.18","average":"35.56","strike":"41.1","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":142,"balls":6624,"overs":1104,"runs":3721,"wickets":86,"bestinning":"5\/75","bestmatch":"5\/59","econ":"3.37","average":"43.26","strike":"77.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"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":"54f081f73d40de124bd382880c97bd00","modified":"2025-06-25 22:20:26","datetime":"2025-06-25 22:20:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 31 AND DataTypeId = 6 END Player profile of Kane Williamson, New Zealand
