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:9990f60b-8099-4a78-b403-6d6b97975724 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 43573 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (43573,6,'{"status":"ok","response":{"player":{"pid":43573,"title":"Peter Forrest","short_name":"Peter Forrest","first_name":"Peter Forrest","last_name":"","middle_name":"","birthdate":"1985-11-15","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":14,"notout":0,"runs":368,"balls":561,"highest":104,"run100":1,"run50":3,"run4":34,"run6":4,"average":"26.28","strike":"65.59","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":32,"innings":32,"notout":7,"runs":575,"balls":540,"highest":62,"run100":0,"run50":3,"run4":45,"run6":12,"average":"23.00","strike":"106.48","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":59,"innings":56,"notout":5,"runs":1354,"balls":2008,"highest":104,"run100":1,"run50":9,"run4":114,"run6":16,"average":"26.54","strike":"67.43","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":138,"notout":11,"runs":4251,"balls":9732,"highest":177,"run100":10,"run50":18,"run4":476,"run6":40,"average":"33.47","strike":"43.68","catches":94,"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":{"odi":{"match_id":0,"inning_id":0,"matches":15,"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":32,"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":59,"innings":1,"balls":12,"overs":2,"runs":9,"wickets":0,"bestinning":"","bestmatch":"","econ":"4.50","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":7,"balls":105,"overs":17.3,"runs":82,"wickets":1,"bestinning":"1\/7","bestmatch":"1\/7","econ":"4.68","average":"82.00","strike":"105.0","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":"c938752e5a4b988febd41747bdd82e76","modified":"2025-06-09 14:37:35","datetime":"2025-06-09 14:37:35","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":43573,"title":"Peter Forrest","short_name":"Peter Forrest","first_name":"Peter Forrest","last_name":"","middle_name":"","birthdate":"1985-11-15","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":14,"notout":0,"runs":368,"balls":561,"highest":104,"run100":1,"run50":3,"run4":34,"run6":4,"average":"26.28","strike":"65.59","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":32,"innings":32,"notout":7,"runs":575,"balls":540,"highest":62,"run100":0,"run50":3,"run4":45,"run6":12,"average":"23.00","strike":"106.48","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":59,"innings":56,"notout":5,"runs":1354,"balls":2008,"highest":104,"run100":1,"run50":9,"run4":114,"run6":16,"average":"26.54","strike":"67.43","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":138,"notout":11,"runs":4251,"balls":9732,"highest":177,"run100":10,"run50":18,"run4":476,"run6":40,"average":"33.47","strike":"43.68","catches":94,"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":{"odi":{"match_id":0,"inning_id":0,"matches":15,"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":32,"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":59,"innings":1,"balls":12,"overs":2,"runs":9,"wickets":0,"bestinning":"","bestmatch":"","econ":"4.50","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":7,"balls":105,"overs":17.3,"runs":82,"wickets":1,"bestinning":"1\/7","bestmatch":"1\/7","econ":"4.68","average":"82.00","strike":"105.0","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":"c938752e5a4b988febd41747bdd82e76","modified":"2025-06-09 14:37:35","datetime":"2025-06-09 14:37:35","api_version":"3.0"}', Modified = GetDate() WHERE Id = 43573 AND DataTypeId = 6 END
Player profile of Peter Forrest, Australia
<>
CricDirect Cricket News, Results and Stats
 

Peter Forrest

NationalityAustralia
RoleBatter
Born15 Nov 1985 (39)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 15 14 - 368 104 26.28 561 65.59 1 3
T20I 32 32 7 575 62 23.00 540 106.48 - 3
List A 59 56 5 1354 104 26.54 2008 67.43 1 9
1st Class 80 138 11 4251 177 33.47 9732 43.68 10 18

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 15 - - - - - - - - - -
T20 32 - - - - - - - - - -
List A 59 1 2 9 - - - 4.50 - - -
1st Class 80 7 17.3 82 1 1/7 82.00 4.68 105.0 - -
× Close