Tulospalvelu
Medit, rata 2

Ihanneaika: 40.92
IHA-S-002: Unable to create query due the 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 '' at line 1
Query was select * from course_result left outer join participant partic on course_result.participant_id=partic.id where course_result.course_id='22' order by rank
array(6) {
  [0]=>
  array(7) {
    ["file"]=>
    string(59) "/var/www/karsinnat.pikapalvelin.com/mm2015/inc/db_class.inc"
    ["line"]=>
    int(566)
    ["function"]=>
    string(11) "throw_error"
    ["class"]=>
    string(10) "QueryClass"
    ["object"]=>
    object(resultsQuery)#4 (27) {
      ["kantalinkki"]=>
      resource(2) of type (mysql link)
      ["kentat"]=>
      NULL
      ["taulunimi"]=>
      string(13) "course_result"
      ["kysely_kentta"]=>
      array(1) {
        ["course_result.course_id"]=>
        string(5) "='22'"
      }
      ["kysely"]=>
      NULL
      ["sqljono"]=>
      string(156) "select *  from course_result  left outer join participant partic on course_result.participant_id=partic.id where  course_result.course_id='22' order by rank"
      ["insert_arvot"]=>
      NULL
      ["lisatty_id"]=>
      NULL
      ["muutos_rivi_lkm"]=>
      NULL
      ["jointaulut"]=>
      NULL
      ["jointehdot"]=>
      NULL
      ["outerjoin_kysely_kentta"]=>
      NULL
      ["outerjointaulut"]=>
      array(1) {
        ["partic"]=>
        string(76) "left outer join participant partic on course_result.participant_id=partic.id"
      }
      ["pakolliset_kentat"]=>
      array(0) {
      }
      ["puuttuvat_kentat"]=>
      NULL
      ["tietue"]=>
      NULL
      ["lowlimit"]=>
      NULL
      ["numofrecords"]=>
      NULL
      ["sortorder"]=>
      string(4) "rank"
      ["field_meta"]=>
      NULL
      ["ignore_errors"]=>
      bool(false)
      ["show_backtrace"]=>
      bool(true)
      ["last_error"]=>
      string(146) "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 '' at line 1"
      ["replicate"]=>
      bool(false)
      ["replication_tbl"]=>
      string(7) "tnx_log"
      ["startorder"]=>
      bool(false)
      ["rowsReturned"]=>
      int(0)
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(366) "IHA-S-002: Unable to create query due the 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 '' at line 1 
Query was select * from course_result left outer join participant partic on course_result.participant_id=partic.id where course_result.course_id='22' order by rank" } } [1]=> array(7) { ["file"]=> string(62) "/var/www/karsinnat.pikapalvelin.com/mm2015/inc/competition.inc" ["line"]=> int(712) ["function"]=> string(13) "execute_query" ["class"]=> string(10) "QueryClass" ["object"]=> object(resultsQuery)#4 (27) { ["kantalinkki"]=> resource(2) of type (mysql link) ["kentat"]=> NULL ["taulunimi"]=> string(13) "course_result" ["kysely_kentta"]=> array(1) { ["course_result.course_id"]=> string(5) "='22'" } ["kysely"]=> NULL ["sqljono"]=> string(156) "select * from course_result left outer join participant partic on course_result.participant_id=partic.id where course_result.course_id='22' order by rank" ["insert_arvot"]=> NULL ["lisatty_id"]=> NULL ["muutos_rivi_lkm"]=> NULL ["jointaulut"]=> NULL ["jointehdot"]=> NULL ["outerjoin_kysely_kentta"]=> NULL ["outerjointaulut"]=> array(1) { ["partic"]=> string(76) "left outer join participant partic on course_result.participant_id=partic.id" } ["pakolliset_kentat"]=> array(0) { } ["puuttuvat_kentat"]=> NULL ["tietue"]=> NULL ["lowlimit"]=> NULL ["numofrecords"]=> NULL ["sortorder"]=> string(4) "rank" ["field_meta"]=> NULL ["ignore_errors"]=> bool(false) ["show_backtrace"]=> bool(true) ["last_error"]=> string(146) "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 '' at line 1" ["replicate"]=> bool(false) ["replication_tbl"]=> string(7) "tnx_log" ["startorder"]=> bool(false) ["rowsReturned"]=> int(0) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(7) { ["file"]=> string(64) "/var/www/karsinnat.pikapalvelin.com/mm2015/show/netti/result.php" ["line"]=> int(204) ["function"]=> string(22) "getParticipantRankList" ["class"]=> string(9) "listClass" ["object"]=> object(listClass)#2 (23) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "M" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "22" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "22" ["name"]=> string(13) "Medit, rata 2" ["course_type"]=> string(1) "A" ["class"]=> string(1) "M" ["judge"]=> string(12) "Allan Hansen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "40.92" ["maximum_time"]=> string(5) "81.84" ["prev_course_id"]=> string(2) "21" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "35.58" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#3 (26) { ["kantalinkki"]=> resource(2) of type (mysql link) ["kentat"]=> NULL ["taulunimi"]=> string(13) "course_result" ["kysely_kentta"]=> NULL ["kysely"]=> NULL ["sqljono"]=> NULL ["insert_arvot"]=> NULL ["lisatty_id"]=> NULL ["muutos_rivi_lkm"]=> NULL ["jointaulut"]=> NULL ["jointehdot"]=> NULL ["outerjoin_kysely_kentta"]=> NULL ["outerjointaulut"]=> NULL ["pakolliset_kentat"]=> array(0) { } ["puuttuvat_kentat"]=> NULL ["tietue"]=> NULL ["lowlimit"]=> NULL ["numofrecords"]=> NULL ["sortorder"]=> NULL ["field_meta"]=> NULL ["ignore_errors"]=> bool(false) ["show_backtrace"]=> bool(true) ["last_error"]=> NULL ["replicate"]=> bool(false) ["replication_tbl"]=> string(7) "tnx_log" ["startorder"]=> bool(false) } ["combined"]=> NULL ["team_record"]=> NULL ["prev_course_record"]=> array(12) { ["id"]=> string(2) "21" ["name"]=> string(21) "Medit, rata 1 (hyppy)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "M" ["judge"]=> string(12) "Anne Savioja" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.02" ["maximum_time"]=> string(5) "74.04" ["prev_course_id"]=> NULL ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.19" } ["competition_id"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &bool(false) } } [3]=> array(7) { ["file"]=> string(64) "/var/www/karsinnat.pikapalvelin.com/mm2015/show/netti/result.php" ["line"]=> int(180) ["function"]=> string(20) "showIndividualResult" ["class"]=> string(7) "netShow" ["object"]=> object(netShow)#1 (7) { ["courseid"]=> int(22) ["combined"]=> bool(false) ["team"]=> bool(false) ["listtype"]=> string(1) "R" ["lclass"]=> object(listClass)#2 (23) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "M" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "22" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "22" ["name"]=> string(13) "Medit, rata 2" ["course_type"]=> string(1) "A" ["class"]=> string(1) "M" ["judge"]=> string(12) "Allan Hansen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "40.92" ["maximum_time"]=> string(5) "81.84" ["prev_course_id"]=> string(2) "21" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "35.58" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#3 (26) { ["kantalinkki"]=> resource(2) of type (mysql link) ["kentat"]=> NULL ["taulunimi"]=> string(13) "course_result" ["kysely_kentta"]=> NULL ["kysely"]=> NULL ["sqljono"]=> NULL ["insert_arvot"]=> NULL ["lisatty_id"]=> NULL ["muutos_rivi_lkm"]=> NULL ["jointaulut"]=> NULL ["jointehdot"]=> NULL ["outerjoin_kysely_kentta"]=> NULL ["outerjointaulut"]=> NULL ["pakolliset_kentat"]=> array(0) { } ["puuttuvat_kentat"]=> NULL ["tietue"]=> NULL ["lowlimit"]=> NULL ["numofrecords"]=> NULL ["sortorder"]=> NULL ["field_meta"]=> NULL ["ignore_errors"]=> bool(false) ["show_backtrace"]=> bool(true) ["last_error"]=> NULL ["replicate"]=> bool(false) ["replication_tbl"]=> string(7) "tnx_log" ["startorder"]=> bool(false) } ["combined"]=> NULL ["team_record"]=> NULL ["prev_course_record"]=> array(12) { ["id"]=> string(2) "21" ["name"]=> string(21) "Medit, rata 1 (hyppy)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "M" ["judge"]=> string(12) "Anne Savioja" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.02" ["maximum_time"]=> string(5) "74.04" ["prev_course_id"]=> NULL ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.19" } ["competition_id"]=> NULL } ["dblink"]=> resource(2) of type (mysql link) ["short"]=> bool(false) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [4]=> array(7) { ["file"]=> string(64) "/var/www/karsinnat.pikapalvelin.com/mm2015/show/netti/result.php" ["line"]=> int(120) ["function"]=> string(8) "showRank" ["class"]=> string(7) "netShow" ["object"]=> object(netShow)#1 (7) { ["courseid"]=> int(22) ["combined"]=> bool(false) ["team"]=> bool(false) ["listtype"]=> string(1) "R" ["lclass"]=> object(listClass)#2 (23) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "M" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "22" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "22" ["name"]=> string(13) "Medit, rata 2" ["course_type"]=> string(1) "A" ["class"]=> string(1) "M" ["judge"]=> string(12) "Allan Hansen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "40.92" ["maximum_time"]=> string(5) "81.84" ["prev_course_id"]=> string(2) "21" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "35.58" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#3 (26) { ["kantalinkki"]=> resource(2) of type (mysql link) ["kentat"]=> NULL ["taulunimi"]=> string(13) "course_result" ["kysely_kentta"]=> NULL ["kysely"]=> NULL ["sqljono"]=> NULL ["insert_arvot"]=> NULL ["lisatty_id"]=> NULL ["muutos_rivi_lkm"]=> NULL ["jointaulut"]=> NULL ["jointehdot"]=> NULL ["outerjoin_kysely_kentta"]=> NULL ["outerjointaulut"]=> NULL ["pakolliset_kentat"]=> array(0) { } ["puuttuvat_kentat"]=> NULL ["tietue"]=> NULL ["lowlimit"]=> NULL ["numofrecords"]=> NULL ["sortorder"]=> NULL ["field_meta"]=> NULL ["ignore_errors"]=> bool(false) ["show_backtrace"]=> bool(true) ["last_error"]=> NULL ["replicate"]=> bool(false) ["replication_tbl"]=> string(7) "tnx_log" ["startorder"]=> bool(false) } ["combined"]=> NULL ["team_record"]=> NULL ["prev_course_record"]=> array(12) { ["id"]=> string(2) "21" ["name"]=> string(21) "Medit, rata 1 (hyppy)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "M" ["judge"]=> string(12) "Anne Savioja" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.02" ["maximum_time"]=> string(5) "74.04" ["prev_course_id"]=> NULL ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.19" } ["competition_id"]=> NULL } ["dblink"]=> resource(2) of type (mysql link) ["short"]=> bool(false) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [5]=> array(7) { ["file"]=> string(64) "/var/www/karsinnat.pikapalvelin.com/mm2015/show/netti/result.php" ["line"]=> int(51) ["function"]=> string(11) "showResults" ["class"]=> string(7) "netShow" ["object"]=> object(netShow)#1 (7) { ["courseid"]=> int(22) ["combined"]=> bool(false) ["team"]=> bool(false) ["listtype"]=> string(1) "R" ["lclass"]=> object(listClass)#2 (23) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "M" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "22" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "22" ["name"]=> string(13) "Medit, rata 2" ["course_type"]=> string(1) "A" ["class"]=> string(1) "M" ["judge"]=> string(12) "Allan Hansen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "40.92" ["maximum_time"]=> string(5) "81.84" ["prev_course_id"]=> string(2) "21" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "35.58" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#3 (26) { ["kantalinkki"]=> resource(2) of type (mysql link) ["kentat"]=> NULL ["taulunimi"]=> string(13) "course_result" ["kysely_kentta"]=> NULL ["kysely"]=> NULL ["sqljono"]=> NULL ["insert_arvot"]=> NULL ["lisatty_id"]=> NULL ["muutos_rivi_lkm"]=> NULL ["jointaulut"]=> NULL ["jointehdot"]=> NULL ["outerjoin_kysely_kentta"]=> NULL ["outerjointaulut"]=> NULL ["pakolliset_kentat"]=> array(0) { } ["puuttuvat_kentat"]=> NULL ["tietue"]=> NULL ["lowlimit"]=> NULL ["numofrecords"]=> NULL ["sortorder"]=> NULL ["field_meta"]=> NULL ["ignore_errors"]=> bool(false) ["show_backtrace"]=> bool(true) ["last_error"]=> NULL ["replicate"]=> bool(false) ["replication_tbl"]=> string(7) "tnx_log" ["startorder"]=> bool(false) } ["combined"]=> NULL ["team_record"]=> NULL ["prev_course_record"]=> array(12) { ["id"]=> string(2) "21" ["name"]=> string(21) "Medit, rata 1 (hyppy)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "M" ["judge"]=> string(12) "Anne Savioja" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.02" ["maximum_time"]=> string(5) "74.04" ["prev_course_id"]=> NULL ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.19" } ["competition_id"]=> NULL } ["dblink"]=> resource(2) of type (mysql link) ["short"]=> bool(false) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } }
IHA-S-002: Unable to create query due the 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 '' at line 1
Query was select * from course_result left outer join participant partic on course_result.participant_id=partic.id where course_result.course_id='22' order by rank