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:cbb53528-1514-44a1-b186-88547308d522 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 108815 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (108815,6,'{"status":"ok","response":{"player":{"pid":108815,"title":"Gavin Hoey","short_name":"G Hoey","first_name":"Gavin Hoey","last_name":"","middle_name":"","birthdate":"2001-11-05","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Ireland"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":0,"runs":24,"balls":28,"highest":23,"run100":0,"run50":0,"run4":2,"run6":1,"average":"12.00","strike":"85.71","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":26,"innings":16,"notout":4,"runs":162,"balls":113,"highest":39,"run100":0,"run50":0,"run4":9,"run6":12,"average":"13.50","strike":"143.36","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":34,"innings":26,"notout":1,"runs":444,"balls":585,"highest":50,"run100":0,"run50":1,"run4":47,"run6":8,"average":"17.76","strike":"75.89","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":7,"notout":1,"runs":108,"balls":168,"highest":37,"run100":0,"run50":0,"run4":18,"run6":0,"average":"18.00","strike":"64.28","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"13","innings":"6","notout":"0","runs":"90","balls":"45","highest":"28","run100":"0","run50":"0","run4":"2","run6":"11","average":"15.00","strike":"200.00","catches":"3","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"balls":102,"overs":17,"runs":114,"wickets":1,"bestinning":"1\/49","bestmatch":"1\/49","econ":"6.70","average":"114.00","strike":"102.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":26,"innings":25,"balls":501,"overs":83.3,"runs":700,"wickets":33,"bestinning":"4\/25","bestmatch":"4\/25","econ":"8.38","average":"21.21","strike":"15.1","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":34,"innings":31,"balls":1448,"overs":241.2,"runs":1253,"wickets":55,"bestinning":"6\/26","bestmatch":"6\/26","econ":"5.19","average":"22.78","strike":"26.3","wicket4i":5,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":5,"balls":502,"overs":83.4,"runs":399,"wickets":8,"bestinning":"4\/81","bestmatch":"4\/85","econ":"4.76","average":"49.87","strike":"62.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"13","innings":"10","balls":"96","overs":"16","runs":"204","wickets":"6","bestinning":"2\/17","bestmatch":"2\/17","econ":"12.75","average":"34.00","strike":"16.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"da910328249e3b79b139136b35cc7b79","modified":"2025-06-21 17:27:56","datetime":"2025-06-21 17:27:56","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":108815,"title":"Gavin Hoey","short_name":"G Hoey","first_name":"Gavin Hoey","last_name":"","middle_name":"","birthdate":"2001-11-05","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Ireland"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":0,"runs":24,"balls":28,"highest":23,"run100":0,"run50":0,"run4":2,"run6":1,"average":"12.00","strike":"85.71","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":26,"innings":16,"notout":4,"runs":162,"balls":113,"highest":39,"run100":0,"run50":0,"run4":9,"run6":12,"average":"13.50","strike":"143.36","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":34,"innings":26,"notout":1,"runs":444,"balls":585,"highest":50,"run100":0,"run50":1,"run4":47,"run6":8,"average":"17.76","strike":"75.89","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":7,"notout":1,"runs":108,"balls":168,"highest":37,"run100":0,"run50":0,"run4":18,"run6":0,"average":"18.00","strike":"64.28","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"13","innings":"6","notout":"0","runs":"90","balls":"45","highest":"28","run100":"0","run50":"0","run4":"2","run6":"11","average":"15.00","strike":"200.00","catches":"3","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"balls":102,"overs":17,"runs":114,"wickets":1,"bestinning":"1\/49","bestmatch":"1\/49","econ":"6.70","average":"114.00","strike":"102.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":26,"innings":25,"balls":501,"overs":83.3,"runs":700,"wickets":33,"bestinning":"4\/25","bestmatch":"4\/25","econ":"8.38","average":"21.21","strike":"15.1","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":34,"innings":31,"balls":1448,"overs":241.2,"runs":1253,"wickets":55,"bestinning":"6\/26","bestmatch":"6\/26","econ":"5.19","average":"22.78","strike":"26.3","wicket4i":5,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":5,"balls":502,"overs":83.4,"runs":399,"wickets":8,"bestinning":"4\/81","bestmatch":"4\/85","econ":"4.76","average":"49.87","strike":"62.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"13","innings":"10","balls":"96","overs":"16","runs":"204","wickets":"6","bestinning":"2\/17","bestmatch":"2\/17","econ":"12.75","average":"34.00","strike":"16.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"da910328249e3b79b139136b35cc7b79","modified":"2025-06-21 17:27:56","datetime":"2025-06-21 17:27:56","api_version":"3.0"}', Modified = GetDate() WHERE Id = 108815 AND DataTypeId = 6 END
Player profile of Gavin Hoey, Ireland
<>
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*157/2 (39 ov)

India471/10 (113 ov)

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

Alembic WarriorsAlembic Warriors*57/4 (5.4 ov)

A4 Power Strikers124/4 (10 ov)

 Alembic Warriors need 68 runs in 26 remaining balls
LIVETodayQualifier 2

Puneri BappaPuneri Bappa*100/8 (18 ov)

Raigad Royals133/9 (20 ov)

 Puneri Bappa need 34 runs in 12 remaining balls
LIVETodayMatch 1

West Indies AcademyWest Indies Academy237/10 (46.2 ov)

Sri Lanka Emerging*0/0 (0.2 ov)

 Sri Lanka Emerging need 238 runs in 49.4 remaining overs
LIVETodayMatch 18

Lyca Kovai KingsLyca Kovai Kings165/6 (20 ov)

Nellai Royal Kings98/10 (17.5 ov)

 Lyca Kovai Kings won by 67 runs
LIVETodayMatch 19

Rewa JaguarsRewa Jaguars226/8 (20 ov)

Indore Pink Panthers*122/7 (12.1 ov)

 Indore Pink Panthers need 105 runs in 47 remaining balls
LIVETodayMatch 31

Bess Motors Blue DevilsBess Motors Blue Devils

SAMP Army Cocrico Cavaliers93/4 (10 ov)

 Innings Break : Bess Motors Blue Devils elected to bowl
CancelledTodayMatch 12

Diamond DazzlersDiamond Dazzlers121/8 (20 ov)

Pruthvi Panthers

 Match Abandoned
ScheduledTodayMatch 9

Thunder Cats-BThunder Cats-B

Lexus

 
Scheduled21 June Match 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

 
CricDirect Cricket News, Results and Stats
 

Gavin Hoey

NationalityIreland
RoleAll Rounder
Born05 Nov 2001 (23)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 2 2 - 24 23 12.00 28 85.71 - -
T20I 26 16 4 162 39 13.50 113 143.36 - -
List A 34 26 1 444 50 17.76 585 75.89 - 1
1st Class 4 7 1 108 37 18.00 168 64.28 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 2 2 17 114 1 1/49 114.00 6.70 102.0 - -
T20 26 25 83.3 700 33 4/25 21.21 8.38 15.1 1 -
List A 34 31 241.2 1253 55 6/26 22.78 5.19 26.3 5 1
1st Class 4 5 83.4 399 8 4/81 49.87 4.76 62.7 1 -
× Close