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:5dbb7d75-cfa1-4127-bfa6-a461af7d699a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 58753 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (58753,6,'{"status":"ok","response":{"player":{"pid":58753,"title":"Pete Salmon","short_name":"P Salmon","first_name":"Pete Salmon","last_name":"","middle_name":"","birthdate":"1992-10-02","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"West Indies"},"batting":{"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":12,"notout":1,"runs":111,"balls":198,"highest":31,"run100":0,"run50":0,"run4":6,"run6":2,"average":"10.09","strike":"56.06","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":17,"notout":0,"runs":338,"balls":635,"highest":81,"run100":0,"run50":1,"run4":33,"run6":11,"average":"19.88","strike":"53.22","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"33","innings":"24","notout":"10","runs":"293","balls":"176","highest":"42","run100":"0","run50":"0","run4":"15","run6":"20","average":"20.93","strike":"166.48","catches":"13","stumpings":"0"}},"bowling":{"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":14,"balls":605,"overs":100.5,"runs":437,"wickets":16,"bestinning":"4\/28","bestmatch":"4\/28","econ":"4.33","average":"27.31","strike":"37.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":16,"balls":2326,"overs":387.4,"runs":993,"wickets":41,"bestinning":"7\/57","bestmatch":"8\/110","econ":"2.56","average":"24.21","strike":"56.7","wicket4i":1,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"33","innings":"32","balls":"358","overs":"59.4","runs":"512","wickets":"31","bestinning":"2\/5","bestmatch":"2\/5","econ":"8.58","average":"16.52","strike":"11.55","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"4c472fd83cadc91dfe7716868d8a89fe","modified":"2025-06-29 12:23:25","datetime":"2025-06-29 12:23:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":58753,"title":"Pete Salmon","short_name":"P Salmon","first_name":"Pete Salmon","last_name":"","middle_name":"","birthdate":"1992-10-02","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"West Indies"},"batting":{"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":12,"notout":1,"runs":111,"balls":198,"highest":31,"run100":0,"run50":0,"run4":6,"run6":2,"average":"10.09","strike":"56.06","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":17,"notout":0,"runs":338,"balls":635,"highest":81,"run100":0,"run50":1,"run4":33,"run6":11,"average":"19.88","strike":"53.22","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"33","innings":"24","notout":"10","runs":"293","balls":"176","highest":"42","run100":"0","run50":"0","run4":"15","run6":"20","average":"20.93","strike":"166.48","catches":"13","stumpings":"0"}},"bowling":{"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":14,"balls":605,"overs":100.5,"runs":437,"wickets":16,"bestinning":"4\/28","bestmatch":"4\/28","econ":"4.33","average":"27.31","strike":"37.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":16,"balls":2326,"overs":387.4,"runs":993,"wickets":41,"bestinning":"7\/57","bestmatch":"8\/110","econ":"2.56","average":"24.21","strike":"56.7","wicket4i":1,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"33","innings":"32","balls":"358","overs":"59.4","runs":"512","wickets":"31","bestinning":"2\/5","bestmatch":"2\/5","econ":"8.58","average":"16.52","strike":"11.55","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"4c472fd83cadc91dfe7716868d8a89fe","modified":"2025-06-29 12:23:25","datetime":"2025-06-29 12:23:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 58753 AND DataTypeId = 6 END
Player profile of Pete Salmon, West Indies
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

ZimbabweZimbabwe*201/6 (49.1 ov)

South Africa418/9d (90 ov)

 Day 2 - Session 2, Zimbabwe trail by 217 runs.
LIVETodayMatch 4

Maiwand ChampionsMaiwand Champions146/9 (20 ov)

Hindokush Strikers*79/3 (11.1 ov)

 Hindokush Strikers need 68 runs in 53 remaining balls
LIVETodayMatch 27

IDream Tiruppur TamizhansIDream Tiruppur Tamizhans182/5 (20 ov)

Nellai Royal Kings*28/3 (6.4 ov)

 Nellai Royal Kings need 155 runs in 13.2 remaining overs
LIVETodayMatch 4

Typhoons WomenTyphoons Women116/7 (20 ov)

Scorchers Women*93/3 (9.3 ov)

 Scorchers Women need 24 runs in 10.3 remaining overs
LIVEToday44th Match

HampshireHampshire

Worcestershire*101/2 (30 ov)

 Lunch Break : Day 1 - Worcestershire elected to bat
LIVEToday43rd Match

SomersetSomerset*100/3 (31 ov)

Nottinghamshire

 Lunch Break : Day 1 - Somerset elected to bat
LIVEToday42nd Match

SurreySurrey*101/1 (27 ov)

Durham

 Lunch Break : Day 1 - Durham elected to bowl
LIVEToday45th Match

SussexSussex

Warwickshire*113/1 (28 ov)

 Day 1 - Warwickshire elected to bat
LIVEToday41st Match

YorkshireYorkshire

Essex*97/1 (32 ov)

 Day 1 - Essex elected to bat
LIVEToday35th Match

DerbyshireDerbyshire

Lancashire*96/4 (28 ov)

 Day 1 - Lancashire elected to bat
LIVEToday36th Match

GlamorganGlamorgan

Gloucestershire*90/1 (32 ov)

 Lunch Break : Day 1 - Glamorgan elected to bowl
LIVEToday34th Match

KentKent*107/1 (28 ov)

Northamptonshire

 Lunch Break : Day 1 - Kent elected to bat
LIVEToday33rd Match

LeicestershireLeicestershire

Middlesex*119/0 (30 ov)

 Lunch Break : Day 1 - Leicestershire elected to bowl
LIVETodayMatch 3

England A WomenEngland A Women

New Zealand A Women129/10 (27.2 ov)

 Innings Break : New Zealand A Women elected to bat
LIVEToday2nd Semi Final

Empire Lionesses-WEmpire Lionesses-W*129/0 (9.5 ov)

Oulu CC-W

 Rain Delay : Empire Lionesses-W elected to bat
CancelledTodayMatch 6

Oulu CC-WOulu CC-W

SKK-W133/5 (10 ov)

 Match abandoned due to rain
ScheduledTodayFinal

Alembic WarriorsAlembic Warriors

Ami Super Avengers

 
Scheduled29 June Match 28

Dindigul DragonsDindigul Dragons

Trichy Grand Chola

 
CricDirect Cricket News, Results and Stats
 

Pete Salmon

NationalityWest Indies
RoleAll Rounder
Born02 Oct 1992 (32)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
List A 14 12 1 111 31 10.09 198 56.06 - -
1st Class 9 17 - 338 81 19.88 635 53.22 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
List A 14 14 100.5 437 16 4/28 27.31 4.33 37.8 1 -
1st Class 9 16 387.4 993 41 7/57 24.21 2.56 56.7 1 2
× Close