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:6a86108d-9052-4313-9256-08579765d88c
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 151 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (151,6,'{"status":"ok","response":{"player":{"pid":151,"title":"Wahab Riaz","short_name":"W Riaz","first_name":"Wahab Riaz","last_name":"","middle_name":"","birthdate":"1985-06-28","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/wahabviki\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":27,"innings":41,"notout":5,"runs":306,"balls":727,"highest":39,"run100":0,"run50":0,"run4":32,"run6":5,"average":"8.50","strike":"42.09","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":91,"innings":66,"notout":15,"runs":740,"balls":849,"highest":54,"run100":0,"run50":3,"run4":55,"run6":30,"average":"14.50","strike":"87.16","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":36,"innings":18,"notout":6,"runs":154,"balls":123,"highest":30,"run100":0,"run50":0,"run4":10,"run6":7,"average":"12.83","strike":"125.20","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":348,"innings":203,"notout":77,"runs":1700,"balls":1308,"highest":53,"run100":0,"run50":1,"run4":127,"run6":74,"average":"13.49","strike":"129.96","catches":101,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":191,"innings":129,"notout":39,"runs":1470,"balls":1778,"highest":77,"run100":0,"run50":5,"run4":0,"run6":0,"average":"16.33","strike":"82.67","catches":59,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":136,"innings":193,"notout":31,"runs":2675,"balls":0,"highest":84,"run100":0,"run50":10,"run4":0,"run6":0,"average":"16.51","strike":"","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"40","innings":"9","notout":"4","runs":"58","balls":"36","highest":"37","run100":"0","run50":"0","run4":"2","run6":"6","average":"11.60","strike":"161.11","catches":"11","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":27,"innings":49,"balls":5018,"overs":836.2,"runs":2864,"wickets":83,"bestinning":"5\/63","bestmatch":"7\/134","econ":"3.42","average":"34.50","strike":"60.4","wicket4i":3,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":91,"innings":90,"balls":4327,"overs":721.1,"runs":4117,"wickets":120,"bestinning":"5\/46","bestmatch":"5\/46","econ":"5.70","average":"34.30","strike":"36.0","wicket4i":5,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":36,"innings":35,"balls":710,"overs":118.2,"runs":971,"wickets":34,"bestinning":"3\/18","bestmatch":"3\/18","econ":"8.20","average":"28.55","strike":"20.8","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":348,"innings":344,"balls":7433,"overs":1238.5,"runs":9350,"wickets":413,"bestinning":"5\/8","bestmatch":"5\/8","econ":"7.54","average":"22.63","strike":"17.9","wicket4i":5,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":191,"innings":0,"balls":8917,"overs":1486.1,"runs":8011,"wickets":260,"bestinning":"5\/24","bestmatch":"5\/24","econ":"5.39","average":"30.81","strike":"34.2","wicket4i":11,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":136,"innings":0,"balls":23328,"overs":3888,"runs":12849,"wickets":441,"bestinning":"9\/59","bestmatch":"","econ":"3.30","average":"29.13","strike":"52.8","wicket4i":23,"wicket5i":16,"wicket10m":5,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"40","innings":"33","balls":"354","overs":"59","runs":"636","wickets":"27","bestinning":"0\/26","bestmatch":"","econ":"10.78","average":"23.56","strike":"13.11","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"9ef4fa897a434a9541f22883854f6b98","modified":"2025-06-26 09:34:55","datetime":"2025-06-26 09:34:55","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":151,"title":"Wahab Riaz","short_name":"W Riaz","first_name":"Wahab Riaz","last_name":"","middle_name":"","birthdate":"1985-06-28","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/wahabviki\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":27,"innings":41,"notout":5,"runs":306,"balls":727,"highest":39,"run100":0,"run50":0,"run4":32,"run6":5,"average":"8.50","strike":"42.09","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":91,"innings":66,"notout":15,"runs":740,"balls":849,"highest":54,"run100":0,"run50":3,"run4":55,"run6":30,"average":"14.50","strike":"87.16","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":36,"innings":18,"notout":6,"runs":154,"balls":123,"highest":30,"run100":0,"run50":0,"run4":10,"run6":7,"average":"12.83","strike":"125.20","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":348,"innings":203,"notout":77,"runs":1700,"balls":1308,"highest":53,"run100":0,"run50":1,"run4":127,"run6":74,"average":"13.49","strike":"129.96","catches":101,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":191,"innings":129,"notout":39,"runs":1470,"balls":1778,"highest":77,"run100":0,"run50":5,"run4":0,"run6":0,"average":"16.33","strike":"82.67","catches":59,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":136,"innings":193,"notout":31,"runs":2675,"balls":0,"highest":84,"run100":0,"run50":10,"run4":0,"run6":0,"average":"16.51","strike":"","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"40","innings":"9","notout":"4","runs":"58","balls":"36","highest":"37","run100":"0","run50":"0","run4":"2","run6":"6","average":"11.60","strike":"161.11","catches":"11","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":27,"innings":49,"balls":5018,"overs":836.2,"runs":2864,"wickets":83,"bestinning":"5\/63","bestmatch":"7\/134","econ":"3.42","average":"34.50","strike":"60.4","wicket4i":3,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":91,"innings":90,"balls":4327,"overs":721.1,"runs":4117,"wickets":120,"bestinning":"5\/46","bestmatch":"5\/46","econ":"5.70","average":"34.30","strike":"36.0","wicket4i":5,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":36,"innings":35,"balls":710,"overs":118.2,"runs":971,"wickets":34,"bestinning":"3\/18","bestmatch":"3\/18","econ":"8.20","average":"28.55","strike":"20.8","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":348,"innings":344,"balls":7433,"overs":1238.5,"runs":9350,"wickets":413,"bestinning":"5\/8","bestmatch":"5\/8","econ":"7.54","average":"22.63","strike":"17.9","wicket4i":5,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":191,"innings":0,"balls":8917,"overs":1486.1,"runs":8011,"wickets":260,"bestinning":"5\/24","bestmatch":"5\/24","econ":"5.39","average":"30.81","strike":"34.2","wicket4i":11,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":136,"innings":0,"balls":23328,"overs":3888,"runs":12849,"wickets":441,"bestinning":"9\/59","bestmatch":"","econ":"3.30","average":"29.13","strike":"52.8","wicket4i":23,"wicket5i":16,"wicket10m":5,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"40","innings":"33","balls":"354","overs":"59","runs":"636","wickets":"27","bestinning":"0\/26","bestmatch":"","econ":"10.78","average":"23.56","strike":"13.11","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"9ef4fa897a434a9541f22883854f6b98","modified":"2025-06-26 09:34:55","datetime":"2025-06-26 09:34:55","api_version":"3.0"}', Modified = GetDate() WHERE Id = 151 AND DataTypeId = 6 END Player profile of Wahab Riaz, Pakistan
