WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: LeagueManager] ???Again? (11 posts)

  1. shortd81
    Member
    Posted 5 years ago #

    Can you tell me why everytime I Update this it messes up my ENTIRE BLOG? Getting this so you know:

    WordPress database error: [Unknown column 'point_rule' in 'field list']
    SELECT point_rule, point_format, type, num_match_days FROM wp_leaguemanager_leagues WHERE id = '7'

    WordPress database error: [Unknown column 'point_rule' in 'field list']
    SELECT point_rule, point_format, type, num_match_days FROM wp_leaguemanager_leagues WHERE id = '7'

    Warning: Cannot modify header information - headers already sent by (output started at /home/mrswagga/public_html/wp-includes/wp-db.php:517) in /home/mrswagga/public_html/wp-content/plugins/wassup/wassup.php on line 1434

  2. YukataNinja
    Member
    Posted 5 years ago #

    I had the same text showing on top of all of my admin pages until I updated the database, which gave this error:

    WordPress database error: [Can't DROP 'match_calendar'; check that column/key exists]
    ALTER TABLE wp_leaguemanager_leagues DROP <code>match_calendar</code>
  3. shortd81
    Member
    Posted 5 years ago #

    and how do you do that?

  4. Kolja
    Member
    Posted 5 years ago #

    go to a Leaguemanager Admin page. There should be shown a message that your database is out-of-date together with an upgrade button.

  5. Sturm12
    Member
    Posted 5 years ago #

    Hi Koelle, your Plugin works perfectly fine with me. The only problem I have is, when inserting the standings as a widget it shows the following text before displaying the table as it should be. What can I do to get rid of it

    WordPress database error: [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 '(NOW(), date) < 0 AND (home_team = 1 OR away_team = 1) OR]
    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_points, away_points, overtime, penalty, winner_id, post_id, points2, id FROM wp_leaguemanager_matches WHERE league_id = '1' AND DATEDIFF(NOW(), date) < 0 AND (home_team = 1 OR away_team = 1) ORDER BY date ASC</ blockquote>

  6. Kolja
    Member
    Posted 5 years ago #

    What MySQL Version do you have?

  7. Sturm12
    Member
    Posted 5 years ago #

    MySQL-Client-Version: 5.0.27

  8. Azubi
    Member
    Posted 5 years ago #

    The same problem in my blog. On top in the administration it writes 4times and on top in the blog 2times:

    WordPress database error: [Unknown column 'type' in 'field list']
    SELECT point_rule, point_format, type, num_match_days FROM urenkel_leaguemanager_leagues WHERE id = '1'

    The plugin says in the option menue:

    Anzahl Spieltage [] Du musst die Anzahl der Wettkampftage bestimmen, um dieses Feature zu nutzen.

    But it does not save anything :-(

  9. Kolja
    Member
    Posted 5 years ago #

    which Plugin version do you use? Did you upgrade or newly installed it?

  10. Kolja
    Member
    Posted 5 years ago #

    You can put the following line, e.g. in functions.php of your theme to add the missing field

    $wpdb->query( "ALTER TABLE {$wpdb->leaguemanager} ADD type tinyint( 1 ) NOT NULL default '2';" );

    However please report your plugin version and if you upgraded or newly installed it so I can check again for a bug.

  11. Azubi
    Member
    Posted 5 years ago #

    My old version was 2.7.1 but with the newest 2.8 it seems to work well again. Thank You!

Topic Closed

This topic has been closed to new replies.

About this Topic