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:df683547-d14a-40f3-8a4b-8d89d93a6059
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 275 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (275,6,'{"status":"ok","response":{"player":{"pid":275,"title":"Jerome Taylor","short_name":"J Taylor","first_name":"Jerome Taylor","last_name":"","middle_name":"","birthdate":"1984-06-22","birthplace":" St Elizabeth, Jamaica","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":23993,"recent_appearance":1514512800,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jerometaylor75","instagram_profile":"https:\/\/www.instagram.com\/jeromemarktaylor\/","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":46,"innings":73,"notout":7,"runs":856,"balls":1368,"highest":106,"run100":1,"run50":1,"run4":116,"run6":19,"average":"12.96","strike":"62.57","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":90,"innings":42,"notout":9,"runs":278,"balls":323,"highest":43,"run100":0,"run50":0,"run4":31,"run6":5,"average":"8.42","strike":"86.06","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":30,"innings":15,"notout":6,"runs":118,"balls":92,"highest":21,"run100":0,"run50":0,"run4":10,"run6":6,"average":"13.11","strike":"128.26","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":46,"notout":23,"runs":266,"balls":220,"highest":21,"run100":0,"run50":0,"run4":21,"run6":13,"average":"11.56","strike":"120.90","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":135,"innings":68,"notout":17,"runs":518,"balls":0,"highest":43,"run100":0,"run50":0,"run4":0,"run6":0,"average":"10.15","strike":"","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":103,"innings":161,"notout":25,"runs":1595,"balls":0,"highest":106,"run100":1,"run50":1,"run4":0,"run6":0,"average":"11.72","strike":"","catches":25,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"10","innings":"0","notout":"0","runs":"0","balls":"0","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"","strike":"","catches":"1","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":46,"innings":78,"balls":7757,"overs":1292.5,"runs":4480,"wickets":130,"bestinning":"6\/47","bestmatch":"9\/95","econ":"3.46","average":"34.46","strike":"59.6","wicket4i":5,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":90,"innings":88,"balls":4341,"overs":723.3,"runs":3780,"wickets":128,"bestinning":"5\/48","bestmatch":"5\/48","econ":"5.22","average":"29.53","strike":"33.9","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":30,"innings":30,"balls":600,"overs":100,"runs":863,"wickets":33,"bestinning":"3\/6","bestmatch":"3\/6","econ":"8.63","average":"26.15","strike":"18.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":119,"balls":2520,"overs":420,"runs":3585,"wickets":140,"bestinning":"5\/10","bestmatch":"5\/10","econ":"8.53","average":"25.60","strike":"18.0","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":135,"innings":0,"balls":6431,"overs":1071.5,"runs":5414,"wickets":203,"bestinning":"5\/40","bestmatch":"5\/40","econ":"5.05","average":"26.66","strike":"31.6","wicket4i":5,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":103,"innings":0,"balls":15824,"overs":2637.2,"runs":8401,"wickets":326,"bestinning":"8\/59","bestmatch":"","econ":"3.18","average":"25.76","strike":"48.5","wicket4i":12,"wicket5i":16,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"10","innings":"9","balls":"102","overs":"17","runs":"177","wickets":"8","bestinning":"2\/20","bestmatch":"2\/20","econ":"10.41","average":"22.13","strike":"12.75","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"9acb997c94be338901642576d8b26545","modified":"2025-06-23 19:01:13","datetime":"2025-06-23 19:01:13","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":275,"title":"Jerome Taylor","short_name":"J Taylor","first_name":"Jerome Taylor","last_name":"","middle_name":"","birthdate":"1984-06-22","birthplace":" St Elizabeth, Jamaica","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":23993,"recent_appearance":1514512800,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jerometaylor75","instagram_profile":"https:\/\/www.instagram.com\/jeromemarktaylor\/","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":46,"innings":73,"notout":7,"runs":856,"balls":1368,"highest":106,"run100":1,"run50":1,"run4":116,"run6":19,"average":"12.96","strike":"62.57","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":90,"innings":42,"notout":9,"runs":278,"balls":323,"highest":43,"run100":0,"run50":0,"run4":31,"run6":5,"average":"8.42","strike":"86.06","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":30,"innings":15,"notout":6,"runs":118,"balls":92,"highest":21,"run100":0,"run50":0,"run4":10,"run6":6,"average":"13.11","strike":"128.26","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":46,"notout":23,"runs":266,"balls":220,"highest":21,"run100":0,"run50":0,"run4":21,"run6":13,"average":"11.56","strike":"120.90","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":135,"innings":68,"notout":17,"runs":518,"balls":0,"highest":43,"run100":0,"run50":0,"run4":0,"run6":0,"average":"10.15","strike":"","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":103,"innings":161,"notout":25,"runs":1595,"balls":0,"highest":106,"run100":1,"run50":1,"run4":0,"run6":0,"average":"11.72","strike":"","catches":25,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"10","innings":"0","notout":"0","runs":"0","balls":"0","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"","strike":"","catches":"1","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":46,"innings":78,"balls":7757,"overs":1292.5,"runs":4480,"wickets":130,"bestinning":"6\/47","bestmatch":"9\/95","econ":"3.46","average":"34.46","strike":"59.6","wicket4i":5,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":90,"innings":88,"balls":4341,"overs":723.3,"runs":3780,"wickets":128,"bestinning":"5\/48","bestmatch":"5\/48","econ":"5.22","average":"29.53","strike":"33.9","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":30,"innings":30,"balls":600,"overs":100,"runs":863,"wickets":33,"bestinning":"3\/6","bestmatch":"3\/6","econ":"8.63","average":"26.15","strike":"18.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":119,"balls":2520,"overs":420,"runs":3585,"wickets":140,"bestinning":"5\/10","bestmatch":"5\/10","econ":"8.53","average":"25.60","strike":"18.0","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":135,"innings":0,"balls":6431,"overs":1071.5,"runs":5414,"wickets":203,"bestinning":"5\/40","bestmatch":"5\/40","econ":"5.05","average":"26.66","strike":"31.6","wicket4i":5,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":103,"innings":0,"balls":15824,"overs":2637.2,"runs":8401,"wickets":326,"bestinning":"8\/59","bestmatch":"","econ":"3.18","average":"25.76","strike":"48.5","wicket4i":12,"wicket5i":16,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"10","innings":"9","balls":"102","overs":"17","runs":"177","wickets":"8","bestinning":"2\/20","bestmatch":"2\/20","econ":"10.41","average":"22.13","strike":"12.75","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"9acb997c94be338901642576d8b26545","modified":"2025-06-23 19:01:13","datetime":"2025-06-23 19:01:13","api_version":"3.0"}', Modified = GetDate() WHERE Id = 275 AND DataTypeId = 6 END Player profile of Jerome Taylor, West Indies
