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:2dd9396b-57ad-490c-a2e5-5d037e0c140c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 44171 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (44171,6,'{"status":"ok","response":{"player":{"pid":44171,"title":"Nkosana Mpofu","short_name":"N Mpofu","first_name":"Nkosana Mpofu","last_name":"","middle_name":"","birthdate":"1990-07-10","birthplace":"","country":"zw","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":"Zimbabwe"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":13,"innings":12,"notout":0,"runs":117,"balls":122,"highest":30,"run100":0,"run50":0,"run4":15,"run6":1,"average":"9.75","strike":"95.90","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":66,"notout":2,"runs":1575,"balls":2391,"highest":110,"run100":1,"run50":6,"run4":161,"run6":11,"average":"24.60","strike":"65.87","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":135,"notout":7,"runs":3505,"balls":8272,"highest":162,"run100":6,"run50":14,"run4":413,"run6":9,"average":"27.38","strike":"42.37","catches":43,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"7","notout":"0","runs":"95","balls":"83","highest":"31","run100":"0","run50":"0","run4":"12","run6":"2","average":"13.57","strike":"114.46","catches":"1","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":13,"innings":6,"balls":60,"overs":10,"runs":109,"wickets":3,"bestinning":"3\/28","bestmatch":"3\/28","econ":"10.90","average":"36.33","strike":"20.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":25,"balls":861,"overs":143.3,"runs":627,"wickets":31,"bestinning":"5\/47","bestmatch":"5\/47","econ":"4.36","average":"20.22","strike":"27.7","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":49,"balls":2453,"overs":408.5,"runs":1257,"wickets":30,"bestinning":"3\/12","bestmatch":"3\/30","econ":"3.07","average":"41.90","strike":"81.7","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":"597886b5458ee3a2d6495d84f96e2947","modified":"2025-06-20 21:02:16","datetime":"2025-06-20 21:02:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":44171,"title":"Nkosana Mpofu","short_name":"N Mpofu","first_name":"Nkosana Mpofu","last_name":"","middle_name":"","birthdate":"1990-07-10","birthplace":"","country":"zw","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":"Zimbabwe"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":13,"innings":12,"notout":0,"runs":117,"balls":122,"highest":30,"run100":0,"run50":0,"run4":15,"run6":1,"average":"9.75","strike":"95.90","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":66,"notout":2,"runs":1575,"balls":2391,"highest":110,"run100":1,"run50":6,"run4":161,"run6":11,"average":"24.60","strike":"65.87","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":135,"notout":7,"runs":3505,"balls":8272,"highest":162,"run100":6,"run50":14,"run4":413,"run6":9,"average":"27.38","strike":"42.37","catches":43,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"7","notout":"0","runs":"95","balls":"83","highest":"31","run100":"0","run50":"0","run4":"12","run6":"2","average":"13.57","strike":"114.46","catches":"1","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":13,"innings":6,"balls":60,"overs":10,"runs":109,"wickets":3,"bestinning":"3\/28","bestmatch":"3\/28","econ":"10.90","average":"36.33","strike":"20.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":25,"balls":861,"overs":143.3,"runs":627,"wickets":31,"bestinning":"5\/47","bestmatch":"5\/47","econ":"4.36","average":"20.22","strike":"27.7","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":75,"innings":49,"balls":2453,"overs":408.5,"runs":1257,"wickets":30,"bestinning":"3\/12","bestmatch":"3\/30","econ":"3.07","average":"41.90","strike":"81.7","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":"597886b5458ee3a2d6495d84f96e2947","modified":"2025-06-20 21:02:16","datetime":"2025-06-20 21:02:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 44171 AND DataTypeId = 6 END
Player profile of Nkosana Mpofu, Zimbabwe
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

Sri LankaSri Lanka485/10 (131.2 ov)

Bangladesh495/10 (153.4 ov) & *177/3 (57 ov)

 Stumps : Day 4 - Bangladesh lead by 187 runs.
LIVEToday1st Test

EnglandEngland

India*359/3 (85 ov)

 Stumps : Day 1 - England elected to bowl
LIVETodayMatch 71

WarwickshireWarwickshire*132/9 (18.5 ov)

Worcestershire134/10 (18.4 ov)

 Warwickshire need 3 runs in 7 remaining balls
LIVEToday1st T20I

West Indies WomenWest Indies Women*99/5 (16 ov)

South Africa Women183/6 (20 ov)

 West Indies Women need 85 runs in 24 remaining balls
LIVETodayMatch 8

YSSCYSSC76/10 (16.2 ov)

TGS*11/2 (2 ov)

 TGS need 66 runs in 18.0 remaining overs
LIVETodayMatch 30

Scarlet Ibis ScorchersScarlet Ibis Scorchers

Soca Kings

 Match delayed due to rain
CancelledTodayMatch 11

Diamond DazzlersDiamond Dazzlers10/1 (2 ov)

Alembic Warriors

 Match Abandoned
CancelledTodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players0/0 ( ov)

SAMP Army Cocrico Cavaliers

 Match Abandoned
Scheduled21 June Match 10

Texas Super KingsTexas Super Kings

San Francisco Unicorns

 
Scheduled21 June Match 13

Pakyong XIPakyong XI

Alpine Sporting Club

 
Scheduled21 June Match 19

Sobisco Smashers Malda WomensSobisco Smashers Malda Womens

Murshidabd Kueens Womens

 
Scheduled21 June Match 3

Chambal Ghariyals WomenChambal Ghariyals Women

Bhopal Wolves Women

 
Scheduled21 June Match 11

Prague Barbarians CCPrague Barbarians CC

United CC

 
Scheduled21 June Match 14

Royal North BrothersRoyal North Brothers

Cricket Associaton Of Tathangchen

 
Scheduled21 June Match 20

Servotech Siliguri StrikersServotech Siliguri Strikers

Harbour Diamonds

 
Scheduled21 June Match 20

Harbour Diamonds WomensHarbour Diamonds Womens

Servotech Siliguri Strikers Womens

 
Scheduled21 June Match 12

Prague CCPrague CC

Brno CC

 
Scheduled21 June Match 12

Diamond DazzlersDiamond Dazzlers

Pruthvi Panthers

 
CricDirect Cricket News, Results and Stats
 

Nkosana Mpofu

NationalityZimbabwe
RoleBatter
Born10 Jul 1990 (34)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 13 12 - 117 30 9.75 122 95.90 - -
List A 67 66 2 1575 110 24.60 2391 65.87 1 6
1st Class 75 135 7 3505 162 27.38 8272 42.37 6 14

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 13 6 10 109 3 3/28 36.33 10.90 20.0 - -
List A 67 25 143.3 627 31 5/47 20.22 4.36 27.7 1 1
1st Class 75 49 408.5 1257 30 3/12 41.90 3.07 81.7 - -
× Close