Title: WordPress-Datenbank-Fehler: Last modified: August 31, 2016 --- # WordPress-Datenbank-Fehler: * Resolved [Daniel78](https://wordpress.org/support/users/daniel78/) * (@daniel78) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/) * Ich bekomme nach dem Update eine Fehlermeldung. Wer kann diese Meldung interpretieren. * ordPress-Datenbank-Fehler: [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‘- 14,14’ at line 1] SELECT `group`, `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`, `winner_id`, `loser_id`, `post_id`, `season`, `id`,` custom` FROM wp_leaguemanager_matches WHERE `league_id` = ’24’ AND `season` =‘ 2015/16’ AND `final` = ” AND (`home_team` = ’83’ OR `away_team` = ’83’) ORDER BY `date` ASC,`id` ASC LIMIT -14,14 * [https://wordpress.org/plugins/leaguemanager/](https://wordpress.org/plugins/leaguemanager/) Viewing 11 replies - 1 through 11 (of 11 total) * [thubu](https://wordpress.org/support/users/thubu/) * (@thubu) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137095) * I’ve got the same error message by installing in a complete fresh setup of a WP installation. * Thread Starter [Daniel78](https://wordpress.org/support/users/daniel78/) * (@daniel78) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137136) * Offenbar wird die Fehlermeldung verursacht, wenn ich auf einer Seite mindestens zwei Ligen (matches league_id=10, matches league_id=12) eingebunden habe. * Was ist zu tun ? * Plugin Author [K](https://wordpress.org/support/users/koelle/) * (@koelle) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137183) * Das Problem kam durch das caching, aber sollte behoben sein * [silral](https://wordpress.org/support/users/silral/) * (@silral) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137184) * Ich habe einen ähnlichen Fehler, nach dem Update auf die neue 4.1 Version, wenn ich ein Match aufrufe, siehe auf meiner Hauptseite. * Meldung: * WordPress-Datenbank-Fehler: [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 ‘-10,10’ at line 1] SELECT `group`, `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`, `winner_id`, `loser_id`, `post_id`,` season`, `id`, `custom` FROM wp_leaguemanager_matches WHERE `final` = ” AND (` home_team` = ‘1’ OR `away_team` = ‘1’) AND TIMESTAMPDIFF(MINUTE, NOW(), `date`) >= 0 ORDER BY `date` ASC,`id` ASC LIMIT -10,10 * [silral](https://wordpress.org/support/users/silral/) * (@silral) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137185) * [Hier noch der Link](http://silral.net) * Es scheint wohl was mit der Datumseinstellung zu tun zu haben. In der Liga-Einstellung wird auch kein Match mehr angezeigt, bei keinem Spieltag. * [thubu](https://wordpress.org/support/users/thubu/) * (@thubu) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137191) * Bei mir wird ebenfalls nach dem Update der Fehler angezeigt und bei den Spieltagen werden keine Matsches ausgegeben im BE. * [cphil123](https://wordpress.org/support/users/cphil123/) * (@cphil123) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137196) * Hello, * this problem is a fault in the query (…LIMIT -10,10) on the number of matches to display in the page * it is resolved in the tab preferably competition match the number of “0” * Plugin Author [K](https://wordpress.org/support/users/koelle/) * (@koelle) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137200) * Hi, * this should be fixed in 4.1.1 * [thubu](https://wordpress.org/support/users/thubu/) * (@thubu) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137201) * Thanks for the great support. The fix is perfect, works as designed. * [silral](https://wordpress.org/support/users/silral/) * (@silral) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137205) * danke Kolja, alles perfekt, wie immer tolle Arbeit von dir. * Plugin Author [K](https://wordpress.org/support/users/koelle/) * (@koelle) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137230) * great Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘WordPress-Datenbank-Fehler:’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/leaguemanager.svg) * [LeagueManager](https://wordpress.org/plugins/leaguemanager/) * [Frequently Asked Questions](https://wordpress.org/plugins/leaguemanager/#faq) * [Support Threads](https://wordpress.org/support/plugin/leaguemanager/) * [Active Topics](https://wordpress.org/support/plugin/leaguemanager/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/leaguemanager/unresolved/) * [Reviews](https://wordpress.org/support/plugin/leaguemanager/reviews/) * 11 replies * 5 participants * Last reply from: [K](https://wordpress.org/support/users/koelle/) * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-datenbank-fehler/#post-7137230) * Status: resolved