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:f80bda5c-6cec-4e98-ae59-b7b2196afc2a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 51742 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (51742,6,'{"status":"ok","response":{"player":{"pid":51742,"title":"Fran Wilson","short_name":"FC Wilson","first_name":"Fran Wilson","last_name":"","middle_name":"","birthdate":"1991-11-07","birthplace":"Farnham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fwilson07","instagram_profile":"https:\/\/www.instagram.com\/fwilson07\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":0,"runs":13,"balls":53,"highest":13,"run100":0,"run50":0,"run4":0,"run6":0,"average":"13.00","strike":"24.52","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":33,"innings":23,"notout":2,"runs":468,"balls":532,"highest":85,"run100":0,"run50":2,"run4":41,"run6":5,"average":"22.28","strike":"87.96","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":30,"innings":26,"notout":10,"runs":356,"balls":359,"highest":43,"run100":0,"run50":0,"run4":22,"run6":2,"average":"22.25","strike":"99.16","catches":7,"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":{"test":{"match_id":0,"inning_id":0,"matches":1,"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},"odi":{"match_id":0,"inning_id":0,"matches":33,"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},"t20i":{"match_id":0,"inning_id":0,"matches":30,"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},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"dea8e75fe9e567e614db160de3645971","modified":"2025-06-21 18:02:07","datetime":"2025-06-21 18:02:07","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":51742,"title":"Fran Wilson","short_name":"FC Wilson","first_name":"Fran Wilson","last_name":"","middle_name":"","birthdate":"1991-11-07","birthplace":"Farnham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fwilson07","instagram_profile":"https:\/\/www.instagram.com\/fwilson07\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":0,"runs":13,"balls":53,"highest":13,"run100":0,"run50":0,"run4":0,"run6":0,"average":"13.00","strike":"24.52","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":33,"innings":23,"notout":2,"runs":468,"balls":532,"highest":85,"run100":0,"run50":2,"run4":41,"run6":5,"average":"22.28","strike":"87.96","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":30,"innings":26,"notout":10,"runs":356,"balls":359,"highest":43,"run100":0,"run50":0,"run4":22,"run6":2,"average":"22.25","strike":"99.16","catches":7,"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":{"test":{"match_id":0,"inning_id":0,"matches":1,"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},"odi":{"match_id":0,"inning_id":0,"matches":33,"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},"t20i":{"match_id":0,"inning_id":0,"matches":30,"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},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"dea8e75fe9e567e614db160de3645971","modified":"2025-06-21 18:02:07","datetime":"2025-06-21 18:02:07","api_version":"3.0"}', Modified = GetDate() WHERE Id = 51742 AND DataTypeId = 6 END
Player profile of Fran Wilson, England
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

EnglandEngland*204/2 (46 ov)

India471/10 (113 ov)

 Day 2 - Session 3, England trail by 267 runs.
LIVETodayMatch 13

Alembic WarriorsAlembic Warriors107/9 (10 ov)

A4 Power Strikers124/4 (10 ov)

 A4 Power Strikers won by 17 runs
LIVETodayMatch 1

West Indies AcademyWest Indies Academy237/10 (46.2 ov)

Sri Lanka Emerging*43/2 (6.5 ov)

 Sri Lanka Emerging need 195 runs in 43.1 remaining overs
LIVETodayMatch 31

Bess Motors Blue DevilsBess Motors Blue Devils*55/2 (3.5 ov)

SAMP Army Cocrico Cavaliers93/4 (10 ov)

 Bess Motors Blue Devils need 39 runs in 37 remaining balls
LIVETodayMatch 9

Thunder Cats-BThunder Cats-B

Lexus*28/1 (2 ov)

 Thunder Cats-B elected to bowl
CancelledTodayMatch 12

Diamond DazzlersDiamond Dazzlers121/8 (20 ov)

Pruthvi Panthers

 Match Abandoned
ScheduledTodayMatch 32

Chicago Steelpan PlayersChicago Steelpan Players

Soca Kings

 
Scheduled21 June Match 10

Cayman IslandsCayman Islands

Bermuda

 
Scheduled22 June Match 11

MI New YorkMI New York

Washington Freedom

 
Scheduled22 June Match 15

Irises Cricket ClubIrises Cricket Club

Yuksom Capitals

 
Scheduled22 June Match 21

Adamas Howrah Warriors WomensAdamas Howrah Warriors Womens

Servotech Siliguri Strikers Womens

 
Scheduled22 June Eliminator

Brno CCBrno CC

Bohemians

 
Scheduled22 June Match 16

Black Eagle SAPBlack Eagle SAP

Avengers CC

 
Scheduled22 June Match 22

Murshidabad KingsMurshidabad Kings

Rashmi Medinipur Wizards

 
Scheduled22 June Match 3

Bhopal Wolves WomenBhopal Wolves Women

Bundelkhand Bulls Women

 
Scheduled22 June Match 22

Shrachi Rarh Tigers WomensShrachi Rarh Tigers Womens

Lux Shyam Kolkata Tigers Womens

 
Scheduled22 June Qualifier 1

Prague TigersPrague Tigers

Prague CC

 
Scheduled22 June Match 14

Diamond DazzlersDiamond Dazzlers

Ami Super Avengers

 
CricDirect Cricket News, Results and Stats
 

Fran Wilson

NationalityEngland
RoleBatter
Born07 Nov 1991 (33)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 1 1 - 13 13 13.00 53 24.52 - -
ODI 33 23 2 468 85 22.28 532 87.96 - 2
T20I 30 26 10 356 43 22.25 359 99.16 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 1 - - - - - - - - - -
ODI 33 - - - - - - - - - -
T20i 30 - - - - - - - - - -
× Close