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:0df009eb-5c8b-4267-a38e-36acd2ab3a17 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 52885 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (52885,6,'{"status":"ok","response":{"player":{"pid":52885,"title":"Will Pucovski","short_name":"WJ Pucovski","first_name":"Will Pucovski","last_name":"","middle_name":"","birthdate":"1998-02-02","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willpucovski\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"Australia"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"notout":0,"runs":72,"balls":126,"highest":62,"run100":0,"run50":1,"run4":6,"run6":0,"average":"36.00","strike":"57.14","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":12,"notout":0,"runs":333,"balls":429,"highest":137,"run100":1,"run50":2,"run4":35,"run6":2,"average":"27.75","strike":"77.62","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":36,"innings":57,"notout":5,"runs":2350,"balls":4919,"highest":255,"run100":7,"run50":9,"run4":252,"run6":2,"average":"45.19","strike":"47.77","catches":18,"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":1,"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":14,"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},"firstclass":{"match_id":0,"inning_id":0,"matches":36,"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":"a0995306a4dbeda7bd6f580104a519c4","modified":"2025-07-13 05:31:30","datetime":"2025-07-13 05:31:30","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":52885,"title":"Will Pucovski","short_name":"WJ Pucovski","first_name":"Will Pucovski","last_name":"","middle_name":"","birthdate":"1998-02-02","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willpucovski\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"Australia"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"notout":0,"runs":72,"balls":126,"highest":62,"run100":0,"run50":1,"run4":6,"run6":0,"average":"36.00","strike":"57.14","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":12,"notout":0,"runs":333,"balls":429,"highest":137,"run100":1,"run50":2,"run4":35,"run6":2,"average":"27.75","strike":"77.62","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":36,"innings":57,"notout":5,"runs":2350,"balls":4919,"highest":255,"run100":7,"run50":9,"run4":252,"run6":2,"average":"45.19","strike":"47.77","catches":18,"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":1,"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":14,"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},"firstclass":{"match_id":0,"inning_id":0,"matches":36,"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":"a0995306a4dbeda7bd6f580104a519c4","modified":"2025-07-13 05:31:30","datetime":"2025-07-13 05:31:30","api_version":"3.0"}', Modified = GetDate() WHERE Id = 52885 AND DataTypeId = 6 END
Player profile of Will Pucovski, Australia
CricDirect Cricket News, Results and Stats
 

Will Pucovski

NationalityAustralia
RoleBatter
Born02 Feb 1998 (27)
Batting StyleRight Hand Bat

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 1 2 - 72 62 36.00 126 57.14 - 1
List A 14 12 - 333 137 27.75 429 77.62 1 2
1st Class 36 57 5 2350 255 45.19 4919 47.77 7 9

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 1 - - - - - - - - - -
List A 14 - - - - - - - - - -
1st Class 36 - - - - - - - - - -
× Close