search

petlof / liveresults

EmmaClient is a client-server system for publishing liveresults from Orienteering events. It have been used on many major events such as JWOC, WOC, EOC,..
http://liveresultat.orientering.se
GNU Lesser General Public License v3.0
40 stars 24 forks source link

Error from API when requesting total results from stage 1 of a multi-day-competition #22

Closed petlof closed 7 years ago

petlof commented 7 years ago

RestClient: Uri request:http://liveresultat.orientering.se//api.php?comp=12548&method=getclassresults&unformattedTimes=true&class=D40&includetotal=true

D/RestClient: request() responseCode:200 06-16 17:11:39.167 3339-3583/se.amli.liveresultsorienteering D/RestClient: request() responseCode:200 06-16 17:11:39.167 3339-3584/se.amli.liveresultsorienteering D/RestClient: request() response: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 ') AND runners.TavId = results.TavId AND runners.Class = 'D40' ORDER BY results.' at line 1 06-16 17:11:39.167 3339-3584/se.amli.liveresultsorienteering D/SelectClassActivity: getClassResults result: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 ') AND runners.TavId = results.TavId AND runners.Class = 'D40' ORDER BY results.' at line 1

petlof commented 7 years ago

Fixed and published

petlof commented 7 years ago

Than @xkenia for solution