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:3a0be7f8-defb-46b0-a9ac-c76e26540082 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 47585 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (47585,6,'{"status":"ok","response":{"player":{"pid":47585,"title":"Ferisco Adams","short_name":"FD Adams","first_name":"Ferisco Adams","last_name":"","middle_name":"","birthdate":"1989-07-12","birthplace":"Robertson, Western Cape","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":74,"notout":19,"runs":1072,"balls":911,"highest":80,"run100":0,"run50":2,"run4":69,"run6":34,"average":"19.49","strike":"117.67","catches":24,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":69,"innings":55,"notout":8,"runs":1122,"balls":1320,"highest":83,"run100":0,"run50":7,"run4":77,"run6":21,"average":"23.87","strike":"85.00","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":50,"innings":79,"notout":3,"runs":2361,"balls":3441,"highest":149,"run100":6,"run50":9,"run4":301,"run6":30,"average":"31.06","strike":"68.61","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"9","notout":"1","runs":"151","balls":"99","highest":"32","run100":"0","run50":"0","run4":"13","run6":"5","average":"18.88","strike":"152.53","catches":"2","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":98,"balls":1781,"overs":296.5,"runs":2372,"wickets":91,"bestinning":"5\/23","bestmatch":"5\/23","econ":"7.99","average":"26.06","strike":"19.5","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":69,"innings":57,"balls":2251,"overs":375.1,"runs":2002,"wickets":74,"bestinning":"4\/23","bestmatch":"4\/23","econ":"5.33","average":"27.05","strike":"30.4","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":50,"innings":79,"balls":5645,"overs":940.5,"runs":3117,"wickets":119,"bestinning":"6\/42","bestmatch":"10\/114","econ":"3.31","average":"26.19","strike":"47.4","wicket4i":6,"wicket5i":5,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"8","balls":"81","overs":"13.3","runs":"113","wickets":"7","bestinning":"2\/5","bestmatch":"2\/5","econ":"8.37","average":"16.14","strike":"11.57","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"2c19d7f7c2a383e02c71d6120c2f7b4a","modified":"2025-07-22 19:09:42","datetime":"2025-07-22 19:09:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":47585,"title":"Ferisco Adams","short_name":"FD Adams","first_name":"Ferisco Adams","last_name":"","middle_name":"","birthdate":"1989-07-12","birthplace":"Robertson, Western Cape","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":74,"notout":19,"runs":1072,"balls":911,"highest":80,"run100":0,"run50":2,"run4":69,"run6":34,"average":"19.49","strike":"117.67","catches":24,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":69,"innings":55,"notout":8,"runs":1122,"balls":1320,"highest":83,"run100":0,"run50":7,"run4":77,"run6":21,"average":"23.87","strike":"85.00","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":50,"innings":79,"notout":3,"runs":2361,"balls":3441,"highest":149,"run100":6,"run50":9,"run4":301,"run6":30,"average":"31.06","strike":"68.61","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"9","notout":"1","runs":"151","balls":"99","highest":"32","run100":"0","run50":"0","run4":"13","run6":"5","average":"18.88","strike":"152.53","catches":"2","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":98,"balls":1781,"overs":296.5,"runs":2372,"wickets":91,"bestinning":"5\/23","bestmatch":"5\/23","econ":"7.99","average":"26.06","strike":"19.5","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":69,"innings":57,"balls":2251,"overs":375.1,"runs":2002,"wickets":74,"bestinning":"4\/23","bestmatch":"4\/23","econ":"5.33","average":"27.05","strike":"30.4","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":50,"innings":79,"balls":5645,"overs":940.5,"runs":3117,"wickets":119,"bestinning":"6\/42","bestmatch":"10\/114","econ":"3.31","average":"26.19","strike":"47.4","wicket4i":6,"wicket5i":5,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"8","balls":"81","overs":"13.3","runs":"113","wickets":"7","bestinning":"2\/5","bestmatch":"2\/5","econ":"8.37","average":"16.14","strike":"11.57","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"2c19d7f7c2a383e02c71d6120c2f7b4a","modified":"2025-07-22 19:09:42","datetime":"2025-07-22 19:09:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 47585 AND DataTypeId = 6 END
Player profile of Ferisco Adams, South Africa
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday2nd Unofficial Test

Australia AAustralia A*379/3 (103 ov)

Sri Lanka A485/6d (157 ov)

 Stumps : Day 3 - Australia A trail by 106 runs.
LIVEToday2nd Youth Test

England Under-19sEngland Under-19s309/10 (81.3 ov) & *93/0 (25 ov)

India Under-19s279/10 (58.1 ov)

 Stumps : Day 3 - Session 3, England Under-19s lead by 123 runs.
LIVEToday47th Match

HampshireHampshire

Nottinghamshire*242/5 (62.1 ov)

 Stumps : Day 1 - Hampshire elected to bowl
LIVEToday46th Match

SomersetSomerset250/10 (49.3 ov)

Durham145/10 (30.1 ov) & *5/2 (3 ov)

 Stumps : Day 1 - Durham trail by 100 runs.
LIVEToday48th Match

SussexSussex204/10 (52.4 ov)

Essex*152/4 (43 ov)

 Stumps : Day 1 - Essex trail by 52 runs.
LIVEToday50th Match

WarwickshireWarwickshire

Worcestershire*262/8 (93 ov)

 Stumps : Day 1 - Worcestershire elected to bat
LIVEToday49th Match

YorkshireYorkshire*282/4 (86 ov)

Surrey

 Day 1 - Yorkshire elected to bat
LIVEToday39th Match

DerbyshireDerbyshire

Leicestershire*357/3 (96 ov)

 Stumps : Day 1 - Leicestershire elected to bat
LIVEToday37th Match

GlamorganGlamorgan*125/4 (42 ov)

Kent155/9 (53.2 ov)

 Stumps : Day 1 - Glamorgan trail by 30 runs.
LIVEToday40th Match

GloucestershireGloucestershire

Lancashire*290/6 (91 ov)

 Stumps : Day 1 - Lancashire elected to bat
LIVEToday38th Match

MiddlesexMiddlesex*319/1 (80 ov)

Northamptonshire

 Day 1 - Northamptonshire elected to bowl
LIVEToday3rd ODI

England WomenEngland Women*266/6 (46 ov)

India Women318/5 (50 ov)

 England Women need 53 runs in 24 remaining balls
LIVETodayMatch 6

India ChampionsIndia Champions*92/8 (14.5 ov)

South Africa Champions208/6 (20 ov)

 India Champions need 117 runs in 31 remaining balls
LIVETodayMatch 22

Royal Lions CCRoyal Lions CC*23/1 (2.2 ov)

ACE KRM Panthers260/6 (20 ov)

 Royal Lions CC need 238 runs in 17.4 remaining overs
CancelledTodayMatch 30

Karaikal KniightsKaraikal Kniights

Villianur Mohit Kings60/0 (7.3 ov)

 Match Abandoned
CancelledTodayMatch 24

Florida LionsFlorida Lions0/0 ( ov)

Miami Blaze

 Match Abandoned
CancelledTodayMatch 25

Caribbean TigersCaribbean Tigers

Cayman Bay Stingrays

 Match Abandoned
CancelledTodayMatch 26

Grand Cayman FalconsGrand Cayman Falcons

Boca Raton Trailblazers

 Match Abandoned
CricDirect Cricket News, Results and Stats
 

Ferisco Adams

NationalitySouth Africa
RoleAll Rounder
Born12 Jul 1989 (36)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 106 74 19 1072 80 19.49 911 117.67 - 2
List A 69 55 8 1122 83 23.87 1320 85.00 - 7
1st Class 50 79 3 2361 149 31.06 3441 68.61 6 9

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 106 98 296.5 2372 91 5/23 26.06 7.99 19.5 - 1
List A 69 57 375.1 2002 74 4/23 27.05 5.33 30.4 4 -
1st Class 50 79 940.5 3117 119 6/42 26.19 3.31 47.4 6 5
× Close