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:7a49c16b-1ae1-4c72-a437-3fa34e9a1bd1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 287 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (287,6,'{"status":"ok","response":{"player":{"pid":287,"title":"Kyle Coetzer","short_name":"K Coetzer","first_name":"Kyle Coetzer","last_name":"","middle_name":"","birthdate":"1984-04-14","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Scotland"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":89,"innings":87,"notout":5,"runs":3192,"balls":3875,"highest":156,"run100":5,"run50":21,"run4":412,"run6":40,"average":"38.92","strike":"82.37","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":70,"innings":68,"notout":2,"runs":1495,"balls":1254,"highest":89,"run100":0,"run50":6,"run4":158,"run6":48,"average":"22.65","strike":"119.21","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":134,"innings":127,"notout":9,"runs":2790,"balls":2446,"highest":89,"run100":0,"run50":11,"run4":288,"run6":66,"average":"23.64","strike":"114.06","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":192,"notout":19,"runs":6296,"balls":7807,"highest":156,"run100":11,"run50":38,"run4":0,"run6":0,"average":"36.39","strike":"80.64","catches":68,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":94,"innings":156,"notout":11,"runs":4404,"balls":9056,"highest":219,"run100":8,"run50":19,"run4":0,"run6":0,"average":"30.37","strike":"48.63","catches":46,"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":{"odi":{"match_id":0,"inning_id":0,"matches":89,"innings":10,"balls":270,"overs":45,"runs":253,"wickets":2,"bestinning":"1\/17","bestmatch":"1\/17","econ":"5.62","average":"126.50","strike":"135.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":70,"innings":5,"balls":66,"overs":11,"runs":71,"wickets":5,"bestinning":"3\/25","bestmatch":"3\/25","econ":"6.45","average":"14.20","strike":"13.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":134,"innings":15,"balls":156,"overs":26,"runs":202,"wickets":7,"bestinning":"3\/25","bestmatch":"3\/25","econ":"7.76","average":"28.85","strike":"22.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":0,"balls":516,"overs":86,"runs":508,"wickets":5,"bestinning":"1\/2","bestmatch":"1\/2","econ":"5.90","average":"101.60","strike":"103.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":94,"innings":0,"balls":678,"overs":113,"runs":414,"wickets":7,"bestinning":"2\/16","bestmatch":"2\/16","econ":"3.66","average":"59.14","strike":"96.8","wicket4i":0,"wicket5i":0,"wicket10m":0,"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":"b3252dec793c5eab5c722426ccf9c0c1","modified":"2025-07-20 04:43:48","datetime":"2025-07-20 04:43:48","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":287,"title":"Kyle Coetzer","short_name":"K Coetzer","first_name":"Kyle Coetzer","last_name":"","middle_name":"","birthdate":"1984-04-14","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Scotland"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":89,"innings":87,"notout":5,"runs":3192,"balls":3875,"highest":156,"run100":5,"run50":21,"run4":412,"run6":40,"average":"38.92","strike":"82.37","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":70,"innings":68,"notout":2,"runs":1495,"balls":1254,"highest":89,"run100":0,"run50":6,"run4":158,"run6":48,"average":"22.65","strike":"119.21","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":134,"innings":127,"notout":9,"runs":2790,"balls":2446,"highest":89,"run100":0,"run50":11,"run4":288,"run6":66,"average":"23.64","strike":"114.06","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":192,"notout":19,"runs":6296,"balls":7807,"highest":156,"run100":11,"run50":38,"run4":0,"run6":0,"average":"36.39","strike":"80.64","catches":68,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":94,"innings":156,"notout":11,"runs":4404,"balls":9056,"highest":219,"run100":8,"run50":19,"run4":0,"run6":0,"average":"30.37","strike":"48.63","catches":46,"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":{"odi":{"match_id":0,"inning_id":0,"matches":89,"innings":10,"balls":270,"overs":45,"runs":253,"wickets":2,"bestinning":"1\/17","bestmatch":"1\/17","econ":"5.62","average":"126.50","strike":"135.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":70,"innings":5,"balls":66,"overs":11,"runs":71,"wickets":5,"bestinning":"3\/25","bestmatch":"3\/25","econ":"6.45","average":"14.20","strike":"13.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":134,"innings":15,"balls":156,"overs":26,"runs":202,"wickets":7,"bestinning":"3\/25","bestmatch":"3\/25","econ":"7.76","average":"28.85","strike":"22.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":0,"balls":516,"overs":86,"runs":508,"wickets":5,"bestinning":"1\/2","bestmatch":"1\/2","econ":"5.90","average":"101.60","strike":"103.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":94,"innings":0,"balls":678,"overs":113,"runs":414,"wickets":7,"bestinning":"2\/16","bestmatch":"2\/16","econ":"3.66","average":"59.14","strike":"96.8","wicket4i":0,"wicket5i":0,"wicket10m":0,"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":"b3252dec793c5eab5c722426ccf9c0c1","modified":"2025-07-20 04:43:48","datetime":"2025-07-20 04:43:48","api_version":"3.0"}', Modified = GetDate() WHERE Id = 287 AND DataTypeId = 6 END
Player profile of Kyle Coetzer, Scotland
CricDirect Cricket News, Results and Stats
 

Kyle Coetzer

NationalityScotland
RoleBatter
Born14 Apr 1984 (41)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 89 87 5 3192 156 38.92 3875 82.37 5 21
T20I 70 68 2 1495 89 22.65 1254 119.21 - 6
T20I 134 127 9 2790 89 23.64 2446 114.06 - 11
List A 199 192 19 6296 156 36.39 7807 80.64 11 38
1st Class 94 156 11 4404 219 30.37 9056 48.63 8 19

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 89 10 45 253 2 1/17 126.50 5.62 135.0 - -
T20i 70 5 11 71 5 3/25 14.20 6.45 13.2 - -
T20 134 15 26 202 7 3/25 28.85 7.76 22.2 - -
List A 199 - 86 508 5 1/2 101.60 5.90 103.2 - -
1st Class 94 - 113 414 7 2/16 59.14 3.66 96.8 - -
× Close