WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: LeagueManager] No Fixtures Showing (48 posts)

  1. aidanmcg33
    Member
    Posted 5 years ago #

    Hi IM using 2.7 and version 2.5.2 of the leaguemanager plugin. I had used the latest one but nothing would display correctly with this version so i referred to the older one. I have got my tables displaying ok but no matches will show up. they are listed on the database ok but dont appear on the admin panel or on the posts when i use the necessary tags. When i used the new version, i had added league tables etc but when i used the tags my posts wouldnt finish displaying on the main page, they just froze when loading as if a php error had occured.

  2. Kolja
    Member
    Posted 5 years ago #

    I'm sorry, but I don't have the time to support older versions, also because I have made major changes to the plugin in Version 2.6. I have just released Version 2.6.1 with some bugfixes.

    what php version do you have? Also a dump of the database structure would be helpful.

  3. Kolja
    Member
    Posted 5 years ago #

    I just discovered that there was an upgrade bug in 2.6 (also in 2.6.1). I fixed this in 2.6.2. Hope it works

  4. aidanmcg33
    Member
    Posted 5 years ago #

    i upgraded to the new version and still the exact same problems with no fixtures appearing and no tables being shown in the posts. overview of all my leagues show the league as having 15 matches but these arent displayed anywhere.

  5. giovanirinoceronti
    Member
    Posted 5 years ago #

    Same problems for me after updating (WP ver. 2.63)

  6. YukataNinja
    Member
    Posted 5 years ago #

    My leaguemanager also breaks now that I have updated.

    I try inserting
    [leaguestandings league_id=3 mode=extend]
    and the page will stop loading at that point.

  7. aidanmcg33
    Member
    Posted 5 years ago #

    On initial inspection, there are a lot of fields missing from the database tables. Adding these, still hasnt fixed the problems but it did get rid of all the errors when i turned on debugging.

  8. aidanmcg33
    Member
    Posted 5 years ago #

    I completely removed the plugin and the database tables and added it again. The backend works alot better and the matches showed fine, but the front end doesnt work at all. If i include the plugin in a post or a page, the entire page gets past loading the website header and then thats it.

  9. Kolja
    Member
    Posted 5 years ago #

    It should be fixed in 2.6.3. Somehow there was a bug that one upgrade process was not called and so several database fields were missing.

  10. aidanmcg33
    Member
    Posted 5 years ago #

    is it just the database part that has been fixed or all of it?

  11. Kolja
    Member
    Posted 5 years ago #

    what other part do you mean? I also had the problem on one site that no teams and matches were displayed after upgrading, neither on the admin panel nor on the frontpage. Then i discovered that the following two MySQL queries were not called during the upgrade process.

    $wpdb->query( "ALTER TABLE {$wpdb->leaguemanager_matches} ADDpost_idint( 11 ) NOT NULL" );

    $wpdb->query( "ALTER TABLE {$wpdb->leaguemanager_teams} ADDpoints_plusint( 11 ) NOT NULL, ADDpoints_minusint( 11 ) NOT NULL, ADDpoints2_plusint( 11 ) NOT NULL, ADDpoints2_minusint( 11 ) NOT NULL, ADDdone_matchesint( 11 ) NOT NULL, ADDwon_matchesint( 11 ) NOT NULL, ADDdraw_matchesint( 11 ) NOT NULL, ADDlost_matchesint( 11 ) NOT NULL" );

    Now they should be called. Otherwise just post the above code in the functions.php of your theme and reload any admin page. Afterwards it should work.

  12. aidanmcg33
    Member
    Posted 5 years ago #

    i upgraded and the pages still do not work. the admin panel seems fine but its the front end that should be showing the league tables that doesnt work.

  13. Kolja
    Member
    Posted 5 years ago #

    And there is no error message? You could try something. Download version 2.6.2 und only upload the folder view into the plugin folder

  14. mattface89
    Member
    Posted 5 years ago #

    The same happens to my update. A fatal error occurs when you try to display anything in a post or page.

    Also when you add a team or match, the entry's are duplicated.

  15. YukataNinja
    Member
    Posted 5 years ago #

    I have updated to 2.6.3 and nothing loads. When I use the admin page it lists all the leagues and numbers, but when I go to a specific league it displays nothing at all.

  16. Kolja
    Member
    Posted 5 years ago #

    It is likely that i screwed up version 2.6.3 and alread had some new MySQL Queries included. I hope i got it right now with 2.6.4 (originating from 2.6.3 with only the database upgrade). Further I turned on mysql errors. I have also fixed the team logo issue.

  17. aidanmcg33
    Member
    Posted 5 years ago #

    No, still doesnt work. I dont mean to knock you but what sort of testing are you carrying out on this plugin? I know it's a lot of work trying to maintain these things and id love to offer my services but im flat out at the minute myself, but there does seem to be more testing needed.

  18. ntrance
    Member
    Posted 5 years ago #

    I have a problem with 2.6.4

    Fatal error: No parent class available in /home/sites/LOCALHOST/public_html/wp-content/plugins/leaguemanager/view/standings.php on line 51

    I also had to edit the database,I think I'm also missing the plain old
    wp_leaguemanager table

    All I have is
    wp_leaguemanager_leagues
    wp_leaguemanager_matches
    wp_leaguemanager_teams

    Also where would you set the new sports up, i.e snooker,pool etc

    Thanks in advance

  19. YukataNinja
    Member
    Posted 5 years ago #

    Updated to 2.6.4 and in the admin program I have these errors:

    WordPress database error: [Unknown column 'points_plus' in 'field list']
    SELECT title, short_title, logo, home, points_plus, points_minus, points2_plus, points2_minus, done_matches, won_matches, draw_matches, lost_matches, league_id, id FROM wp_leaguemanager_teams WHERE league_id = "1" ORDER BY id ASC

    WordPress database error: [Unknown column 'post_id' in 'field list']
    SELECT home_team, away_team, DATE_FORMAT(date, '%Y-%m-%d %H:%i') AS date, DATE_FORMAT(date, '%e') AS day, DATE_FORMAT(date, '%c') AS month, DATE_FORMAT(date, '%Y') AS year, DATE_FORMAT(date, '%H') AS hour, DATE_FORMAT(date, '%i') AS minutes, match_day, location, league_id, home_apparatus_points, away_apparatus_points, home_points, away_points, winner_id, post_id, id FROM wp_leaguemanager_matches WHERE league_id = "1" ORDER BY date ASC

    Hopefully this helps. Also, if you can provide the table structures I can compare and see if there are any other differences.

  20. Kolja
    Member
    Posted 5 years ago #

    I don't understand this. OK, it's all about the database that the columns are for some reasons not created. I have tested 2.6.5! If you update and reload the page there should come a message that your database is out-of-date and needs updating. After doing the upgrade there should be the following fields (among others):

    points_plus, points_minus, points2_plus, points2_minus, done_matches, won_matches, draw_matches, lost_matches

    All int( 11 ). For me it worked perfectly fine, so i really hope I got it right now.

  21. giovanirinoceronti
    Member
    Posted 5 years ago #

    Updated to 2.6.5 and works perfectly !!!!
    Thanks :-)

  22. Kolja
    Member
    Posted 5 years ago #

    I'm really happy to hear that 2.6.5 works now. :) I was so confused...

    I forgot to mention something. The team points etc are now stored in the database (previously were calculated on the fly). This made it possible to implement a function to manually save the team standings. Just update the match results once and it should be fine.

  23. YukataNinja
    Member
    Posted 5 years ago #

    I upgraded to 2.6.5 and still have the same error. I do not see any message about upgrading my database. How do I get that message to show? What I'm doing is going to the wp-admin -> league -> choosing league 1 and then I see the error.

  24. Kolja
    Member
    Posted 5 years ago #

    the upgrade screen should be shown if you visit any leaguemanager admin site... Could you put the following code into functions.php of your theme and post the output:

    echo $options['dbversion'].", ".LEAGUEMANAGER_DBVERSION

    What WordPress and PHP version do you have?

  25. Kolja
    Member
    Posted 5 years ago #

    before that do:

    <?php $options = get_option('leaguemanager'); ?>

  26. aidanmcg33
    Member
    Posted 5 years ago #

    the front end is still not working for me. ive put in them 2 lines also that you listed before and i get 2.6.5 and 2.6.5
    Ive updated to the latest version of the plugin and wordpress and have php5.

  27. aidanmcg33
    Member
    Posted 5 years ago #

    Just completely removed the plugin and added it again and now the front end shows but the league tables dont. i just get plain text [leaguestandings=1] etc

  28. YukataNinja
    Member
    Posted 5 years ago #

    Looking in my wp_options they are 2.6.5 and 2.6.5. I tried deactivate the plugin, remove it, manually edit wp_options to be 2.6.4 and 2.6.4 and then installed 2.6.4, then upgrade to 2.6.5 and the database was still missing the new columns. wp_options become 2.6.5 and 2.6.5 after the upgrade.

  29. Kolja
    Member
    Posted 5 years ago #

    @YukataNinja: looking in the wp_options table doesn't help, because these two numbers are the leaguemanager version and dbversion. The first is the plugin version whereas the second checks if there are any changes to the database (and should then display an upgrade screen on a leaguemanager admin page).

    You can do the following. In admin/admin.php look for function display(). Change

    if( $options['dbversion'] != '2.6.5' ) {

    into

    if( $options['dbversion'] != '2.6' ) {

    Then go to the leaguemanager admin page or reload the page if you are already there. There should be an upgrade page displayed, telling you that your database is out-of-date. Do the upgrade.

  30. Kolja
    Member
    Posted 5 years ago #

    @aidanmcg33: use

    [leaguestandings league_id=x mode=extend|compact]

    where x is the league ID you want to display. mode is either extend or compact

Topic Closed

This topic has been closed to new replies.

About this Topic