object(PDOException)#219 (8) { ["message":protected]=> string(92) "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'eh.VIR_start_date' in 'where clause'" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42S22" ["file":protected]=> string(56) "/home/web/ctic/CTIC/base/system/databaseSystem.class.php" ["line":protected]=> int(123) ["trace":"Exception":private]=> array(11) { [0]=> array(6) { ["file"]=> string(56) "/home/web/ctic/CTIC/base/system/databaseSystem.class.php" ["line"]=> int(123) ["function"]=> string(5) "query" ["class"]=> string(3) "PDO" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(751) "SELECT COUNT(DISTINCT eh.event_id) FROM event_helper AS eh JOIN translation AS t ON t.tablename="city" AND t.oid = eh.city_id JOIN event AS e ON e.id = eh.event_id AND e.is_active = 1 JOIN event_has_priceset AS ehps ON ehps.event_id = e.id AND ehps.available > 0 WHERE t.name LIKE "Нью-Йорк%" AND eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND eh.start_time > 1655802114 AND eh.start_time > 1714135602 AND eh.sale_end > 1714135602 AND eh.sale_start < 1714135602 AND eh.venue_id IN (2558) GROUP BY eh.concert_id ORDER BY eh.start_time ASC" [1]=> int(2) } } [1]=> array(6) { ["file"]=> string(56) "/home/web/ctic/CTIC/base/system/databaseSystem.class.php" ["line"]=> int(112) ["function"]=> string(5) "query" ["class"]=> string(15) "cDatabaseSystem" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(751) "SELECT COUNT(DISTINCT eh.event_id) FROM event_helper AS eh JOIN translation AS t ON t.tablename="city" AND t.oid = eh.city_id JOIN event AS e ON e.id = eh.event_id AND e.is_active = 1 JOIN event_has_priceset AS ehps ON ehps.event_id = e.id AND ehps.available > 0 WHERE t.name LIKE "Нью-Йорк%" AND eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND eh.start_time > 1655802114 AND eh.start_time > 1714135602 AND eh.sale_end > 1714135602 AND eh.sale_start < 1714135602 AND eh.venue_id IN (2558) GROUP BY eh.concert_id ORDER BY eh.start_time ASC" } } [2]=> array(6) { ["file"]=> string(63) "/home/web/ctic/CTIC/portal/app/portal/model/solrModel.class.php" ["line"]=> int(60) ["function"]=> string(6) "select" ["class"]=> string(15) "cDatabaseSystem" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(751) "SELECT COUNT(DISTINCT eh.event_id) FROM event_helper AS eh JOIN translation AS t ON t.tablename="city" AND t.oid = eh.city_id JOIN event AS e ON e.id = eh.event_id AND e.is_active = 1 JOIN event_has_priceset AS ehps ON ehps.event_id = e.id AND ehps.available > 0 WHERE t.name LIKE "Нью-Йорк%" AND eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND eh.start_time > 1655802114 AND eh.start_time > 1714135602 AND eh.sale_end > 1714135602 AND eh.sale_start < 1714135602 AND eh.venue_id IN (2558) GROUP BY eh.concert_id ORDER BY eh.start_time ASC" } } [3]=> array(6) { ["file"]=> string(43) "/home/web/ctic/CTIC/base/lib/Solr.trait.php" ["line"]=> int(368) ["function"]=> string(25) "selectFallbackSearchCount" ["class"]=> string(10) "cSolrModel" ["type"]=> string(2) "::" ["args"]=> array(4) { [0]=> string(15) "Нью-Йорк" [1]=> string(10) "2024-04-26" [2]=> string(10) "2029-04-25" [3]=> array(1) { ["venue_id"]=> array(1) { [0]=> string(4) "2558" } } } } [4]=> array(6) { ["file"]=> string(43) "/home/web/ctic/CTIC/base/lib/Solr.trait.php" ["line"]=> int(172) ["function"]=> string(14) "searchFallback" ["class"]=> string(14) "cAppController" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> bool(false) [1]=> string(7) "concert" [2]=> bool(true) [3]=> string(8) "venue_id" [4]=> string(4) "2558" } } [5]=> array(6) { ["file"]=> string(43) "/home/web/ctic/CTIC/base/lib/Solr.trait.php" ["line"]=> int(436) ["function"]=> string(6) "search" ["class"]=> string(14) "cAppController" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> bool(false) [1]=> string(7) "concert" [2]=> bool(true) [3]=> string(8) "venue_id" [4]=> string(4) "2558" } } [6]=> array(6) { ["file"]=> string(74) "/home/web/ctic/CTIC/portal/app/portal/controller/venueController.class.php" ["line"]=> int(57) ["function"]=> string(18) "initViewSolrSearch" ["class"]=> string(14) "cAppController" ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> bool(false) [1]=> string(7) "concert" [2]=> string(8) "venue_id" [3]=> string(4) "2558" } } [7]=> array(6) { ["file"]=> string(43) "/home/web/ctic/CTIC/base/cms/controller.php" ["line"]=> int(19) ["function"]=> string(10) "showAction" ["class"]=> string(16) "cVenueController" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> object(City)#222 (3) { ["_columns":protected]=> array(6) { [0]=> string(2) "id" [1]=> string(7) "country" [2]=> string(9) "is_active" [3]=> string(6) "is_top" [4]=> string(12) "insert_stamp" [5]=> string(12) "update_stamp" } ["_defaultValues":protected]=> array(6) { ["id"]=> NULL ["country"]=> array(6) { ["refType"]=> string(3) "1:1" ["type"]=> string(4) "City" ["field"]=> string(7) "country" ["fieldType"]=> string(7) "Country" ["keyField"]=> string(10) "country_id" ["fieldValue"]=> NULL } ["is_active"]=> NULL ["is_top"]=> NULL ["insert_stamp"]=> NULL ["update_stamp"]=> NULL } ["_data":protected]=> array(6) { ["id"]=> string(3) "124" ["country"]=> array(6) { ["refType"]=> string(3) "1:1" ["type"]=> string(4) "City" ["field"]=> string(7) "country" ["fieldType"]=> string(7) "Country" ["keyField"]=> string(10) "country_id" ["fieldValue"]=> string(2) "42" } ["is_active"]=> string(1) "1" ["is_top"]=> string(1) "0" ["insert_stamp"]=> string(1) "0" ["update_stamp"]=> string(10) "1644916497" } } [1]=> object(Venue)#224 (3) { ["_columns":protected]=> array(17) { [0]=> string(2) "id" [1]=> string(13) "original_name" [2]=> string(6) "street" [3]=> string(8) "postcode" [4]=> string(4) "city" [5]=> string(7) "geo_lat" [6]=> string(8) "geo_long" [7]=> string(11) "is_elevator" [8]=> string(11) "is_car_park" [9]=> string(11) "is_bus_park" [10]=> string(16) "is_air_condition" [11]=> string(16) "is_souvenir_shop" [12]=> string(9) "is_active" [13]=> string(6) "is_top" [14]=> string(12) "show_on_home" [15]=> string(12) "insert_stamp" [16]=> string(12) "update_stamp" } ["_defaultValues":protected]=> array(17) { ["id"]=> NULL ["original_name"]=> NULL ["street"]=> NULL ["postcode"]=> NULL ["city"]=> array(6) { ["refType"]=> string(3) "1:1" ["type"]=> string(5) "Venue" ["field"]=> string(4) "city" ["fieldType"]=> string(4) "City" ["keyField"]=> string(7) "city_id" ["fieldValue"]=> NULL } ["geo_lat"]=> NULL ["geo_long"]=> NULL ["is_elevator"]=> NULL ["is_car_park"]=> NULL ["is_bus_park"]=> NULL ["is_air_condition"]=> NULL ["is_souvenir_shop"]=> NULL ["is_active"]=> NULL ["is_top"]=> NULL ["show_on_home"]=> NULL ["insert_stamp"]=> NULL ["update_stamp"]=> NULL } ["_data":protected]=> array(17) { ["id"]=> string(4) "2558" ["original_name"]=> string(21) "Al Hirschfeld Theatre" ["street"]=> string(20) "302 West 45th Street" ["postcode"]=> string(9) "NY 10036 " ["city"]=> array(6) { ["refType"]=> string(3) "1:1" ["type"]=> string(5) "Venue" ["field"]=> string(4) "city" ["fieldType"]=> string(4) "City" ["keyField"]=> string(7) "city_id" ["fieldValue"]=> string(3) "124" } ["geo_lat"]=> string(7) "40.7593" ["geo_long"]=> string(7) "-73.989" ["is_elevator"]=> string(1) "0" ["is_car_park"]=> string(1) "0" ["is_bus_park"]=> string(1) "0" ["is_air_condition"]=> string(1) "0" ["is_souvenir_shop"]=> string(1) "0" ["is_active"]=> string(1) "1" ["is_top"]=> string(1) "0" ["show_on_home"]=> string(2) "no" ["insert_stamp"]=> string(10) "1542293981" ["update_stamp"]=> string(1) "0" } } [2]=> string(4) "2558" } } [8]=> array(4) { ["file"]=> string(55) "/home/web/ctic/CTIC/portal/app/portal/config/config.php" ["line"]=> int(312) ["args"]=> array(1) { [0]=> string(43) "/home/web/ctic/CTIC/base/cms/controller.php" } ["function"]=> string(12) "require_once" } [9]=> array(4) { ["file"]=> string(54) "/home/web/ctic/CTIC/portal/index/classictic_portal.php" ["line"]=> int(23) ["args"]=> array(1) { [0]=> string(55) "/home/web/ctic/CTIC/portal/app/portal/config/config.php" } ["function"]=> string(12) "require_once" } [10]=> array(4) { ["file"]=> string(50) "/home/web/ctic/CTIC/portal/index/portal/portal.php" ["line"]=> int(6) ["args"]=> array(1) { [0]=> string(54) "/home/web/ctic/CTIC/portal/index/classictic_portal.php" } ["function"]=> string(12) "require_once" } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "42S22" [1]=> int(1054) [2]=> string(52) "Unknown column 'eh.VIR_start_date' in 'where clause'" } }