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:f7d961f8-3469-422a-9144-c1cd4d5820d5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 50221 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (50221,6,'{"status":"ok","response":{"player":{"pid":50221,"title":"Jess Cameron","short_name":"JE Cameron","first_name":"Jess Cameron","last_name":"","middle_name":"","birthdate":"1989-06-27","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Australia"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":5,"notout":0,"runs":109,"balls":215,"highest":50,"run100":0,"run50":1,"run4":18,"run6":1,"average":"21.80","strike":"50.69","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":50,"innings":43,"notout":9,"runs":1265,"balls":1505,"highest":90,"run100":0,"run50":9,"run4":144,"run6":18,"average":"37.20","strike":"84.05","catches":32,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":64,"innings":55,"notout":10,"runs":941,"balls":875,"highest":68,"run100":0,"run50":3,"run4":82,"run6":20,"average":"20.91","strike":"107.54","catches":34,"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":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},"odi":{"match_id":0,"inning_id":0,"matches":50,"innings":1,"balls":18,"overs":3,"runs":16,"wickets":1,"bestinning":"1\/16","bestmatch":"1\/16","econ":"5.33","average":"16.00","strike":"18.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":64,"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":"530a89651e40086068b1bb558f5d599e","modified":"2025-07-27 13:12:34","datetime":"2025-07-27 13:12:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":50221,"title":"Jess Cameron","short_name":"JE Cameron","first_name":"Jess Cameron","last_name":"","middle_name":"","birthdate":"1989-06-27","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Australia"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":5,"notout":0,"runs":109,"balls":215,"highest":50,"run100":0,"run50":1,"run4":18,"run6":1,"average":"21.80","strike":"50.69","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":50,"innings":43,"notout":9,"runs":1265,"balls":1505,"highest":90,"run100":0,"run50":9,"run4":144,"run6":18,"average":"37.20","strike":"84.05","catches":32,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":64,"innings":55,"notout":10,"runs":941,"balls":875,"highest":68,"run100":0,"run50":3,"run4":82,"run6":20,"average":"20.91","strike":"107.54","catches":34,"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":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},"odi":{"match_id":0,"inning_id":0,"matches":50,"innings":1,"balls":18,"overs":3,"runs":16,"wickets":1,"bestinning":"1\/16","bestmatch":"1\/16","econ":"5.33","average":"16.00","strike":"18.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":64,"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":"530a89651e40086068b1bb558f5d599e","modified":"2025-07-27 13:12:34","datetime":"2025-07-27 13:12:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 50221 AND DataTypeId = 6 END
Player profile of Jess Cameron, Australia
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday4th Test

EnglandEngland669/10 (157.1 ov)

India358/10 (114.1 ov) & *253/4 (96.4 ov)

 Day 5 - Session 2, India trail by 58 runs.
LIVETodayMatch 18

United Arab EmiratesUnited Arab Emirates*50/2 (6.1 ov)

Uganda170/7 (20 ov)

 United Arab Emirates need 121 runs in 13.5 remaining overs
LIVETodayFinal

BahrainBahrain189/3 (20 ov)

Malawi*39/0 (4 ov)

 Malawi need 151 runs in 16.0 remaining overs
LIVEToday1st Semi-Final

The Blaze WomenThe Blaze Women*2/2 (1.1 ov)

Warwickshire Women163/8 (20 ov)

 The Blaze Women need 162 runs in 18.5 remaining overs
LIVETodayMatch 12

South Africa ChampionsSouth Africa Champions241/6 (20 ov)

Australia Champions*0/0 ( ov)

 Innings Break : Australia Champions need 242 runs in 20 remaining overs
LIVETodayQualifier 2

HuddingeHuddinge156/6 (10 ov)

Rising Phoenix*62/5 (6.1 ov)

 Rising Phoenix need 95 runs in 23 remaining balls
LIVETodayFinal

Villianur Mohit KingsVillianur Mohit Kings

Mahe Megalo Strikers

 Villianur Mohit Kings elected to bowl
CancelledTodayFinal

AustriaAustria182/3 (16 ov)

Romania

 Match abandoned due to rain
CancelledTodayMatch 5

Navarang ClubNavarang Club0/0 ( ov)

City Cricket Club58/1 (6 ov)

 Match abandoned due to rain
ScheduledTodayFinal

Gauhati Town ClubGauhati Town Club

Guwahati Giants

 
ScheduledTodayMatch 2

West Indies Women Under-19sWest Indies Women Under-19s

United States of America Women Under-19s

 
Scheduled27 July Final

Alby Zalmi CFAlby Zalmi CF

TBA

 
Scheduled27 July Match 13

India ChampionsIndia Champions

England Champions

 
Scheduled27 July Match 29

Chennai Kings CAChennai Kings CA

Tally Rangers

 
Scheduled28 July 1st Semi-Final

Maxx Cricket ClubMaxx Cricket Club

Sky Warriors Cricket

 
Scheduled28 July 2nd Semi-Final

MR KB PutrajayaMR KB Putrajaya

Fatemi Resources Cricket Club

 
Scheduled28 July Match 1

Gauhati Town ClubGauhati Town Club

Bud CC

 
Scheduled28 July Match 15

Band-e-Amir DragonsBand-e-Amir Dragons

Boost Defenders

 
CricDirect Cricket News, Results and Stats
 

Jess Cameron

NationalityAustralia
RoleBatter
Born27 Jun 1989 (36)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 3 5 - 109 50 21.80 215 50.69 - 1
ODI 50 43 9 1265 90 37.20 1505 84.05 - 9
T20I 64 55 10 941 68 20.91 875 107.54 - 3

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 3 - - - - - - - - - -
ODI 50 1 3 16 1 1/16 16.00 5.33 18.0 - -
T20i 64 - - - - - - - - - -
× Close