Notice: Undefined property: DB_Error::$getMessage in /usr/local/www/ekwest.com/sources/MyDB.php on line 98

SQL Error:
object(DB_Error)#5 (8) { ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(-11) ["message"]=> string(24) "DB Error: invalid number" ["userinfo"]=> string(437) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' [nativecode=ERROR: invalid input syntax for integer: ""]" ["backtrace"]=> array(11) { [0]=> array(6) { ["file"]=> string(28) "/usr/local/share/pear/DB.php" ["line"]=> int(966) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> string(24) "DB Error: invalid number" [1]=> int(-11) [2]=> int(1) [3]=> int(1024) [4]=> string(437) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' [nativecode=ERROR: invalid input syntax for integer: ""]" } } [1]=> array(7) { ["file"]=> string(30) "/usr/local/share/pear/PEAR.php" ["line"]=> int(564) ["function"]=> string(8) "DB_Error" ["class"]=> string(8) "DB_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> int(-11) [1]=> int(1) [2]=> int(1024) [3]=> string(437) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' [nativecode=ERROR: invalid input syntax for integer: ""]" } } [2]=> array(7) { ["file"]=> string(35) "/usr/local/share/pear/DB/common.php" ["line"]=> int(1903) ["function"]=> string(10) "raiseError" ["class"]=> string(4) "PEAR" ["object"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["type"]=> string(2) "->" ["args"]=> array(7) { [0]=> NULL [1]=> int(-11) [2]=> NULL [3]=> NULL [4]=> string(437) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' [nativecode=ERROR: invalid input syntax for integer: ""]" [5]=> string(8) "DB_Error" [6]=> bool(true) } } [3]=> array(7) { ["file"]=> string(34) "/usr/local/share/pear/DB/pgsql.php" ["line"]=> int(790) ["function"]=> string(10) "raiseError" ["class"]=> string(9) "DB_common" ["object"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> int(-11) [1]=> NULL [2]=> NULL [3]=> NULL [4]=> string(44) "ERROR: invalid input syntax for integer: """ } } [4]=> array(7) { ["file"]=> string(34) "/usr/local/share/pear/DB/pgsql.php" ["line"]=> int(337) ["function"]=> string(15) "pgsqlRaiseError" ["class"]=> string(8) "DB_pgsql" ["object"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [5]=> array(7) { ["file"]=> string(35) "/usr/local/share/pear/DB/common.php" ["line"]=> int(1216) ["function"]=> string(11) "simpleQuery" ["class"]=> string(8) "DB_pgsql" ["object"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " } } [6]=> array(7) { ["file"]=> string(35) "/usr/local/share/pear/DB/common.php" ["line"]=> int(1663) ["function"]=> string(5) "query" ["class"]=> string(9) "DB_common" ["object"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " } } [7]=> array(7) { ["file"]=> string(42) "/usr/local/www/ekwest.com/sources/MyDB.php" ["line"]=> int(67) ["function"]=> string(6) "getAll" ["class"]=> string(9) "DB_common" ["object"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " } } [8]=> array(7) { ["file"]=> string(39) "/usr/local/www/hotelier.ca/includes.php" ["line"]=> int(298) ["function"]=> string(12) "runDataQuery" ["class"]=> string(4) "MyDB" ["object"]=> object(MyDB)#2 (5) { ["db"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["msg"]=> NULL ["debug"]=> bool(true) ["limit"]=> bool(true) ["limit_query"]=> int(0) } ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(957) "Select distinct e.description_fr, e.isclosed, e.establishment_name, e.search_level3_id, e.phone, e.address, e.establishment_id, e.city_id, e.search_level1_id, case when dr.nb_votes < 5 then 0 else avg(dr.vote6)*4 end as rating, e.website, case when e.website <> '' then 1 else 0 end as hasWebsite, e.en_ligne, count(distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' group by e.description_fr, e.isclosed, e.establishment_name, e.search_level3_id, e.phone, e.address, e.establishment_id, e.city_id, e.search_level1_id, dr.nb_votes, e.website, e.en_ligne order by e.en_ligne desc, case when dr.nb_votes < 5 then 0 else avg(dr.vote6)*4 end desc" [1]=> &bool(true) } } [9]=> array(7) { ["file"]=> string(52) "/usr/local/www/ekwest.com/sources/search_results.php" ["line"]=> int(30) ["function"]=> string(6) "Search" ["class"]=> string(4) "Site" ["object"]=> object(Site)#1 (22) { ["single_search"]=> array(2) { [18]=> string(14) "Classification" [16]=> string(4) "Prix" } ["multi_search"]=> array(3) { [7]=> string(16) "Catégorie" [9]=> string(15) "Activité" [11]=> string(20) "Particularité" } ["FAST_SEARCH"]=> array(2) { ["Catégorie"]=> string(8) "Category" ["Prix"]=> string(5) "Price" } ["id_fast_search"]=> array(2) { [7]=> string(8) "Category" [16]=> string(5) "Price" } ["tabRecAvanc"]=> array(5) { ["Feature"]=> string(20) "Particularité" ["Price"]=> string(4) "Prix" ["Rating"]=> string(14) "Classification" ["Activity"]=> string(15) "Activité" ["Category"]=> string(16) "Catégorie" } ["area_search"]=> string(4) "Area" ["key_feat"]=> string(2) "11" ["rating_types"]=> array(6) { [11]=> string(7) "Général" [10]=> string(7) "Service" [9]=> string(12) "Localisation" [8]=> string(6) "Charme" [7]=> string(12) "Qualité/Prix" [6]=> string(8) "Propreté" } ["search_types"]=> array(5) { [11]=> string(7) "Feature" [9]=> string(8) "Activity" [7]=> string(8) "Category" [16]=> string(5) "Price" [18]=> string(6) "Rating" } ["rating_order_id"]=> array(6) { [5]=> string(7) "Général" [6]=> string(7) "Service" [4]=> string(12) "Localisation" [3]=> string(6) "Charme" [2]=> string(12) "Qualité/Prix" [1]=> string(8) "Propreté" } ["partner"]=> string(6) "ekwest" ["website"]=> string(11) "Hotelier.ca" ["lng"]=> string(2) "fr" ["db"]=> object(MyDB)#2 (5) { ["db"]=> object(DB_pgsql)#3 (28) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.3.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(true) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(0) { } ["connection"]=> resource(11) of type (pgsql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "pgsql" ["dbsyntax"]=> string(5) "pgsql" ["username"]=> string(6) "ammina" ["password"]=> string(12) "restaurateur" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(0) "" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(6) "ekwest" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["affected"]=> int(0) ["row"]=> array(0) { } ["_num_rows"]=> array(0) { } ["fetchmode"]=> int(2) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(379) "Select count (distinct e.establishment_id) as total from establishment e, city, dci_rating dr , establishment_search_criteria escCategory where escCategory.establishment_id = e.establishment_id and dr.establishment = e.establishment_id and e.city_id = city.city_id and e.website_id = 4 and e.active='Y' and e.search_level1_id = 52 AND escCategory.search_criteria_id = '' " ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(0) { } ["prepare_types"]=> array(0) { } ["prepared_queries"]=> array(0) { } ["_last_query_manip"]=> bool(false) ["_next_query_manip"]=> bool(false) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["msg"]=> NULL ["debug"]=> bool(true) ["limit"]=> bool(true) ["limit_query"]=> int(0) } ["src"]=> string(30) "http://www.ekwest.com/sources/" ["path"]=> string(23) "http://www.hotelier.ca/" ["menuText"]=> array(14) { [44]=> string(7) "Alberta" [45]=> string(20) "Colombie-Britannique" [51]=> string(5) "I.P.E" [79]=> string(8) "Manitoba" [46]=> string(17) "Nouveau-Brunswick" [48]=> string(15) "Nouvelle-Écosse" [80]=> string(7) "Nunavut" [49]=> string(7) "Ontario" [50]=> string(8) "Prairies" [52]=> string(6) "Québec" [82]=> string(12) "Saskatchewan" [47]=> string(11) "Terre-Neuve" [83]=> string(25) "Territoires du Nord-Ouest" [81]=> string(5) "Yukon" } ["def"]=> string(5) "hotel" ["abr"]=> string(3) "HTL" ["admin"]=> string(8) "Hotelier" ["title"]=> string(8) "Hotelier" ["partner_id"]=> int(16) } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [10]=> array(4) { ["file"]=> string(45) "/usr/local/www/hotelier.ca/search_results.php" ["line"]=> int(1) ["args"]=> array(1) { [0]=> string(52) "/usr/local/www/ekwest.com/sources/search_results.php" } ["function"]=> string(7) "include" } } ["callback"]=> NULL }
Warning: Invalid argument supplied for foreach() in /usr/local/www/ekwest.com/sources/search_results.php on line 34

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /usr/local/www/ekwest.com/sources/MyDB.php:98) in /usr/local/www/ekwest.com/sources/templates/search_results_fr.tpl on line 5

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /usr/local/www/ekwest.com/sources/MyDB.php:98) in /usr/local/www/ekwest.com/sources/templates/search_results_fr.tpl on line 5

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/www/ekwest.com/sources/MyDB.php:98) in /usr/local/www/ekwest.com/sources/templates/search_results_fr.tpl on line 13
Hotelier Québec - Résultats de recherche
Alberta Colombie-Britannique I.P.E Manitoba Nouveau-Brunswick Nouvelle-Écosse Nunavut Ontario Prairies Québec Saskatchewan Terre-Neuve Territoires du Nord-Ouest Yukon   English
Hotelier.ca   >   Québec    >  Recherche rapide  >  Résultats

Hotelier
Cliquez ici     
  
   
         

   
`
   


   
Nous contacter     Déclaration de confidentialité Que pensez-vous du nouveau Hotelier.ca Suggérez un hotel