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:220ef1b7-b803-4564-8c91-1f0f4a6e5c79 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90288 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90288,3,'{"status":"ok","response":{"match_id":90288,"title":"Middlesex Women vs Sussex Women","short_title":"MID-W vs SUS-W","subtitle":"at lord''s","match_number":"0","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Middlesex Women won by 8 wickets","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"36","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19246,"name":"Middlesex Women","short_name":"MID-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","scores_full":"103\/2 (15.2 ov)","scores":"103\/2","overs":"15.2"},"teamb":{"team_id":19200,"name":"Sussex Women","short_name":"SUS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","scores_full":"102\/7 (20 ov)","scores":"102\/7","overs":"20"},"date_start":"2025-05-29 13:15:00","date_end":"2025-05-29 23:15:00","timestamp_start":1748524500,"timestamp_end":1748560500,"date_start_ist":"2025-05-29 18:45:00","date_end_ist":"2025-05-30 04:45:00","venue":{"venue_id":"30","name":"Lord''s","location":"London","country":"England","timezone":""},"umpires":"Julia Jarvis (England), Rehma Chandaria (England)","referee":"","equation":"","live":"","result":"MID-W won by 8 wickets","result_type":1,"win_margin":"8 wickets","winning_team_id":19246,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"2025-05-29 21:15:21","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Middlesex Women elected to bowl","winner":19246,"decision":2}},"etag":"b8c0a60c9b4bfef2a5523260a879421a","modified":"2025-06-27 08:00:11","datetime":"2025-06-27 08:00:11","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90288,"title":"Middlesex Women vs Sussex Women","short_title":"MID-W vs SUS-W","subtitle":"at lord''s","match_number":"0","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Middlesex Women won by 8 wickets","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"36","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19246,"name":"Middlesex Women","short_name":"MID-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","scores_full":"103\/2 (15.2 ov)","scores":"103\/2","overs":"15.2"},"teamb":{"team_id":19200,"name":"Sussex Women","short_name":"SUS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","scores_full":"102\/7 (20 ov)","scores":"102\/7","overs":"20"},"date_start":"2025-05-29 13:15:00","date_end":"2025-05-29 23:15:00","timestamp_start":1748524500,"timestamp_end":1748560500,"date_start_ist":"2025-05-29 18:45:00","date_end_ist":"2025-05-30 04:45:00","venue":{"venue_id":"30","name":"Lord''s","location":"London","country":"England","timezone":""},"umpires":"Julia Jarvis (England), Rehma Chandaria (England)","referee":"","equation":"","live":"","result":"MID-W won by 8 wickets","result_type":1,"win_margin":"8 wickets","winning_team_id":19246,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"2025-05-29 21:15:21","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Middlesex Women elected to bowl","winner":19246,"decision":2}},"etag":"b8c0a60c9b4bfef2a5523260a879421a","modified":"2025-06-27 08:00:11","datetime":"2025-06-27 08:00:11","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90288 AND DataTypeId = 3 END
Live Report & Scorecard of Middlesex Women vs Sussex Women at lord's