[Plugin: LeagueManager] ???Again?

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>

and how do you do that?

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

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>

What MySQL Version do you have?

MySQL-Client-Version: 5.0.27

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 ??

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

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.

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