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:2e6c383b-4e11-4f41-bc17-62697176a0f2 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1192 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1192,6,'{"status":"ok","response":{"player":{"pid":1192,"title":"Finlay McCreath","short_name":"F McCreath","first_name":"Finlay McCreath","last_name":"","middle_name":"","birthdate":"1998-10-16","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Scotland"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":9,"innings":8,"notout":0,"runs":274,"balls":376,"highest":81,"run100":0,"run50":2,"run4":21,"run6":3,"average":"34.25","strike":"72.87","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":0,"runs":52,"balls":41,"highest":40,"run100":0,"run50":0,"run4":4,"run6":2,"average":"17.33","strike":"126.82","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":0,"runs":52,"balls":41,"highest":40,"run100":0,"run50":0,"run4":4,"run6":2,"average":"17.33","strike":"126.82","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":11,"innings":10,"notout":0,"runs":456,"balls":583,"highest":100,"run100":1,"run50":3,"run4":37,"run6":6,"average":"45.60","strike":"78.21","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"12","innings":"10","notout":"3","runs":"410","balls":"162","highest":"137","run100":"1","run50":"2","run4":"21","run6":"48","average":"58.57","strike":"253.09","catches":"2","stumpings":"0"}},"bowling":{"odi":{"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},"t20i":{"match_id":0,"inning_id":0,"matches":3,"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},"t20":{"match_id":0,"inning_id":0,"matches":3,"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":11,"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":"12","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"bc2ab7934647c79bf79ddcacb5ce316c","modified":"2025-06-20 18:57:51","datetime":"2025-06-20 18:57:51","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1192,"title":"Finlay McCreath","short_name":"F McCreath","first_name":"Finlay McCreath","last_name":"","middle_name":"","birthdate":"1998-10-16","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Scotland"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":9,"innings":8,"notout":0,"runs":274,"balls":376,"highest":81,"run100":0,"run50":2,"run4":21,"run6":3,"average":"34.25","strike":"72.87","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":0,"runs":52,"balls":41,"highest":40,"run100":0,"run50":0,"run4":4,"run6":2,"average":"17.33","strike":"126.82","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":0,"runs":52,"balls":41,"highest":40,"run100":0,"run50":0,"run4":4,"run6":2,"average":"17.33","strike":"126.82","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":11,"innings":10,"notout":0,"runs":456,"balls":583,"highest":100,"run100":1,"run50":3,"run4":37,"run6":6,"average":"45.60","strike":"78.21","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"12","innings":"10","notout":"3","runs":"410","balls":"162","highest":"137","run100":"1","run50":"2","run4":"21","run6":"48","average":"58.57","strike":"253.09","catches":"2","stumpings":"0"}},"bowling":{"odi":{"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},"t20i":{"match_id":0,"inning_id":0,"matches":3,"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},"t20":{"match_id":0,"inning_id":0,"matches":3,"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":11,"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":"12","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"bc2ab7934647c79bf79ddcacb5ce316c","modified":"2025-06-20 18:57:51","datetime":"2025-06-20 18:57:51","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1192 AND DataTypeId = 6 END
Player profile of Finlay McCreath, Scotland
<>
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
LIVETodayEliminator

Raigad RoyalsRaigad Royals*155/2 (17 ov)

Kolhapur Tuskers164/7 (20 ov)

 Raigad Royals need 10 runs in 18 remaining balls
LIVETodayMatch 65

NorthamptonshireNorthamptonshire

Nottinghamshire*164/8 (20 ov)

 Nottinghamshire elected to bat
LIVETodayMatch 67

GlamorganGlamorgan130/9 (20 ov)

Somerset

 Innings Break : Somerset elected to bowl
LIVETodayMatch 69

DurhamDurham193/4 (20 ov)

Yorkshire

 Innings Break : Yorkshire elected to bowl
LIVETodayMatch 64

SurreySurrey*149/3 (15.4 ov)

Middlesex

 Middlesex elected to bowl
LIVETodayMatch 66

GloucestershireGloucestershire

Hampshire*79/7 (14.3 ov)

 Gloucestershire elected to bowl
LIVETodayMatch 68

EssexEssex

Kent*161/2 (15.1 ov)

 Essex elected to bowl
LIVETodayMatch 70

DerbyshireDerbyshire

Lancashire*157/2 (13 ov)

 Derbyshire elected to bowl
LIVETodayMatch 71

WarwickshireWarwickshire

Worcestershire*93/6 (13 ov)

 Warwickshire elected to bowl
LIVEToday1st T20I

West Indies WomenWest Indies Women

South Africa Women*96/3 (11 ov)

 West Indies Women elected to bowl
LIVETodayMatch 29

Bess Motors Blue DevilsBess Motors Blue Devils

Leatherback Strikers

  Toss 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
ScheduledTodayMatch 8

YSSCYSSC

TGS

 
Scheduled20 June Match 30

Scarlet Ibis ScorchersScarlet Ibis Scorchers

Soca Kings

 
Scheduled21 June Match 10

Texas Super KingsTexas Super Kings

San Francisco Unicorns

 
CricDirect Cricket News, Results and Stats
 

Finlay McCreath

NationalityScotland
RoleBatter
Born16 Oct 1998 (26)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 9 8 - 274 81 34.25 376 72.87 - 2
T20I 3 3 - 52 40 17.33 41 126.82 - -
T20I 3 3 - 52 40 17.33 41 126.82 - -
List A 11 10 - 456 100 45.60 583 78.21 1 3

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 9 - - - - - - - - - -
T20i 3 - - - - - - - - - -
T20 3 - - - - - - - - - -
List A 11 - - - - - - - - - -
× Close