[Plugin: LeagueManager] ???Again?

shortd81
(@shortd81)

15 years, 2 months 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

Viewing 10 replies - 1 through 10 (of 10 total)

yukataninja
(@yukataninja)

15 years, 2 months 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>
```
Thread Starter shortd81
(@shortd81)

15 years, 2 months ago

and how do you do that?

K
(@koelle)

15 years, 2 months 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.

sturm12
(@sturm12)

15 years, 2 months 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>

K
(@koelle)

15 years, 2 months ago

What MySQL Version do you have?

sturm12
(@sturm12)

15 years, 2 months ago

MySQL-Client-Version: 5.0.27

azubi
(@azubi)

15 years, 2 months 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 🙁

K
(@koelle)

15 years, 2 months ago

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

K
(@koelle)

15 years, 2 months 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.

azubi
(@azubi)

15 years, 2 months ago

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