USER WARNING: Error in leaguesite

Hi bwax, thanks for the error report - this is actually for a block which I haven't completed.
I will makr it as a task which I will get around to finishing.
Thanks
Alun

The easiest way is to not display the block on the blocks page :-)

Hey Alun,

Great module so far. I too am getting a "user warning error" ...

user warning: Unknown column 'leaguesite_standings.won_home' in 'field list' query: SELECT leaguesite_standings.*, node.title, node.nid, (leaguesite_standings.won_home + leaguesite_standings.won_home) + (leaguesite_standings.drawn_home + leaguesite_standings.drawn_away) + (leaguesite_standings.lost_home + leaguesite_standings.lost_away) AS played , ((leaguesite_standings.won_home + leaguesite_standings.won_home) * leaguesite_sports.win) + ((leaguesite_standings.drawn_home + leaguesite_standings.drawn_away)*leaguesite_sports.draw) + ((leaguesite_standings.lost_home + leaguesite_standings.lost_away)*leaguesite_sports.loss) + (leaguesite_standings.bonus_home + leaguesite_standings.bonus_away) AS points FROM leaguesite_standings LEFT JOIN leaguesite_relation ON leaguesite_standings.relation_id = leaguesite_relation.relation_id LEFT JOIN node ON leaguesite_standings.team_id = node.nid LEFT JOIN leaguesite_league ON leaguesite_relation.lid = leaguesite_league.lid LEFT JOIN leaguesite_sports ON leaguesite_league.sport_id = leaguesite_sports.sport_id WHERE leaguesite_relation.relation_id = 7 AND leaguesite_relation.relation_type = 'league' ORDER BY points DESC, (leaguesite_standings.goals_for_home + leaguesite_standings.goals_for_away) DESC in /sites/all/modules/leaguesite/leaguesite_league/leaguesite.inc on line 72.

Thanks, Jeff

Thanks Sill, have you updated your database since using the latest release?
Although I can see that there is a problem there anyway, so I'll take a look at the code and update it.
Thanks
Alun

Hi Alun,

I just updated the database and the warning went away. I thought it was suppose to update automagically but I guess it didn't. Thanks for the help!

Sorry to be a pain but I found another one that I can't figure out.... It's when I'm trying to look at the League Rankings from views. I'm using just the default "League Rankings" view. I've tried modifying the view for my specific league and get the same result.

Thanks,
Jeff

user warning: Unknown column 'leaguesite_standings.won' in 'field list' query: SELECT node.nid AS nid, node.title AS node_title, leaguesite_standings.won AS leaguesite_standings_won, leaguesite_standings.lost AS leaguesite_standings_lost, leaguesite_standings.drawn AS leaguesite_standings_drawn, leaguesite_standings.goals_against AS leaguesite_standings_goals_against, leaguesite_standings.bonus AS leaguesite_standings_bonus, leaguesite_sports.win AS leaguesite_sports_win, leaguesite_sports.draw AS leaguesite_sports_draw, leaguesite_sports.loss AS leaguesite_sports_loss, (leaguesite_standings.won * leaguesite_sports.win) + (leaguesite_standings.lost * leaguesite_sports.loss) + (leaguesite_standings.drawn * leaguesite_sports.draw) + leaguesite_standings.bonus AS leaguesite_standings_points_sort, won + lost + drawn AS leaguesite_standings_played, goals_for - goals_against AS leaguesite_standings_points_difference FROM node node LEFT JOIN leaguesite_standings leaguesite_standings ON node.nid = leaguesite_standings.team_id LEFT JOIN leaguesite_relation leaguesite_relation_league ON leaguesite_standings.relation_id = leaguesite_relation_league.relation_id LEFT JOIN leaguesite_season leaguesite_season ON leaguesite_relation_league.sid = leaguesite_season.sid LEFT JOIN leaguesite_league leaguesite_league ON leaguesite_relation_league.lid = leaguesite_league.lid LEFT JOIN leaguesite_sports leaguesite_sports ON leaguesite_league.sport_id = leaguesite_sports.sport_id WHERE leaguesite_season.name in ('Spring League') ORDER BY leaguesite_standings_points_sort DESC, leaguesite_standings_played ASC, leaguesite_standings_won DESC, leaguesite_standings_points_difference DESC, node_title ASC in /sites/all/modules/views/includes/view.inc on line 775.

This is down to the change in the database - I added views handlers to sort this out, but you might need to check your fields in Views to ensure you are displaying the right ones and handlers exist.
I'll have a look at my files when I can and ensure the handlers are all correct.
Thanks
Alun