Hi there!

Congrats again for this fantastic module!

I have upgraded the module to the latest dev version 6.x.-1.x 23rd of Dec. It worked fine for me, but I have just found the view League Rankings has not been updated to the new structure of the leaguesite_standings table. Am I missing something?

CommentFileSizeAuthor
#10 leaguesite_league.patch48.38 KBAlun

Comments

Alun’s picture

Alun commented
Status: Active » Fixed

Hi ayukko,

No you are not missing something. I kept the view in there the same, changing it can cause problems for people using the view, so I decided to leave it be. If you want to use the away and home fields separately, they are available in Views, you just need to edit the view.
Let me know if this works out OK for you.
Thanks
Alun

ayukko’s picture

ayukko commented

Hi Alun!

That is ok for me as long as the "total" fields are computed allright. I mean, if the fields "games won", "lost" etc. are calculating the sum of those matches played at home and away. This could be sufficient for my page -phase one, but for phase two I would like to have access to all fields so I could make a new page displaying the information I need the way I need it. Don't know much about php, but I guess I should have to enter some code lines somewhere, if you just point me to the right direction I could give it a try and post it here for other users needs.

Thanks,
Maria

Alun’s picture

Alun commented

Both the home, away and total are all available in Views. You don't need to do any programming, they are all available in the field. Is that what you need when you say you need access to information?

ayukko’s picture

ayukko commented

I see, got you know.... Thanks again for your support!

ayukko’s picture

ayukko commented

Hi again

I have tried to build my own view based on the fields provided by "Leaguesite standings" in the Views UI and I get this error message when clicking the button "save".

* user warning: Unknown column 'leaguesite_standings.won' in 'field list' query: SELECT COUNT(*) FROM (SELECT DISTINCT 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.goals_for AS leaguesite_standings_goals_for, 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, node.title AS node_title, node.nid AS nid 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_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 ) count_alias in /etc/drupal/6/sites/all/modules/views/plugins/views_plugin_pager.inc on line 142.
* user warning: Unknown column 'leaguesite_standings.won' in 'field list' query: SELECT DISTINCT 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.goals_for AS leaguesite_standings_goals_for, 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, node.title AS node_title, node.nid AS nid 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_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 LIMIT 0, 10 in /etc/drupal/6/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1137.

When I delete that field, the View is saved normally.

Alun’s picture

Alun commented
Title: League Rankings view update » leaguesite_standings.won flagged as unknown column
Status: Fixed » Active

That sounds like a plugin problem, It will have to be patched. I'll re-open this issue.
Technically, I should create a new issue, but I'm lazy :-)
Thanks
Alun

ayukko’s picture

ayukko commented

Ok. Thanks a lot Alun!

ayukko’s picture

ayukko commented

Hi there!

Just a friendly reminder this bug is still bitting! Let me know if I can be in some help.

Alun’s picture

Alun commented

Hmm, this is strange, I could have sworn that I added views files for the new database layout, yet I cannot find them.
I'm going to have to write all these files to handle the database querying through Views.
I'll get this up when I can.
Thanks!
Alun

Alun’s picture

Alun commented
StatusFileSize
new leaguesite_league.patch48.38 KB

Here is a patch, the repository has been updated
Let me know of any problems that occur, but it shouldn't take so long to fix them now the bulk of the work is done!
Alun

Alun’s picture

Alun commented
Status: Active » Fixed
ayukko’s picture

ayukko commented

Hi there again!

I haven't tested the patch, just upgraded to the lastest dev version and could add the "won" column to my view.

Thanks a lot!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.