So,
Today I updated LeagueManager from 4.0.9 to 4.1. The issue about repeated matches and standing tables has gone. That′s the good news.
The bad news is that I can′t update any match result. I got this error message:
Error en la base de datos de WordPress: [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 wp2_leaguemanager_matches WHERE league_id
= ’15’ AND season
= ‘Campeonato Nacional 2016’ AND final
= ” AND match_day
= ‘3’ ORDER BY date
ASC,id
ASC LIMIT -10,10
Any ideas?
Thanks!