Tulospalvelu
Maksit, rata 5 Yksilöpisteet

Ihanneaika: 46.46
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='35' order by rank
array(6) {
  [0]=>
  array(7) {
    ["file"]=>
    string(32) "/var/www/mm2018/inc/db_class.inc"
    ["line"]=>
    int(580)
    ["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) "='35'"
      }
      ["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='35' 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='35' order by rank" } } [1]=> array(7) { ["file"]=> string(35) "/var/www/mm2018/inc/competition.inc" ["line"]=> int(726) ["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) "='35'" } ["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='35' 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(37) "/var/www/mm2018/show/netti/result.php" ["line"]=> int(210) ["function"]=> string(22) "getParticipantRankList" ["class"]=> string(9) "listClass" ["object"]=> object(listClass)#2 (24) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["leader_team_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "35" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "35" ["name"]=> string(14) "Maksit, rata 5" ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "46.46" ["maximum_time"]=> string(5) "92.92" ["prev_course_id"]=> string(2) "34" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "40.40" } ["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) "34" ["name"]=> string(18) "Maksit, rata 4 (H)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "34.83" ["maximum_time"]=> string(5) "69.66" ["prev_course_id"]=> string(2) "33" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "30.29" } ["competition_id"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &bool(false) } } [3]=> array(7) { ["file"]=> string(37) "/var/www/mm2018/show/netti/result.php" ["line"]=> int(186) ["function"]=> string(20) "showIndividualResult" ["class"]=> string(7) "netShow" ["object"]=> object(netShow)#1 (7) { ["courseid"]=> int(35) ["combined"]=> bool(false) ["team"]=> bool(false) ["listtype"]=> string(1) "R" ["lclass"]=> object(listClass)#2 (24) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["leader_team_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "35" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "35" ["name"]=> string(14) "Maksit, rata 5" ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "46.46" ["maximum_time"]=> string(5) "92.92" ["prev_course_id"]=> string(2) "34" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "40.40" } ["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) "34" ["name"]=> string(18) "Maksit, rata 4 (H)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "34.83" ["maximum_time"]=> string(5) "69.66" ["prev_course_id"]=> string(2) "33" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "30.29" } ["competition_id"]=> NULL } ["dblink"]=> resource(2) of type (mysql link) ["short"]=> bool(false) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [4]=> array(7) { ["file"]=> string(37) "/var/www/mm2018/show/netti/result.php" ["line"]=> int(111) ["function"]=> string(8) "showRank" ["class"]=> string(7) "netShow" ["object"]=> object(netShow)#1 (7) { ["courseid"]=> int(35) ["combined"]=> bool(false) ["team"]=> bool(false) ["listtype"]=> string(1) "R" ["lclass"]=> object(listClass)#2 (24) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["leader_team_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "35" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "35" ["name"]=> string(14) "Maksit, rata 5" ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "46.46" ["maximum_time"]=> string(5) "92.92" ["prev_course_id"]=> string(2) "34" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "40.40" } ["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) "34" ["name"]=> string(18) "Maksit, rata 4 (H)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "34.83" ["maximum_time"]=> string(5) "69.66" ["prev_course_id"]=> string(2) "33" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "30.29" } ["competition_id"]=> NULL } ["dblink"]=> resource(2) of type (mysql link) ["short"]=> bool(false) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [5]=> array(7) { ["file"]=> string(37) "/var/www/mm2018/show/netti/result.php" ["line"]=> int(42) ["function"]=> string(11) "showResults" ["class"]=> string(7) "netShow" ["object"]=> object(netShow)#1 (7) { ["courseid"]=> int(35) ["combined"]=> bool(false) ["team"]=> bool(false) ["listtype"]=> string(1) "R" ["lclass"]=> object(listClass)#2 (24) { ["lQuery":protected]=> NULL ["latest_record"]=> NULL ["rank_list"]=> NULL ["combined_result"]=> NULL ["team_result"]=> NULL ["one_team_result"]=> NULL ["lastCombinedList"]=> NULL ["leader_totalpoints"]=> NULL ["leader_team_totalpoints"]=> NULL ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> resource(2) of type (mysql link) ["course_id"]=> string(2) "35" ["team_id"]=> NULL ["course_record"]=> array(12) { ["id"]=> string(2) "35" ["name"]=> string(14) "Maksit, rata 5" ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "46.46" ["maximum_time"]=> string(5) "92.92" ["prev_course_id"]=> string(2) "34" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "40.40" } ["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) "34" ["name"]=> string(18) "Maksit, rata 4 (H)" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(4) "joku" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "34.83" ["maximum_time"]=> string(5) "69.66" ["prev_course_id"]=> string(2) "33" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "30.29" } ["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='35' order by rank