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:c416ef7d-7548-444d-8c67-df2a08e294b2
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 482 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (482,6,'{"status":"ok","response":{"player":{"pid":482,"title":"Johnson Charles","short_name":"J Charles","first_name":"Johnson Charles","last_name":"","middle_name":"","birthdate":"1989-01-14","birthplace":"St Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"West Indies"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":58,"innings":58,"notout":0,"runs":1537,"balls":1803,"highest":130,"run100":2,"run50":7,"run4":172,"run6":44,"average":"26.50","strike":"85.24","catches":25,"stumpings":2,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":62,"notout":0,"runs":1433,"balls":1100,"highest":118,"run100":1,"run50":5,"run4":155,"run6":67,"average":"23.11","strike":"130.27","catches":23,"stumpings":2,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":300,"innings":294,"notout":12,"runs":7720,"balls":5758,"highest":119,"run100":4,"run50":45,"run4":736,"run6":386,"average":"27.37","strike":"134.07","catches":109,"stumpings":7,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":120,"notout":0,"runs":2921,"balls":0,"highest":177,"run100":3,"run50":13,"run4":0,"run6":0,"average":"24.34","strike":"","catches":50,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":35,"innings":65,"notout":6,"runs":1227,"balls":0,"highest":151,"run100":1,"run50":3,"run4":0,"run6":0,"average":"20.79","strike":"","catches":61,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"71","innings":"68","notout":"10","runs":"1716","balls":"858","highest":"91","run100":"0","run50":"13","run4":"174","run6":"122","average":"29.59","strike":"200.00","catches":"20","stumpings":"2"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":58,"innings":1,"balls":5,"overs":0.5,"runs":12,"wickets":0,"bestinning":"","bestmatch":"","econ":"14.40","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":300,"innings":5,"balls":43,"overs":7.1,"runs":69,"wickets":5,"bestinning":"1\/5","bestmatch":"1\/5","econ":"9.62","average":"13.80","strike":"8.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":6,"balls":131,"overs":21.5,"runs":165,"wickets":3,"bestinning":"1\/22","bestmatch":"1\/22","econ":"7.55","average":"55.00","strike":"43.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":35,"innings":9,"balls":240,"overs":40,"runs":167,"wickets":5,"bestinning":"2\/14","bestmatch":"2\/14","econ":"4.17","average":"33.40","strike":"48.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"71","innings":"9","balls":"90","overs":"15","runs":"159","wickets":"7","bestinning":"","bestmatch":"","econ":"10.60","average":"22.71","strike":"12.86","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"44b4edf509b41fececb2df83213e88f8","modified":"2025-06-26 05:57:44","datetime":"2025-06-26 05:57:44","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":482,"title":"Johnson Charles","short_name":"J Charles","first_name":"Johnson Charles","last_name":"","middle_name":"","birthdate":"1989-01-14","birthplace":"St Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"West Indies"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":58,"innings":58,"notout":0,"runs":1537,"balls":1803,"highest":130,"run100":2,"run50":7,"run4":172,"run6":44,"average":"26.50","strike":"85.24","catches":25,"stumpings":2,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":62,"notout":0,"runs":1433,"balls":1100,"highest":118,"run100":1,"run50":5,"run4":155,"run6":67,"average":"23.11","strike":"130.27","catches":23,"stumpings":2,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":300,"innings":294,"notout":12,"runs":7720,"balls":5758,"highest":119,"run100":4,"run50":45,"run4":736,"run6":386,"average":"27.37","strike":"134.07","catches":109,"stumpings":7,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":120,"notout":0,"runs":2921,"balls":0,"highest":177,"run100":3,"run50":13,"run4":0,"run6":0,"average":"24.34","strike":"","catches":50,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":35,"innings":65,"notout":6,"runs":1227,"balls":0,"highest":151,"run100":1,"run50":3,"run4":0,"run6":0,"average":"20.79","strike":"","catches":61,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"71","innings":"68","notout":"10","runs":"1716","balls":"858","highest":"91","run100":"0","run50":"13","run4":"174","run6":"122","average":"29.59","strike":"200.00","catches":"20","stumpings":"2"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":58,"innings":1,"balls":5,"overs":0.5,"runs":12,"wickets":0,"bestinning":"","bestmatch":"","econ":"14.40","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":300,"innings":5,"balls":43,"overs":7.1,"runs":69,"wickets":5,"bestinning":"1\/5","bestmatch":"1\/5","econ":"9.62","average":"13.80","strike":"8.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":6,"balls":131,"overs":21.5,"runs":165,"wickets":3,"bestinning":"1\/22","bestmatch":"1\/22","econ":"7.55","average":"55.00","strike":"43.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":35,"innings":9,"balls":240,"overs":40,"runs":167,"wickets":5,"bestinning":"2\/14","bestmatch":"2\/14","econ":"4.17","average":"33.40","strike":"48.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"71","innings":"9","balls":"90","overs":"15","runs":"159","wickets":"7","bestinning":"","bestmatch":"","econ":"10.60","average":"22.71","strike":"12.86","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"44b4edf509b41fececb2df83213e88f8","modified":"2025-06-26 05:57:44","datetime":"2025-06-26 05:57:44","api_version":"3.0"}', Modified = GetDate() WHERE Id = 482 AND DataTypeId = 6 END Player profile of Johnson Charles, West Indies
