Database Error Message

  • Resolved thubu

    (@thubu)


    9 years ago

    By setup of the LeagueManager plugin i see the following error message in the BE by using the LM:

    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

    This was also reported in a post before. Are there any news for this error message ?

    Thanks

    https://www.ads-software.com/plugins/leaguemanager/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author K

    (@koelle)

    Im working on it, but please don’t double post

    roque2

    (@roque2)

    i have the same problem but mine has a limit of -10,10 so when i add more than 10 teams, i am unable to access the league name link hence i can not see the teams i added nor add another team. when i click the league name the site keeps loading to infinity. Other league manager links works…

    roque2

    (@roque2)

    [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] here is the error

    Thread Starter thubu

    (@thubu)

    Thanks for the great support. The fix is perfect, works as designed.

    roque2

    (@roque2)

    thanks alot Kolja

    Plugin Author K

    (@koelle)

    you’re welcome

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database Error Message’ is closed to new replies.