When we click on Add Scorecards we get this: A PHP Error was encountered Severity: Notice Message: Undefined variable: season Filename: edit/edit_teams_division.php Line Number: 45 A PHP Error was encountered Severity: Notice Message: Undefined variable: stype Filename: edit/edit_teams_division.php Line Number: 46 A PHP Error was encountered Severity: Notice Message: Undefined variable: period Filename: edit/edit_teams_division.php Line Number: 47 A PHP Error was encountered Severity: Notice Message: Undefined variable: round Filename: edit/edit_teams_division.php Line Number: 48 A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `b_scorecard`.`team` > 0 AND `b_scorecard`.`deleted` = 0 AND `method` = 10' at line 9 SELECT `b_scorecard`.`team`, SUM(`b_scores`.`teampoints`) AS sp FROM (`b_scorecard`) JOIN `b_scores` ON `b_scorecard`.`roundid` = `b_scores`.`roundid` WHERE `b_scorecard`.`leagueid` = 6419 AND `b_scorecard`.`season` IS NULL AND `b_scorecard`.`stype` IS NULL AND `period` IS NULL AND `round` <= AND `b_scorecard`.`team` > 0 AND `b_scorecard`.`deleted` = 0 AND `method` = 10 AND `roundtype` <= 127 GROUP BY `b_scorecard`.`team` ORDER BY `sp` DESC Filename: views/schedule/edit/edit_teams_division.php Line Number: 57 A PHP Error was encountered Severity: Warning Message: Cannot modify header information - headers already sent Filename: core/Common.php Line Number: 442 A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `b_scorecard`.`team` > 0 AND `b_scorecard`.`deleted` = 0 AND `method` = 10' at line 9 SELECT COUNT(*) AS `numrows` FROM (`b_scorecard`, `sessions`) JOIN `b_scores` ON `b_scorecard`.`roundid` = `b_scores`.`roundid` WHERE `b_scorecard`.`leagueid` = 6419 AND `b_scorecard`.`season` IS NULL AND `b_scorecard` | Author: Rich Haynes 7 years ago 2017-05-26 |
Found the problem. We were trying to add week 5 scorecards which in our league is a position night. So we hd it marked as a knockout round - not a regular schedule week. It looks like the code for the knockout round has an issue. Switched it to a regular week, edited the schedule to make it match out matches for position night and everything works. | Author: Rich Haynes 7 years ago 2017-06-03 |