PHP error 2: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given, from /home-persistent/smulligan/leagueleader/tags/127/hcpgen.php:299 CREATE TEMPORARY TABLE IF NOT EXISTS `ps_bf926d5c-f2c8-459d_0_0_1_details` ENGINE=MyISAM SELECT PlayerStat.PlayerStatId AS `PlayerStatId`,PlayerStat.PlayerId AS `PlayerId`,IFNULL(Team.TeamId,-1) AS `TeamId`,IFNULL(Division.DivisionId,IFNULL(playedDivision.DivisionId,-1)) AS `DivisionId`,IFNULL(League.LeagueId,-1) AS `LeagueId`,MatchStat.MatchStatId AS `MatchStatId`,SetStat.SetNumber AS `SetNumber`,PlayerStatError.PlayerName AS `ErrorPlayerName`,Player.LastName AS `LastName`,Player.FirstName AS `FirstName`,TeamStatError.TeamName AS `ErrorTeamName`,Team.Name AS `TeamName`,'{Substitutes}' AS `DefaultTeamName`,PlayerStat.TotalPoints AS `TotalPoints`,PlayerStat.TotalDarts AS `TotalDarts`,PlayerStat.`Games` AS `Games`,PlayerStat.`Wins` AS `Wins`,SUM(IF(PlayerFeat.FeatId=19,PlayerFeat.Value,0)) AS `Hat`,SUM(IF(PlayerFeat.FeatId=21,PlayerFeat.Value,0)) AS `3BD`,SUM(IF(PlayerFeat.FeatId=22,PlayerFeat.Value,0)) AS `Ton80`,SUM(IF(PlayerFeat.FeatId=23,PlayerFeat.Value,0)) AS `HTon`,SUM(IF(PlayerFeat.FeatId=24,PlayerFeat.Value,0)) AS `LTon`,SUM(IF(PlayerFeat.FeatId=2,PlayerFeat.Value,0)) AS `6DO`,SUM(IF(PlayerFeat.FeatId=3,PlayerFeat.Value,0)) AS `7DO`,SUM(IF(PlayerFeat.FeatId=4,PlayerFeat.Value,0)) AS `8DO`,SUM(IF(PlayerFeat.FeatId=5,PlayerFeat.Value,0)) AS `9DO` FROM PlayerStat FORCE INDEX (IDX_SetStatId) INNER JOIN SetStat ON (PlayerStat.SetStatId=SetStat.SetStatId AND SetStat.Ignored=FALSE) LEFT JOIN Player ON (Player.PlayerId=PlayerStat.PlayerId) LEFT JOIN PlayerStatError ON (PlayerStatError.PlayerStatId=PlayerStat.PlayerStatId) LEFT JOIN TeamStat ON (TeamStat.SetStatId=SetStat.SetStatId AND PlayerStat.HomeAway=TeamStat.HomeAway) LEFT JOIN TeamStatError ON (TeamStatError.TeamStatId=TeamStat.TeamStatId) LEFT JOIN Team AS playedTeam ON (playedTeam.TeamId=TeamStat.TeamId) LEFT JOIN Division AS playedDivision ON (playedTeam.DivisionId=playedDivision.DivisionId) INNER JOIN MatchStat ON (SetStat.MatchStatId=MatchStat.MatchStatId) CROSS JOIN (SELECT 0 AS TeamId, 0 AS DivisionId, 'All' AS Name) AS Team CROSS JOIN (SELECT 0 AS DivisionId, 0 AS LeagueId, 'All' AS Name) AS Division CROSS JOIN (SELECT 0 AS LeagueId, 1 AS Active, 'All' AS ShortName) AS League LEFT JOIN LeagueHCP ON (LeagueHCP.LeagueId=League.LeagueId) LEFT JOIN PlayerHandicap AS accurateHandicap ON (accurateHandicap.LeagueId=League.LeagueId AND accurateHandicap.PlayerId=PlayerStat.PlayerId AND accurateHandicap.GameId=SetStat.GameId AND accurateHandicap.Darthead=PlayerStat.Darthead AND accurateHandicap.DoubleBull=PlayerStat.DoubleBull) LEFT JOIN PlayerHandicap AS genericHandicap ON (genericHandicap.LeagueId=League.LeagueId AND genericHandicap.PlayerId=PlayerStat.PlayerId AND genericHandicap.GameId=0 AND genericHandicap.Darthead=0 AND genericHandicap.DoubleBull=-1) LEFT JOIN PlayerFeat ON (PlayerFeat.PlayerStatId=PlayerStat.PlayerStatId) LEFT JOIN dartbro_main.Feat ON (PlayerFeat.FeatId=dartbro_main.Feat.FeatId) INNER JOIN dartbro_main.Game ON (dartbro_main.Game.GameId=SetStat.GameId) WHERE MatchStat.LeagueId IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,125,126,124,123,121,122,119,120,114,115,116,127,128,129,130,131,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,297,293,196,197,198,199,284,201,283,203,282,205,279,207,278,209,276,211,275,213,281,215,280,217,285,219,295,221,294,223,291,225,226,227,228,229,290,231,289,233,288,235,287,237,286,239,299,241,298,243,274,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,296,269,292,271,272,273,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,337,338,343,342,345,344,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,368,369,370,371,372,373,374,375,376,377,378,379,380,381) AND dartbro_main.Game.GameTypeId=1 AND SetStat.PlayedDate>='2020-02-03' AND SetStat.PlayedDate<='2020-02-18' GROUP BY PlayerStat.PlayerStatId ORDER BY PlayerStat.PlayerId,MatchStat.Week,MatchStat.MatchStatId,SetStat.SetNumber
LeagueLeader Error
It would seem that LeagueLeader has encountered an error:
URI: /sharedreport.php?operatorid=965&code=902083bd-c40d-4221-87df-43b816419a8f

File: PlayerStandings.php(1935) : eval()'d code:1
MySQL Error:

Unknown column 'SetStat.Ignored' in 'on clause'


Please contact Arachnid and tell us what you were doing.