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:35dcd757-2cae-4911-88bd-5ee61a2b8c45
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53425 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53425,6,'{"status":"ok","response":{"player":{"pid":53425,"title":"Faheem Ashraf","short_name":"F Ashraf","first_name":"Faheem Ashraf","last_name":"","middle_name":"","birthdate":"1994-01-16","birthplace":"Kasur, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iFaheemAshraf","instagram_profile":"https:\/\/www.instagram.com\/rana_faheem_ashraf\/","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":17,"innings":27,"notout":1,"runs":687,"balls":1268,"highest":91,"run100":0,"run50":4,"run4":100,"run6":3,"average":"26.42","strike":"54.17","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":27,"notout":3,"runs":322,"balls":379,"highest":73,"run100":0,"run50":1,"run4":26,"run6":10,"average":"13.41","strike":"84.96","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":51,"innings":35,"notout":9,"runs":323,"balls":249,"highest":31,"run100":0,"run50":0,"run4":19,"run6":19,"average":"12.42","strike":"129.71","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":224,"innings":159,"notout":44,"runs":2040,"balls":1420,"highest":55,"run100":0,"run50":6,"run4":157,"run6":116,"average":"17.73","strike":"143.66","catches":77,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":95,"innings":74,"notout":9,"runs":1314,"balls":1464,"highest":88,"run100":0,"run50":7,"run4":111,"run6":45,"average":"20.21","strike":"89.75","catches":31,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":120,"notout":14,"runs":3174,"balls":5051,"highest":147,"run100":4,"run50":15,"run4":439,"run6":30,"average":"29.94","strike":"62.83","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"5","innings":"5","notout":"3","runs":"63","balls":"23","highest":"22","run100":"0","run50":"0","run4":"2","run6":"8","average":"31.50","strike":"273.91","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":17,"innings":31,"balls":1908,"overs":318,"runs":991,"wickets":25,"bestinning":"3\/42","bestmatch":"6\/99","econ":"3.11","average":"39.64","strike":"76.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":36,"balls":1498,"overs":249.4,"runs":1297,"wickets":28,"bestinning":"5\/22","bestmatch":"5\/22","econ":"5.19","average":"46.32","strike":"53.5","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":51,"innings":49,"balls":823,"overs":137.1,"runs":1048,"wickets":39,"bestinning":"3\/5","bestmatch":"3\/5","econ":"7.64","average":"26.87","strike":"21.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":224,"innings":219,"balls":4218,"overs":703,"runs":5861,"wickets":223,"bestinning":"6\/19","bestmatch":"6\/19","econ":"8.33","average":"26.28","strike":"18.9","wicket4i":3,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":95,"innings":94,"balls":4082,"overs":680.2,"runs":3603,"wickets":117,"bestinning":"5\/22","bestmatch":"5\/22","econ":"5.29","average":"30.79","strike":"34.8","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":137,"balls":11064,"overs":1844,"runs":5774,"wickets":183,"bestinning":"6\/65","bestmatch":"9\/115","econ":"3.13","average":"31.55","strike":"60.4","wicket4i":3,"wicket5i":7,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"5","innings":"5","balls":"36","overs":"6","runs":"120","wickets":"4","bestinning":"2\/50","bestmatch":"2\/50","econ":"20.00","average":"30.00","strike":"9.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"9f2cc5993a4e7446cf9d8414165cd596","modified":"2025-06-23 08:39:21","datetime":"2025-06-23 08:39:21","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53425,"title":"Faheem Ashraf","short_name":"F Ashraf","first_name":"Faheem Ashraf","last_name":"","middle_name":"","birthdate":"1994-01-16","birthplace":"Kasur, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iFaheemAshraf","instagram_profile":"https:\/\/www.instagram.com\/rana_faheem_ashraf\/","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":17,"innings":27,"notout":1,"runs":687,"balls":1268,"highest":91,"run100":0,"run50":4,"run4":100,"run6":3,"average":"26.42","strike":"54.17","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":27,"notout":3,"runs":322,"balls":379,"highest":73,"run100":0,"run50":1,"run4":26,"run6":10,"average":"13.41","strike":"84.96","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":51,"innings":35,"notout":9,"runs":323,"balls":249,"highest":31,"run100":0,"run50":0,"run4":19,"run6":19,"average":"12.42","strike":"129.71","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":224,"innings":159,"notout":44,"runs":2040,"balls":1420,"highest":55,"run100":0,"run50":6,"run4":157,"run6":116,"average":"17.73","strike":"143.66","catches":77,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":95,"innings":74,"notout":9,"runs":1314,"balls":1464,"highest":88,"run100":0,"run50":7,"run4":111,"run6":45,"average":"20.21","strike":"89.75","catches":31,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":120,"notout":14,"runs":3174,"balls":5051,"highest":147,"run100":4,"run50":15,"run4":439,"run6":30,"average":"29.94","strike":"62.83","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"5","innings":"5","notout":"3","runs":"63","balls":"23","highest":"22","run100":"0","run50":"0","run4":"2","run6":"8","average":"31.50","strike":"273.91","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":17,"innings":31,"balls":1908,"overs":318,"runs":991,"wickets":25,"bestinning":"3\/42","bestmatch":"6\/99","econ":"3.11","average":"39.64","strike":"76.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":36,"balls":1498,"overs":249.4,"runs":1297,"wickets":28,"bestinning":"5\/22","bestmatch":"5\/22","econ":"5.19","average":"46.32","strike":"53.5","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":51,"innings":49,"balls":823,"overs":137.1,"runs":1048,"wickets":39,"bestinning":"3\/5","bestmatch":"3\/5","econ":"7.64","average":"26.87","strike":"21.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":224,"innings":219,"balls":4218,"overs":703,"runs":5861,"wickets":223,"bestinning":"6\/19","bestmatch":"6\/19","econ":"8.33","average":"26.28","strike":"18.9","wicket4i":3,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":95,"innings":94,"balls":4082,"overs":680.2,"runs":3603,"wickets":117,"bestinning":"5\/22","bestmatch":"5\/22","econ":"5.29","average":"30.79","strike":"34.8","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":137,"balls":11064,"overs":1844,"runs":5774,"wickets":183,"bestinning":"6\/65","bestmatch":"9\/115","econ":"3.13","average":"31.55","strike":"60.4","wicket4i":3,"wicket5i":7,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"5","innings":"5","balls":"36","overs":"6","runs":"120","wickets":"4","bestinning":"2\/50","bestmatch":"2\/50","econ":"20.00","average":"30.00","strike":"9.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"9f2cc5993a4e7446cf9d8414165cd596","modified":"2025-06-23 08:39:21","datetime":"2025-06-23 08:39:21","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53425 AND DataTypeId = 6 END Player profile of Faheem Ashraf, Pakistan
