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:dcd80343-62d7-4ea5-816a-076fdacc5406 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1907 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1907,6,'{"status":"ok","response":{"player":{"pid":1907,"title":"Timm van der Gugten","short_name":"T Gugten","first_name":"Timm van der Gugten","last_name":"","middle_name":"","birthdate":"1991-02-25","birthplace":"Upper North Shore, Sydney","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/hans_gugten46","instagram_profile":"https:\/\/www.instagram.com\/timmvdg\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Australia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":9,"notout":2,"runs":118,"balls":170,"highest":49,"run100":0,"run50":0,"run4":5,"run6":4,"average":"16.85","strike":"69.41","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":49,"innings":15,"notout":5,"runs":168,"balls":124,"highest":40,"run100":0,"run50":0,"run4":8,"run6":9,"average":"16.80","strike":"135.48","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":146,"innings":67,"notout":24,"runs":589,"balls":428,"highest":48,"run100":0,"run50":0,"run4":33,"run6":32,"average":"13.69","strike":"137.61","catches":39,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":83,"innings":49,"notout":16,"runs":613,"balls":710,"highest":49,"run100":0,"run50":0,"run4":52,"run6":16,"average":"18.57","strike":"86.33","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":130,"notout":37,"runs":1887,"balls":3900,"highest":85,"run100":0,"run50":9,"run4":250,"run6":16,"average":"20.29","strike":"48.38","catches":24,"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":14,"balls":552,"overs":92,"runs":311,"wickets":14,"bestinning":"5\/24","bestmatch":"5\/24","econ":"3.38","average":"22.21","strike":"39.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":49,"innings":48,"balls":913,"overs":152.1,"runs":1150,"wickets":52,"bestinning":"3\/9","bestmatch":"3\/9","econ":"7.55","average":"22.11","strike":"17.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":146,"innings":142,"balls":2746,"overs":457.4,"runs":3817,"wickets":164,"bestinning":"5\/21","bestmatch":"5\/21","econ":"8.34","average":"23.27","strike":"16.7","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":83,"innings":80,"balls":3694,"overs":615.4,"runs":3070,"wickets":94,"bestinning":"5\/24","bestmatch":"5\/24","econ":"4.98","average":"32.65","strike":"39.2","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":154,"balls":16602,"overs":2767,"runs":8504,"wickets":310,"bestinning":"7\/42","bestmatch":"10\/121","econ":"3.07","average":"27.43","strike":"53.5","wicket4i":13,"wicket5i":15,"wicket10m":1,"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":"edcad9672d6909f771853db894c2ada2","modified":"2025-07-11 20:07:41","datetime":"2025-07-11 20:07:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1907,"title":"Timm van der Gugten","short_name":"T Gugten","first_name":"Timm van der Gugten","last_name":"","middle_name":"","birthdate":"1991-02-25","birthplace":"Upper North Shore, Sydney","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/hans_gugten46","instagram_profile":"https:\/\/www.instagram.com\/timmvdg\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Australia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":9,"notout":2,"runs":118,"balls":170,"highest":49,"run100":0,"run50":0,"run4":5,"run6":4,"average":"16.85","strike":"69.41","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":49,"innings":15,"notout":5,"runs":168,"balls":124,"highest":40,"run100":0,"run50":0,"run4":8,"run6":9,"average":"16.80","strike":"135.48","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":146,"innings":67,"notout":24,"runs":589,"balls":428,"highest":48,"run100":0,"run50":0,"run4":33,"run6":32,"average":"13.69","strike":"137.61","catches":39,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":83,"innings":49,"notout":16,"runs":613,"balls":710,"highest":49,"run100":0,"run50":0,"run4":52,"run6":16,"average":"18.57","strike":"86.33","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":130,"notout":37,"runs":1887,"balls":3900,"highest":85,"run100":0,"run50":9,"run4":250,"run6":16,"average":"20.29","strike":"48.38","catches":24,"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":14,"balls":552,"overs":92,"runs":311,"wickets":14,"bestinning":"5\/24","bestmatch":"5\/24","econ":"3.38","average":"22.21","strike":"39.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":49,"innings":48,"balls":913,"overs":152.1,"runs":1150,"wickets":52,"bestinning":"3\/9","bestmatch":"3\/9","econ":"7.55","average":"22.11","strike":"17.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":146,"innings":142,"balls":2746,"overs":457.4,"runs":3817,"wickets":164,"bestinning":"5\/21","bestmatch":"5\/21","econ":"8.34","average":"23.27","strike":"16.7","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":83,"innings":80,"balls":3694,"overs":615.4,"runs":3070,"wickets":94,"bestinning":"5\/24","bestmatch":"5\/24","econ":"4.98","average":"32.65","strike":"39.2","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":154,"balls":16602,"overs":2767,"runs":8504,"wickets":310,"bestinning":"7\/42","bestmatch":"10\/121","econ":"3.07","average":"27.43","strike":"53.5","wicket4i":13,"wicket5i":15,"wicket10m":1,"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":"edcad9672d6909f771853db894c2ada2","modified":"2025-07-11 20:07:41","datetime":"2025-07-11 20:07:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1907 AND DataTypeId = 6 END
Player profile of Timm van der Gugten, Australia
<>
CricDirect Cricket News, Results and Stats
 

Timm van der Gugten

NationalityAustralia
RoleBowler
Born25 Feb 1991 (34)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 15 9 2 118 49 16.85 170 69.41 - -
T20I 49 15 5 168 40 16.80 124 135.48 - -
T20I 146 67 24 589 48 13.69 428 137.61 - -
List A 83 49 16 613 49 18.57 710 86.33 - -
1st Class 96 130 37 1887 85 20.29 3900 48.38 - 9

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 15 14 92 311 14 5/24 22.21 3.38 39.4 - 1
T20i 49 48 152.1 1150 52 3/9 22.11 7.55 17.5 - -
T20 146 142 457.4 3817 164 5/21 23.27 8.34 16.7 4 1
List A 83 80 615.4 3070 94 5/24 32.65 4.98 39.2 2 2
1st Class 96 154 2767 8504 310 7/42 27.43 3.07 53.5 13 15
× Close