Maksit C, agilityrata 3 Ihanneaika: 37.21
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='33' order by rank
array(5) {
  [0]=>
  array(7) {
    ["file"]=>
    string(39) "/var/www/eo2018/vantaa/inc/db_class.inc"
    ["line"]=>
    int(560)
    ["function"]=>
    string(11) "throw_error"
    ["class"]=>
    string(10) "QueryClass"
    ["object"]=>
    object(resultsQuery)#1 (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) "='33'"
      }
      ["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='33' 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='33' order by rank" } } [1]=> array(7) { ["file"]=> string(42) "/var/www/eo2018/vantaa/inc/competition.inc" ["line"]=> int(798) ["function"]=> string(13) "execute_query" ["class"]=> string(10) "QueryClass" ["object"]=> object(resultsQuery)#1 (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) "='33'" } ["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='33' 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(42) "/var/www/eo2018/vantaa/show/showobjcts.inc" ["line"]=> int(197) ["function"]=> string(22) "getParticipantRankList" ["class"]=> string(9) "listClass" ["object"]=> object(listClass)#7 (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 ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> NULL ["course_id"]=> string(2) "33" ["team_id"]=> NULL ["course_record"]=> array(14) { ["id"]=> string(2) "33" ["name"]=> string(24) "Maksit C, agilityrata 3 " ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(12) "Asko jokinen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.21" ["maximum_time"]=> string(5) "74.42" ["prev_course_id"]=> string(2) "32" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.49" ["points_deduction"]=> string(4) "0.00" ["ext_identifier"]=> string(35) "2018-03-24_C_agilityrata_100450.agi" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#8 (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(14) { ["id"]=> string(2) "32" ["name"]=> string(21) "Maksit B, hyppyrata 2" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(18) "Reetta Pirttikoski" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "36.34" ["maximum_time"]=> string(5) "72.68" ["prev_course_id"]=> string(2) "31" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "31.52" ["points_deduction"]=> string(4) "0.00" ["ext_identifier"]=> string(33) "2018-03-24_B_hyppyrata_100449.agi" } ["num_of_results"]=> string(3) "151" ["competition_id"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &bool(false) } } [3]=> array(7) { ["file"]=> string(42) "/var/www/eo2018/vantaa/show/showobjcts.inc" ["line"]=> int(137) ["function"]=> string(16) "showListInternal" ["class"]=> string(15) "showResultClass" ["object"]=> object(showResultClass)#5 (15) { ["dblink"]=> NULL ["params"]=> NULL ["oParams"]=> object(paramObject)#6 (10) { ["courseid"]=> string(2) "33" ["startrank"]=> NULL ["numofshow"]=> string(2) "10" ["updatespeed"]=> int(10) ["scrolling"]=> string(1) "N" ["scroll_page_delay"]=> int(20) ["combined"]=> string(1) "N" ["orderbystart"]=> bool(false) ["reverseorder"]=> NULL ["short_version"]=> bool(false) } ["oList"]=> object(listClass)#7 (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 ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> NULL ["course_id"]=> string(2) "33" ["team_id"]=> NULL ["course_record"]=> array(14) { ["id"]=> string(2) "33" ["name"]=> string(24) "Maksit C, agilityrata 3 " ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(12) "Asko jokinen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.21" ["maximum_time"]=> string(5) "74.42" ["prev_course_id"]=> string(2) "32" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.49" ["points_deduction"]=> string(4) "0.00" ["ext_identifier"]=> string(35) "2018-03-24_C_agilityrata_100450.agi" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#8 (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(14) { ["id"]=> string(2) "32" ["name"]=> string(21) "Maksit B, hyppyrata 2" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(18) "Reetta Pirttikoski" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "36.34" ["maximum_time"]=> string(5) "72.68" ["prev_course_id"]=> string(2) "31" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "31.52" ["points_deduction"]=> string(4) "0.00" ["ext_identifier"]=> string(33) "2018-03-24_B_hyppyrata_100449.agi" } ["num_of_results"]=> string(3) "151" ["competition_id"]=> NULL } ["latest_record"]=> NULL ["leader_time"]=> NULL ["leader_error"]=> NULL ["leader_score"]=> NULL ["timetobeat"]=> NULL ["participant_record"]=> NULL ["latest_part_id"]=> NULL ["short_version"]=> bool(false) ["order_latest"]=> bool(false) ["standard_time"]=> string(5) "37.21" ["lastCombinedList"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [4]=> array(7) { ["file"]=> string(41) "/var/www/eo2018/vantaa/show/situation.php" ["line"]=> int(64) ["function"]=> string(8) "showList" ["class"]=> string(15) "showResultClass" ["object"]=> object(showResultClass)#5 (15) { ["dblink"]=> NULL ["params"]=> NULL ["oParams"]=> object(paramObject)#6 (10) { ["courseid"]=> string(2) "33" ["startrank"]=> NULL ["numofshow"]=> string(2) "10" ["updatespeed"]=> int(10) ["scrolling"]=> string(1) "N" ["scroll_page_delay"]=> int(20) ["combined"]=> string(1) "N" ["orderbystart"]=> bool(false) ["reverseorder"]=> NULL ["short_version"]=> bool(false) } ["oList"]=> object(listClass)#7 (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 ["competition_type"]=> NULL ["course_class"]=> string(1) "L" ["db_link":protected]=> NULL ["course_id"]=> string(2) "33" ["team_id"]=> NULL ["course_record"]=> array(14) { ["id"]=> string(2) "33" ["name"]=> string(24) "Maksit C, agilityrata 3 " ["course_type"]=> string(1) "A" ["class"]=> string(1) "L" ["judge"]=> string(12) "Asko jokinen" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "37.21" ["maximum_time"]=> string(5) "74.42" ["prev_course_id"]=> string(2) "32" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "32.49" ["points_deduction"]=> string(4) "0.00" ["ext_identifier"]=> string(35) "2018-03-24_C_agilityrata_100450.agi" } ["result_record"]=> NULL ["c_participant_id"]=> NULL ["c_participant_order"]=> NULL ["autorankupdate"]=> bool(true) ["rQuery":protected]=> object(resultsQuery)#8 (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(14) { ["id"]=> string(2) "32" ["name"]=> string(21) "Maksit B, hyppyrata 2" ["course_type"]=> string(1) "J" ["class"]=> string(1) "L" ["judge"]=> string(18) "Reetta Pirttikoski" ["competition_type"]=> string(1) "I" ["standard_time"]=> string(5) "36.34" ["maximum_time"]=> string(5) "72.68" ["prev_course_id"]=> string(2) "31" ["dq_error_points"]=> string(3) "100" ["notstarted"]=> string(4) "1000" ["fastest_zero"]=> string(5) "31.52" ["points_deduction"]=> string(4) "0.00" ["ext_identifier"]=> string(33) "2018-03-24_B_hyppyrata_100449.agi" } ["num_of_results"]=> string(3) "151" ["competition_id"]=> NULL } ["latest_record"]=> NULL ["leader_time"]=> NULL ["leader_error"]=> NULL ["leader_score"]=> NULL ["timetobeat"]=> NULL ["participant_record"]=> NULL ["latest_part_id"]=> NULL ["short_version"]=> bool(false) ["order_latest"]=> bool(false) ["standard_time"]=> string(5) "37.21" ["lastCombinedList"]=> NULL } ["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='33' order by rank