LeagueSync.com
LeagueSync Forums - Bugs / Issues
Forums    >    Website Discussions    >    Bugs / Issues
Trying to add scorecard - getting php errors
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
17 months 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
16 months ago   2017-06-03
 
Page 1
Please Wait...
Login
Email or League ID
Password
Remember Me
SupportPrivacy PolicyContact UsAdvertise With UsFeaturesAbout Us
2004-13 © LeagueSync.com   All rights reserved.    Version 2.06.02