WordPress.org

1. shortd81
   Member
   Posted 3 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 3 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 3 years ago #

   and how do you do that?

4. Kolja
   Member
   Posted 3 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 3 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 3 years ago #

   What MySQL Version do you have?

7. Sturm12
   Member
   Posted 3 years ago #

   MySQL-Client-Version: 5.0.27

8. Azubi
   Member
   Posted 3 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 3 years ago #

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

10. Kolja
    Member
    Posted 3 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 3 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.