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:d336a8de-44bf-4351-bf11-4a16dc9fddce Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 95569 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (95569,6,'{"status":"ok","response":{"player":{"pid":95569,"title":"Mohammad Ahsan","short_name":"M Ahsan","first_name":"Mohammad Ahsan","last_name":"","middle_name":"","birthdate":"1980-07-19","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Kuwait"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":6,"innings":3,"notout":0,"runs":19,"balls":20,"highest":8,"run100":0,"run50":0,"run4":0,"run6":1,"average":"6.33","strike":"95.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":6,"innings":3,"notout":0,"runs":19,"balls":20,"highest":8,"run100":0,"run50":0,"run4":0,"run6":1,"average":"6.33","strike":"95.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"3","notout":"3","runs":"16","balls":"22","highest":"14","run100":"0","run50":"0","run4":"1","run6":"0","average":"","strike":"72.73","catches":"1","stumpings":"0"}},"bowling":{"t20i":{"match_id":0,"inning_id":0,"matches":6,"innings":6,"balls":120,"overs":20,"runs":192,"wickets":4,"bestinning":"2\/31","bestmatch":"2\/31","econ":"9.60","average":"48.00","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":6,"innings":6,"balls":120,"overs":20,"runs":192,"wickets":4,"bestinning":"2\/31","bestmatch":"2\/31","econ":"9.60","average":"48.00","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"9","balls":"102","overs":"17","runs":"166","wickets":"5","bestinning":"0\/12","bestmatch":"","econ":"9.76","average":"33.20","strike":"20.40","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"0d8c8be4c80b409a93808af831b6dda5","modified":"2025-07-30 05:30:02","datetime":"2025-07-30 05:30:02","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":95569,"title":"Mohammad Ahsan","short_name":"M Ahsan","first_name":"Mohammad Ahsan","last_name":"","middle_name":"","birthdate":"1980-07-19","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Kuwait"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":6,"innings":3,"notout":0,"runs":19,"balls":20,"highest":8,"run100":0,"run50":0,"run4":0,"run6":1,"average":"6.33","strike":"95.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":6,"innings":3,"notout":0,"runs":19,"balls":20,"highest":8,"run100":0,"run50":0,"run4":0,"run6":1,"average":"6.33","strike":"95.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"3","notout":"3","runs":"16","balls":"22","highest":"14","run100":"0","run50":"0","run4":"1","run6":"0","average":"","strike":"72.73","catches":"1","stumpings":"0"}},"bowling":{"t20i":{"match_id":0,"inning_id":0,"matches":6,"innings":6,"balls":120,"overs":20,"runs":192,"wickets":4,"bestinning":"2\/31","bestmatch":"2\/31","econ":"9.60","average":"48.00","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":6,"innings":6,"balls":120,"overs":20,"runs":192,"wickets":4,"bestinning":"2\/31","bestmatch":"2\/31","econ":"9.60","average":"48.00","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"9","balls":"102","overs":"17","runs":"166","wickets":"5","bestinning":"0\/12","bestmatch":"","econ":"9.76","average":"33.20","strike":"20.40","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"0d8c8be4c80b409a93808af831b6dda5","modified":"2025-07-30 05:30:02","datetime":"2025-07-30 05:30:02","api_version":"3.0"}', Modified = GetDate() WHERE Id = 95569 AND DataTypeId = 6 END
Player profile of Mohammad Ahsan, Kuwait
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday51st Match

DurhamDurham153/10 (55.1 ov)

Surrey*182/5 (40 ov)

 Stumps : Day 1 - Surrey lead by 29 runs.
LIVEToday55th Match

NottinghamshireNottinghamshire

Somerset*338/4 (93.3 ov)

 Stumps : Day 1 - Nottinghamshire elected to bowl
LIVEToday54th Match

WorcestershireWorcestershire

Hampshire*146/2 (39.2 ov)

 Stumps : Day 1 - Worcestershire elected to bowl
LIVEToday52nd Match

EssexEssex*350/4 (96 ov)

Warwickshire

 Stumps : Day 1 - Warwickshire elected to bowl
LIVEToday53rd Match

YorkshireYorkshire

Sussex*210/9 (96 ov)

 Stumps : Day 1 - Yorkshire elected to bowl
LIVEToday42nd Match

GloucestershireGloucestershire

Middlesex*232/3 (52 ov)

 Stumps : Day 1 - Middlesex elected to bat
LIVEToday44th Match

KentKent

Leicestershire*386/9 (92 ov)

 Stumps : Day 1 - Kent elected to bowl
LIVEToday43rd Match

LancashireLancashire

Glamorgan*260/8 (96 ov)

 Stumps : Day 1 - Glamorgan elected to bat
LIVEToday41st Match

NorthamptonshireNorthamptonshire

Derbyshire*348/8 (97 ov)

 Stumps : Day 1 - Derbyshire elected to bat
LIVETodayMatch 5

Bud CCBud CC*6/2 (1.3 ov)

91 Yard Club155/3 (20 ov)

 Bud CC need 150 runs in 18.3 remaining overs
LIVETodayMatch 19

Band-e-Amir DragonsBand-e-Amir Dragons*97/1 (12.3 ov)

Amo Sharks

 Band-e-Amir Dragons elected to bat
Scheduled30 July Match 6

Nabajyoti ClubNabajyoti Club

Guwahati Giants

 
Scheduled30 July 1st Test

ZimbabweZimbabwe

New Zealand

 
Scheduled30 July Match 11

East MoleseyEast Molesey

Spencer

 
Scheduled30 July Match 37

Hampshire WomenHampshire Women

The Blaze Women

 
Scheduled30 July Match 38

Lancashire WomenLancashire Women

Essex Women

 
Scheduled30 July Match 39

Somerset WomenSomerset Women

Durham Women

 
Scheduled30 July Match 40

Warwickshire WomenWarwickshire Women

Surrey Women

 
CricDirect Cricket News, Results and Stats
 

Mohammad Ahsan

NationalityKuwait
RoleBowler
Born19 Jul 1980 (45)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 6 3 - 19 8 6.33 20 95.00 - -
T20I 6 3 - 19 8 6.33 20 95.00 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20i 6 6 20 192 4 2/31 48.00 9.60 30.0 - -
T20 6 6 20 192 4 2/31 48.00 9.60 30.0 - -
× Close