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:f43b712d-2891-4a9a-b485-062a5e8b6b58 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 46054 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (46054,6,'{"status":"ok","response":{"player":{"pid":46054,"title":"Thamsanqa Khumalo","short_name":"T Khumalo","first_name":"Thamsanqa Khumalo","last_name":"","middle_name":"","birthdate":"1999-09-23","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":15,"notout":1,"runs":142,"balls":161,"highest":33,"run100":0,"run50":0,"run4":17,"run6":1,"average":"10.14","strike":"88.19","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":20,"notout":0,"runs":496,"balls":615,"highest":71,"run100":0,"run50":5,"run4":63,"run6":7,"average":"24.80","strike":"80.65","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":22,"innings":36,"notout":0,"runs":809,"balls":1944,"highest":141,"run100":1,"run50":1,"run4":115,"run6":2,"average":"22.47","strike":"41.61","catches":8,"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":16,"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},"lista":{"match_id":0,"inning_id":0,"matches":20,"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},"firstclass":{"match_id":0,"inning_id":0,"matches":22,"innings":1,"balls":6,"overs":1,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","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":"b8429dedbba940bfaa3bff358ac7d6b6","modified":"2025-05-30 17:53:59","datetime":"2025-05-30 17:53:59","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":46054,"title":"Thamsanqa Khumalo","short_name":"T Khumalo","first_name":"Thamsanqa Khumalo","last_name":"","middle_name":"","birthdate":"1999-09-23","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":15,"notout":1,"runs":142,"balls":161,"highest":33,"run100":0,"run50":0,"run4":17,"run6":1,"average":"10.14","strike":"88.19","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":20,"notout":0,"runs":496,"balls":615,"highest":71,"run100":0,"run50":5,"run4":63,"run6":7,"average":"24.80","strike":"80.65","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":22,"innings":36,"notout":0,"runs":809,"balls":1944,"highest":141,"run100":1,"run50":1,"run4":115,"run6":2,"average":"22.47","strike":"41.61","catches":8,"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":16,"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},"lista":{"match_id":0,"inning_id":0,"matches":20,"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},"firstclass":{"match_id":0,"inning_id":0,"matches":22,"innings":1,"balls":6,"overs":1,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","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":"b8429dedbba940bfaa3bff358ac7d6b6","modified":"2025-05-30 17:53:59","datetime":"2025-05-30 17:53:59","api_version":"3.0"}', Modified = GetDate() WHERE Id = 46054 AND DataTypeId = 6 END
Player profile of Thamsanqa Khumalo, South Africa
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Unofficial Test

England LionsEngland Lions

India A*409/3 (90 ov)

 Stumps : Day 1 - England Lions elected to bowl
LIVEToday1st ODI

England WomenEngland Women345/6 (50 ov)

West Indies Women*146/4 (30 ov)

 West Indies Women need 200 runs in 20.0 remaining overs
LIVETodayEliminator

Gujarat TitansGujarat Titans*184/4 (17 ov)

Mumbai Indians228/5 (20 ov)

 Gujarat Titans need 45 runs in 18 remaining balls
LIVEToday2nd T20I

PakistanPakistan201/6 (20 ov)

Bangladesh*110/7 (13.5 ov)

 Bangladesh need 92 runs in 37 remaining balls
LIVETodayMatch 18

ACE KRM PanthersACE KRM Panthers*66/1 (5 ov)

Ai Octopus Challagers133/9 (20 ov)

 ACE KRM Panthers need 68 runs in 15.0 remaining overs
LIVETodayMatch 3

BelgiumBelgium162/10 (19.2 ov)

Portugal*30/0 (3.4 ov)

 Portugal need 133 runs in 16.2 remaining overs
LIVETodayMatch 5

LeicestershireLeicestershire

Derbyshire*29/3 (4.1 ov)

 Leicestershire elected to bowl
LIVETodayMatch 6

NottinghamshireNottinghamshire

Warwickshire*33/2 (4.1 ov)

 Nottinghamshire elected to bowl
LIVETodayMatch 7

SomersetSomerset

Surrey*29/2 (5.4 ov)

 Somerset elected to bowl
LIVETodayMatch 8

YorkshireYorkshire

Northamptonshire*61/0 (4.4 ov)

 Yorkshire elected to bowl
LIVETodayMatch 42

Emirates BluesEmirates Blues

Emirates Red

 
Cancelled30 May Match 29

DCA WayanadDCA Wayanad

Combined Districts

 Match Abandoned
Cancelled30 May Match 21

Royal EaglesRoyal Eagles

Cluj

 Match cancelled
Cancelled30 May Match 30

DCA KollamDCA Kollam

Ernakulam

 Match Abandoned
Cancelled30 May Match 22

United Cricket ClubUnited Cricket Club

Cluj

 Match cancelled
CancelledTodayMatch 23

Bucharest GladiatorsBucharest Gladiators

Royal Eagles

 Match cancelled
CancelledTodayMatch 24

Royal EaglesRoyal Eagles

Cluj

 Match cancelled
CancelledTodayMatch 25

Phoenix StrikersPhoenix Strikers

Bucharest Gladiators

 Match cancelled
CricDirect Cricket News, Results and Stats
 

Thamsanqa Khumalo

NationalitySouth Africa
RoleBatter
Born23 Sep 1999 (25)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 16 15 1 142 33 10.14 161 88.19 - -
List A 20 20 - 496 71 24.80 615 80.65 - 5
1st Class 22 36 - 809 141 22.47 1944 41.61 1 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 16 - - - - - - - - - -
List A 20 - - - - - - - - - -
1st Class 22 1 1 - - - - - - - -
× Close