Ontario Women's Hockey Association

Ontario Women's Hockey Association, event management software, League administration software, Club management software, Club management software,Club administration software, Online Registration, Facility Management Software, League website, Club website, web-based, registration software, league scheduling software, database, registration, schedules, standings, player statistics

2013 OWHA Provincials Thursday, May 23, 2013

Debugging message: Couldn't get Schedule array. Class:Division, Method: getDivisionScheduleDataArray

Query execution problem.

Website Error. To inform ITSportsNet please fill out the form below.

Support Case
Contact Name:
Email:
Subject:
Description:	____________________________________ Enter your description above this line. An error occured on page www.itsportsnet.com/league.php?scriptName=SUBDIVISIONSCHEDULE&leagueID=9804&divisionID=81236&sportID=2&seasonID=8718&subDiv=R <br />from: 192.168.1.115<br />Error code was: QUERYEXECUTIONERROR<br />Error message was: Query execution problem.<p />Debugging Message: Couldn't get Schedule array. Class:Division, Method: getDivisionScheduleDataArray<p />Statement was: SELECT game.GameDate, game.GameTime, game.FieldID, ITDivision.DivisionName, team1.TeamName as homeTeam, game.GameHomeScore, team2.TeamName as visitorTeam, game.GameVisitorScore, game.GameID, game.GameHomeTeamID,game.GameVisitorTeamID, game.GameStatus, game.GameRainOut, game.GameHomeDefault, game.GameVisitorDefault, ITLocation.MapType, ITLocation.MapURL, game.GameWinnerHome,game.GameWinnerVisitor, game.GameCupGameNumber,game.GameLength, game.GameCupSection,game.GameSheetReceived,game.GameType, game.GameHomeAlias,game.GameVisitorAlias,game.GamePoints, ITLocation.FieldName, ITLocation.FieldCode,game.VisitorDivisionID,game.DivisionID FROM ITGame as game LEFT JOIN ITLocation ON game.FieldID=ITLocation.FieldID LEFT JOIN ITDivision ON game.DivisionID = ITDivision.DivisionID LEFT JOIN ITTeam as team1 ON game.GameHomeTeamID = team1.TeamID LEFT JOIN ITTeam as team2 ON game.GameVisitorTeamID = team2.TeamID LEFT JOIN ITReferee R1 ON R1.RefereeID=game.GameRefereeID1 LEFT JOIN ITReferee R2 ON R2.RefereeID=game.GameRefereeID2 LEFT JOIN ITReferee R3 ON R3.RefereeID=game.GameRefereeID3 WHERE ITDivision.DivisionID= '81236' AND game.DivisionID='81236' AND () AND game.GameType!='Practice' ORDER BY game.GameDate, game.GameTime

Fail To get League Sport ID