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:727cd002-d2df-4b95-aae7-51dc1787d748 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49895 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49895,6,'{"status":"ok","response":{"player":{"pid":49895,"title":"Fazal Subhan","short_name":"Fazal Subhan","first_name":"Fazal Subhan","last_name":"","middle_name":"","birthdate":"1988-01-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":9,"innings":9,"notout":2,"runs":143,"balls":129,"highest":53,"run100":0,"run50":2,"run4":14,"run6":3,"average":"20.42","strike":"110.85","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":39,"innings":38,"notout":0,"runs":858,"balls":1068,"highest":102,"run100":1,"run50":6,"run4":84,"run6":15,"average":"22.57","strike":"80.33","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":40,"innings":71,"notout":1,"runs":2301,"balls":3970,"highest":207,"run100":5,"run50":11,"run4":310,"run6":10,"average":"32.87","strike":"57.95","catches":23,"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":9,"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":39,"innings":1,"balls":6,"overs":1,"runs":8,"wickets":0,"bestinning":"","bestmatch":"","econ":"8.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":40,"innings":6,"balls":99,"overs":16.3,"runs":74,"wickets":0,"bestinning":"","bestmatch":"","econ":"4.48","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":"0b19c2f34a3517d097ebdd84fe5d11db","modified":"2025-06-08 17:41:48","datetime":"2025-06-08 17:41:48","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49895,"title":"Fazal Subhan","short_name":"Fazal Subhan","first_name":"Fazal Subhan","last_name":"","middle_name":"","birthdate":"1988-01-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":9,"innings":9,"notout":2,"runs":143,"balls":129,"highest":53,"run100":0,"run50":2,"run4":14,"run6":3,"average":"20.42","strike":"110.85","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":39,"innings":38,"notout":0,"runs":858,"balls":1068,"highest":102,"run100":1,"run50":6,"run4":84,"run6":15,"average":"22.57","strike":"80.33","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":40,"innings":71,"notout":1,"runs":2301,"balls":3970,"highest":207,"run100":5,"run50":11,"run4":310,"run6":10,"average":"32.87","strike":"57.95","catches":23,"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":9,"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":39,"innings":1,"balls":6,"overs":1,"runs":8,"wickets":0,"bestinning":"","bestmatch":"","econ":"8.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":40,"innings":6,"balls":99,"overs":16.3,"runs":74,"wickets":0,"bestinning":"","bestmatch":"","econ":"4.48","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":"0b19c2f34a3517d097ebdd84fe5d11db","modified":"2025-06-08 17:41:48","datetime":"2025-06-08 17:41:48","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49895 AND DataTypeId = 6 END
Player profile of Fazal Subhan, Pakistan
<>
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

England LionsEngland Lions327/10 (89 ov)

India A348/10 (89.3 ov) & *137/3 (27.5 ov)

 Bad light : Day 3 - Session 3, India A lead by 158 runs.
LIVETodayMatch 77

ScotlandScotland323/6 (50 ov)

Nepal*319/8 (49.2 ov)

 Nepal need 5 runs in 4 remaining balls
LIVETodayMatch 7

Ratnagiri JetsRatnagiri Jets160/5 (18.0 ov)

Satara Warriors159/8 (20 ov)

 Ratnagiri Jets won by 5 wickets
LIVETodayMatch 5

South Africa ASouth Africa A

West Indies A

 Not Covered Live
LIVETodayMatch 3

Anmol Kings HalarAnmol Kings Halar*125/10 (20 ov)

Dita Gohilwad Titans137/10 (19.5 ov)

 Match completed
LIVETodayMatch 7

NECO Master BlasterNECO Master Blaster199/6 (20 ov)

Nagpur Heroz*163/4 (16.4 ov)

 Nagpur Heroz need 37 runs in 20 remaining balls
LIVETodayMatch 16

NevisNevis144/9 (20 ov)

Combined Islands*41/4 (10.3 ov)

 Combined Islands need 104 runs in 57 remaining balls
LIVETodayMatch 32

SussexSussex195/4 (20 ov)

Glamorgan*117/8 (15 ov)

 Glamorgan need 79 runs in 30 remaining balls
LIVETodayMatch 36

WarwickshireWarwickshire199/6 (20 ov)

Derbyshire*135/5 (15.2 ov)

 Derbyshire need 65 runs in 28 remaining balls
LIVETodayMatch 25

GATGAT*23/1 (1.5 ov)

SBS CC

 SBS CC elected to bowl
Scheduled08 June Match 17

Antigua and BarbudaAntigua and Barbuda

Anguilla

 
Scheduled09 June Match 8

Kolhapur TuskersKolhapur Tuskers

Eagle Nashik Titans

 
Scheduled09 June Match 3

AustriaAustria

Norway

 
Scheduled09 June Match 7

Ratnagiri Jets WomenRatnagiri Jets Women

Solapur Smashers Women

 
Scheduled09 June Match 26

GaganGagan

Old Brentwoods

 
Scheduled09 June Match 8

Nagpur HerozNagpur Heroz

Pagariya Strikers

 
Scheduled09 June Match 4

Aryan Sorath LionsAryan Sorath Lions

JMD Kutch Riders

 
Scheduled09 June Match 2

Netherlands WomenNetherlands Women

United States of America Women

 
CricDirect Cricket News, Results and Stats
 

Fazal Subhan

NationalityPakistan
RoleBatter
Born01 Jan 1988 (37)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 9 9 2 143 53 20.42 129 110.85 - 2
List A 39 38 - 858 102 22.57 1068 80.33 1 6
1st Class 40 71 1 2301 207 32.87 3970 57.95 5 11

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 9 - - - - - - - - - -
List A 39 1 1 8 - - - 8.00 - - -
1st Class 40 6 16.3 74 - - - 4.48 - - -
× Close