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:d02eef0d-96b6-486b-9b91-6261c9851450 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 392 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (392,6,'{"status":"ok","response":{"player":{"pid":392,"title":"James Faulkner","short_name":"J Faulkner","first_name":"James Faulkner","last_name":"","middle_name":"","birthdate":"1990-04-29","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"notout":0,"runs":45,"balls":43,"highest":23,"run100":0,"run50":0,"run4":4,"run6":1,"average":"22.50","strike":"104.65","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":69,"innings":52,"notout":22,"runs":1032,"balls":990,"highest":116,"run100":1,"run50":4,"run4":83,"run6":29,"average":"34.40","strike":"104.24","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":18,"notout":7,"runs":159,"balls":138,"highest":41,"run100":0,"run50":0,"run4":7,"run6":5,"average":"14.45","strike":"115.21","catches":11,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":223,"innings":160,"notout":69,"runs":1953,"balls":1562,"highest":73,"run100":0,"run50":1,"run4":97,"run6":75,"average":"21.46","strike":"125.03","catches":69,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":128,"innings":100,"notout":32,"runs":2026,"balls":2257,"highest":116,"run100":1,"run50":10,"run4":145,"run6":49,"average":"29.79","strike":"89.76","catches":35,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":95,"notout":12,"runs":2566,"balls":5040,"highest":121,"run100":2,"run50":15,"run4":257,"run6":17,"average":"30.91","strike":"50.91","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"4","notout":"1","runs":"19","balls":"17","highest":"19","run100":"0","run50":"0","run4":"4","run6":"0","average":"6.33","strike":"111.76","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"balls":166,"overs":27.4,"runs":98,"wickets":6,"bestinning":"4\/51","bestmatch":"6\/98","econ":"3.54","average":"16.33","strike":"27.6","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":69,"innings":67,"balls":3211,"overs":535.1,"runs":2962,"wickets":96,"bestinning":"4\/32","bestmatch":"4\/32","econ":"5.53","average":"30.85","strike":"33.4","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":515,"overs":85.5,"runs":684,"wickets":36,"bestinning":"5\/27","bestmatch":"5\/27","econ":"7.96","average":"19.00","strike":"14.3","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":223,"innings":221,"balls":4517,"overs":752.5,"runs":5974,"wickets":262,"bestinning":"5\/16","bestmatch":"5\/16","econ":"7.93","average":"22.80","strike":"17.2","wicket4i":1,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":128,"innings":123,"balls":6041,"overs":1006.5,"runs":5367,"wickets":175,"bestinning":"4\/20","bestmatch":"4\/20","econ":"5.33","average":"30.66","strike":"34.5","wicket4i":8,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":116,"balls":9776,"overs":1629.2,"runs":4759,"wickets":192,"bestinning":"5\/5","bestmatch":"8\/97","econ":"2.92","average":"24.78","strike":"50.9","wicket4i":7,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"11","balls":"126","overs":"21","runs":"214","wickets":"11","bestinning":"0\/28","bestmatch":"","econ":"10.19","average":"19.45","strike":"11.45","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"e204adcf987197ae8afa6d0540117578","modified":"2025-06-11 12:34:28","datetime":"2025-06-11 12:34:28","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":392,"title":"James Faulkner","short_name":"J Faulkner","first_name":"James Faulkner","last_name":"","middle_name":"","birthdate":"1990-04-29","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"notout":0,"runs":45,"balls":43,"highest":23,"run100":0,"run50":0,"run4":4,"run6":1,"average":"22.50","strike":"104.65","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":69,"innings":52,"notout":22,"runs":1032,"balls":990,"highest":116,"run100":1,"run50":4,"run4":83,"run6":29,"average":"34.40","strike":"104.24","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":18,"notout":7,"runs":159,"balls":138,"highest":41,"run100":0,"run50":0,"run4":7,"run6":5,"average":"14.45","strike":"115.21","catches":11,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":223,"innings":160,"notout":69,"runs":1953,"balls":1562,"highest":73,"run100":0,"run50":1,"run4":97,"run6":75,"average":"21.46","strike":"125.03","catches":69,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":128,"innings":100,"notout":32,"runs":2026,"balls":2257,"highest":116,"run100":1,"run50":10,"run4":145,"run6":49,"average":"29.79","strike":"89.76","catches":35,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":95,"notout":12,"runs":2566,"balls":5040,"highest":121,"run100":2,"run50":15,"run4":257,"run6":17,"average":"30.91","strike":"50.91","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"4","notout":"1","runs":"19","balls":"17","highest":"19","run100":"0","run50":"0","run4":"4","run6":"0","average":"6.33","strike":"111.76","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"balls":166,"overs":27.4,"runs":98,"wickets":6,"bestinning":"4\/51","bestmatch":"6\/98","econ":"3.54","average":"16.33","strike":"27.6","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":69,"innings":67,"balls":3211,"overs":535.1,"runs":2962,"wickets":96,"bestinning":"4\/32","bestmatch":"4\/32","econ":"5.53","average":"30.85","strike":"33.4","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":515,"overs":85.5,"runs":684,"wickets":36,"bestinning":"5\/27","bestmatch":"5\/27","econ":"7.96","average":"19.00","strike":"14.3","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":223,"innings":221,"balls":4517,"overs":752.5,"runs":5974,"wickets":262,"bestinning":"5\/16","bestmatch":"5\/16","econ":"7.93","average":"22.80","strike":"17.2","wicket4i":1,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":128,"innings":123,"balls":6041,"overs":1006.5,"runs":5367,"wickets":175,"bestinning":"4\/20","bestmatch":"4\/20","econ":"5.33","average":"30.66","strike":"34.5","wicket4i":8,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":116,"balls":9776,"overs":1629.2,"runs":4759,"wickets":192,"bestinning":"5\/5","bestmatch":"8\/97","econ":"2.92","average":"24.78","strike":"50.9","wicket4i":7,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"11","balls":"126","overs":"21","runs":"214","wickets":"11","bestinning":"0\/28","bestmatch":"","econ":"10.19","average":"19.45","strike":"11.45","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"e204adcf987197ae8afa6d0540117578","modified":"2025-06-11 12:34:28","datetime":"2025-06-11 12:34:28","api_version":"3.0"}', Modified = GetDate() WHERE Id = 392 AND DataTypeId = 6 END
Player profile of James Faulkner, Australia
<>
CricDirect Cricket News, Results and Stats
 

James Faulkner

NationalityAustralia
RoleAll Rounder
Born29 Apr 1990 (35)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 1 2 - 45 23 22.50 43 104.65 - -
ODI 69 52 22 1032 116 34.40 990 104.24 1 4
T20I 24 18 7 159 41 14.45 138 115.21 - -
T20I 223 160 69 1953 73 21.46 1562 125.03 - 1
List A 128 100 32 2026 116 29.79 2257 89.76 1 10
1st Class 63 95 12 2566 121 30.91 5040 50.91 2 15

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 1 2 27.4 98 6 4/51 16.33 3.54 27.6 1 -
ODI 69 67 535.1 2962 96 4/32 30.85 5.53 33.4 4 -
T20i 24 24 85.5 684 36 5/27 19.00 7.96 14.3 - 1
T20 223 221 752.5 5974 262 5/16 22.80 7.93 17.2 1 3
List A 128 123 1006.5 5367 175 4/20 30.66 5.33 34.5 8 -
1st Class 63 116 1629.2 4759 192 5/5 24.78 2.92 50.9 7 5
× Close