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:4fde4bbc-136b-4450-ad50-9aab3726ae16 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1708 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1708,6,'{"status":"ok","response":{"player":{"pid":1708,"title":"Mark Chapman","short_name":"M Chapman","first_name":"Mark Chapman","last_name":"","middle_name":"","birthdate":"1994-06-27","birthplace":"Hong Kong","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/markschapman8\/","twitter_profile":"https:\/\/twitter.com\/markchapman08","instagram_profile":"https:\/\/www.instagram.com\/markchapman8\/","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":30,"innings":26,"notout":4,"runs":868,"balls":811,"highest":132,"run100":3,"run50":3,"run4":78,"run6":30,"average":"39.45","strike":"107.02","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":86,"innings":77,"notout":14,"runs":1739,"balls":1299,"highest":104,"run100":1,"run50":9,"run4":149,"run6":66,"average":"27.60","strike":"133.87","catches":31,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":185,"innings":165,"notout":26,"runs":3696,"balls":2741,"highest":104,"run100":2,"run50":22,"run4":321,"run6":136,"average":"26.58","strike":"134.84","catches":67,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":83,"notout":11,"runs":3190,"balls":3270,"highest":157,"run100":8,"run50":17,"run4":301,"run6":79,"average":"44.30","strike":"97.55","catches":35,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":46,"innings":80,"notout":8,"runs":3259,"balls":5170,"highest":276,"run100":7,"run50":17,"run4":423,"run6":43,"average":"45.26","strike":"63.03","catches":39,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"7","notout":"2","runs":"136","balls":"78","highest":"38","run100":"0","run50":"0","run4":"12","run6":"6","average":"27.20","strike":"174.36","catches":"2","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":30,"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},"t20i":{"match_id":0,"inning_id":0,"matches":86,"innings":7,"balls":84,"overs":14,"runs":99,"wickets":4,"bestinning":"1\/9","bestmatch":"1\/9","econ":"7.07","average":"24.75","strike":"21.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":185,"innings":39,"balls":491,"overs":81.5,"runs":652,"wickets":22,"bestinning":"3\/22","bestmatch":"3\/22","econ":"7.96","average":"29.63","strike":"22.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":26,"balls":611,"overs":101.5,"runs":650,"wickets":14,"bestinning":"3\/41","bestmatch":"3\/41","econ":"6.38","average":"46.42","strike":"43.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":46,"innings":12,"balls":366,"overs":61,"runs":246,"wickets":1,"bestinning":"1\/60","bestmatch":"1\/105","econ":"4.03","average":"246.00","strike":"366.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"d5d749f3ee1e591b47690bde0396a888","modified":"2025-06-19 12:59:24","datetime":"2025-06-19 12:59:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1708,"title":"Mark Chapman","short_name":"M Chapman","first_name":"Mark Chapman","last_name":"","middle_name":"","birthdate":"1994-06-27","birthplace":"Hong Kong","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/markschapman8\/","twitter_profile":"https:\/\/twitter.com\/markchapman08","instagram_profile":"https:\/\/www.instagram.com\/markchapman8\/","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":30,"innings":26,"notout":4,"runs":868,"balls":811,"highest":132,"run100":3,"run50":3,"run4":78,"run6":30,"average":"39.45","strike":"107.02","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":86,"innings":77,"notout":14,"runs":1739,"balls":1299,"highest":104,"run100":1,"run50":9,"run4":149,"run6":66,"average":"27.60","strike":"133.87","catches":31,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":185,"innings":165,"notout":26,"runs":3696,"balls":2741,"highest":104,"run100":2,"run50":22,"run4":321,"run6":136,"average":"26.58","strike":"134.84","catches":67,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":83,"notout":11,"runs":3190,"balls":3270,"highest":157,"run100":8,"run50":17,"run4":301,"run6":79,"average":"44.30","strike":"97.55","catches":35,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":46,"innings":80,"notout":8,"runs":3259,"balls":5170,"highest":276,"run100":7,"run50":17,"run4":423,"run6":43,"average":"45.26","strike":"63.03","catches":39,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"7","notout":"2","runs":"136","balls":"78","highest":"38","run100":"0","run50":"0","run4":"12","run6":"6","average":"27.20","strike":"174.36","catches":"2","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":30,"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},"t20i":{"match_id":0,"inning_id":0,"matches":86,"innings":7,"balls":84,"overs":14,"runs":99,"wickets":4,"bestinning":"1\/9","bestmatch":"1\/9","econ":"7.07","average":"24.75","strike":"21.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":185,"innings":39,"balls":491,"overs":81.5,"runs":652,"wickets":22,"bestinning":"3\/22","bestmatch":"3\/22","econ":"7.96","average":"29.63","strike":"22.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":26,"balls":611,"overs":101.5,"runs":650,"wickets":14,"bestinning":"3\/41","bestmatch":"3\/41","econ":"6.38","average":"46.42","strike":"43.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":46,"innings":12,"balls":366,"overs":61,"runs":246,"wickets":1,"bestinning":"1\/60","bestmatch":"1\/105","econ":"4.03","average":"246.00","strike":"366.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"d5d749f3ee1e591b47690bde0396a888","modified":"2025-06-19 12:59:24","datetime":"2025-06-19 12:59:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1708 AND DataTypeId = 6 END
Player profile of Mark Chapman, New Zealand
CricDirect Cricket News, Results and Stats
 

Mark Chapman

NationalityNew Zealand
RoleBatter
Born27 Jun 1994 (30)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 30 26 4 868 132 39.45 811 107.02 3 3
T20I 86 77 14 1739 104 27.60 1299 133.87 1 9
T20I 185 165 26 3696 104 26.58 2741 134.84 2 22
List A 90 83 11 3190 157 44.30 3270 97.55 8 17
1st Class 46 80 8 3259 276 45.26 5170 63.03 7 17

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 30 - - - - - - - - - -
T20i 86 7 14 99 4 1/9 24.75 7.07 21.0 - -
T20 185 39 81.5 652 22 3/22 29.63 7.96 22.3 - -
List A 90 26 101.5 650 14 3/41 46.42 6.38 43.6 - -
1st Class 46 12 61 246 1 1/60 246.00 4.03 366.0 - -
× Close