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:a9310d1f-b938-40fc-96a5-31383bad4e96 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49320 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49320,6,'{"status":"ok","response":{"player":{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":85,"innings":15,"notout":9,"runs":20,"balls":40,"highest":5,"run100":0,"run50":0,"run4":1,"run6":0,"average":"3.33","strike":"50.00","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":87,"innings":38,"notout":19,"runs":215,"balls":256,"highest":38,"run100":0,"run50":0,"run4":16,"run6":5,"average":"11.31","strike":"83.98","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":232,"notout":79,"runs":1788,"balls":2859,"highest":57,"run100":0,"run50":1,"run4":250,"run6":14,"average":"11.68","strike":"62.53","catches":37,"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":{"t20":{"match_id":0,"inning_id":0,"matches":85,"innings":82,"balls":1623,"overs":270.3,"runs":2121,"wickets":78,"bestinning":"3\/14","bestmatch":"3\/14","econ":"7.84","average":"27.19","strike":"20.8","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":87,"innings":0,"balls":3959,"overs":659.5,"runs":3416,"wickets":140,"bestinning":"5\/31","bestmatch":"5\/31","econ":"5.17","average":"24.40","strike":"28.2","wicket4i":3,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":304,"balls":30831,"overs":5138.3,"runs":15198,"wickets":676,"bestinning":"9\/52","bestmatch":"15\/95","econ":"2.95","average":"22.48","strike":"45.6","wicket4i":26,"wicket5i":32,"wicket10m":6,"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":"7df371bd37c57e602ef56dc41b02967f","modified":"2025-07-14 00:21:54","datetime":"2025-07-14 00:21:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":85,"innings":15,"notout":9,"runs":20,"balls":40,"highest":5,"run100":0,"run50":0,"run4":1,"run6":0,"average":"3.33","strike":"50.00","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":87,"innings":38,"notout":19,"runs":215,"balls":256,"highest":38,"run100":0,"run50":0,"run4":16,"run6":5,"average":"11.31","strike":"83.98","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":232,"notout":79,"runs":1788,"balls":2859,"highest":57,"run100":0,"run50":1,"run4":250,"run6":14,"average":"11.68","strike":"62.53","catches":37,"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":{"t20":{"match_id":0,"inning_id":0,"matches":85,"innings":82,"balls":1623,"overs":270.3,"runs":2121,"wickets":78,"bestinning":"3\/14","bestmatch":"3\/14","econ":"7.84","average":"27.19","strike":"20.8","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":87,"innings":0,"balls":3959,"overs":659.5,"runs":3416,"wickets":140,"bestinning":"5\/31","bestmatch":"5\/31","econ":"5.17","average":"24.40","strike":"28.2","wicket4i":3,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":304,"balls":30831,"overs":5138.3,"runs":15198,"wickets":676,"bestinning":"9\/52","bestmatch":"15\/95","econ":"2.95","average":"22.48","strike":"45.6","wicket4i":26,"wicket5i":32,"wicket10m":6,"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":"7df371bd37c57e602ef56dc41b02967f","modified":"2025-07-14 00:21:54","datetime":"2025-07-14 00:21:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49320 AND DataTypeId = 6 END
Player profile of Chris Rushworth, England
CricDirect Cricket News, Results and Stats
 

Chris Rushworth

NationalityEngland
RoleBowler
Born11 Jul 1986 (39)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 85 15 9 20 5 3.33 40 50.00 - -
List A 87 38 19 215 38 11.31 256 83.98 - -
1st Class 176 232 79 1788 57 11.68 2859 62.53 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 85 82 270.3 2121 78 3/14 27.19 7.84 20.8 - -
List A 87 - 659.5 3416 140 5/31 24.40 5.17 28.2 3 2
1st Class 176 304 5138.3 15198 676 9/52 22.48 2.95 45.6 26 32
× Close