object(PDOException)#179 (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(872) "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 "Vienna%" AND eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND eh.start_time > 1655802114 AND eh.start_time > 1714136722 AND eh.sale_end > 1714136722 AND eh.sale_start < 1714136722 AND eh.country_id IN (1,2,3,4,5,6,7,8,9,11,18,40) AND eh.city_id IN (1,5,6,7,10,13,14,15,16,18,19,20,21,25,34,36,39,44,110,179,262,307,321,351,360,376,460) 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(872) "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 "Vienna%" AND eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND eh.start_time > 1655802114 AND eh.start_time > 1714136722 AND eh.sale_end > 1714136722 AND eh.sale_start < 1714136722 AND eh.country_id IN (1,2,3,4,5,6,7,8,9,11,18,40) AND eh.city_id IN (1,5,6,7,10,13,14,15,16,18,19,20,21,25,34,36,39,44,110,179,262,307,321,351,360,376,460) 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(872) "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 "Vienna%" AND eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND eh.start_time > 1655802114 AND eh.start_time > 1714136722 AND eh.sale_end > 1714136722 AND eh.sale_start < 1714136722 AND eh.country_id IN (1,2,3,4,5,6,7,8,9,11,18,40) AND eh.city_id IN (1,5,6,7,10,13,14,15,16,18,19,20,21,25,34,36,39,44,110,179,262,307,321,351,360,376,460) 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(6) "Vienna" [1]=> string(10) "2024-04-26" [2]=> string(10) "2029-04-25" [3]=> array(2) { ["city_id"]=> array(27) { [0]=> string(1) "1" [1]=> string(1) "5" [2]=> string(1) "6" [3]=> string(1) "7" [4]=> string(2) "10" [5]=> string(2) "13" [6]=> string(2) "14" [7]=> string(2) "15" [8]=> string(2) "16" [9]=> string(2) "18" [10]=> string(2) "19" [11]=> string(2) "20" [12]=> string(2) "21" [13]=> string(2) "25" [14]=> string(2) "34" [15]=> string(2) "36" [16]=> string(2) "39" [17]=> string(2) "44" [18]=> string(3) "110" [19]=> string(3) "179" [20]=> string(3) "262" [21]=> string(3) "307" [22]=> string(3) "321" [23]=> string(3) "351" [24]=> string(3) "360" [25]=> string(3) "376" [26]=> string(3) "460" } ["country_id"]=> array(12) { [0]=> string(1) "1" [1]=> string(1) "2" [2]=> string(1) "3" [3]=> string(1) "4" [4]=> string(1) "5" [5]=> string(1) "6" [6]=> string(1) "7" [7]=> string(1) "8" [8]=> string(1) "9" [9]=> string(2) "11" [10]=> string(2) "18" [11]=> string(2) "40" } } } } [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(true) [1]=> string(7) "concert" [2]=> bool(true) [3]=> array(2) { ["city_id"]=> array(27) { [0]=> string(1) "1" [1]=> string(1) "5" [2]=> string(1) "6" [3]=> string(1) "7" [4]=> string(2) "10" [5]=> string(2) "13" [6]=> string(2) "14" [7]=> string(2) "15" [8]=> string(2) "16" [9]=> string(2) "18" [10]=> string(2) "19" [11]=> string(2) "20" [12]=> string(2) "21" [13]=> string(2) "25" [14]=> string(2) "34" [15]=> string(2) "36" [16]=> string(2) "39" [17]=> string(2) "44" [18]=> string(3) "110" [19]=> string(3) "179" [20]=> string(3) "262" [21]=> string(3) "307" [22]=> string(3) "321" [23]=> string(3) "351" [24]=> string(3) "360" [25]=> string(3) "376" [26]=> string(3) "460" } ["country_id"]=> array(12) { [0]=> string(1) "1" [1]=> string(1) "2" [2]=> string(1) "3" [3]=> string(1) "4" [4]=> string(1) "5" [5]=> string(1) "6" [6]=> string(1) "7" [7]=> string(1) "8" [8]=> string(1) "9" [9]=> string(2) "11" [10]=> string(2) "18" [11]=> string(2) "40" } } [4]=> NULL } } [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(true) [1]=> string(7) "concert" [2]=> bool(true) [3]=> array(2) { ["city_id"]=> array(27) { [0]=> string(1) "1" [1]=> string(1) "5" [2]=> string(1) "6" [3]=> string(1) "7" [4]=> string(2) "10" [5]=> string(2) "13" [6]=> string(2) "14" [7]=> string(2) "15" [8]=> string(2) "16" [9]=> string(2) "18" [10]=> string(2) "19" [11]=> string(2) "20" [12]=> string(2) "21" [13]=> string(2) "25" [14]=> string(2) "34" [15]=> string(2) "36" [16]=> string(2) "39" [17]=> string(2) "44" [18]=> string(3) "110" [19]=> string(3) "179" [20]=> string(3) "262" [21]=> string(3) "307" [22]=> string(3) "321" [23]=> string(3) "351" [24]=> string(3) "360" [25]=> string(3) "376" [26]=> string(3) "460" } ["country_id"]=> array(12) { [0]=> string(1) "1" [1]=> string(1) "2" [2]=> string(1) "3" [3]=> string(1) "4" [4]=> string(1) "5" [5]=> string(1) "6" [6]=> string(1) "7" [7]=> string(1) "8" [8]=> string(1) "9" [9]=> string(2) "11" [10]=> string(2) "18" [11]=> string(2) "40" } } [4]=> NULL } } [6]=> array(6) { ["file"]=> string(76) "/home/web/ctic/CTIC/portal/app/portal/controller/specialController.class.php" ["line"]=> int(111) ["function"]=> string(18) "initViewSolrSearch" ["class"]=> string(14) "cAppController" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> bool(true) [1]=> string(7) "concert" [2]=> array(2) { ["city_id"]=> array(27) { [0]=> string(1) "1" [1]=> string(1) "5" [2]=> string(1) "6" [3]=> string(1) "7" [4]=> string(2) "10" [5]=> string(2) "13" [6]=> string(2) "14" [7]=> string(2) "15" [8]=> string(2) "16" [9]=> string(2) "18" [10]=> string(2) "19" [11]=> string(2) "20" [12]=> string(2) "21" [13]=> string(2) "25" [14]=> string(2) "34" [15]=> string(2) "36" [16]=> string(2) "39" [17]=> string(2) "44" [18]=> string(3) "110" [19]=> string(3) "179" [20]=> string(3) "262" [21]=> string(3) "307" [22]=> string(3) "321" [23]=> string(3) "351" [24]=> string(3) "360" [25]=> string(3) "376" [26]=> string(3) "460" } ["country_id"]=> array(12) { [0]=> string(1) "1" [1]=> string(1) "2" [2]=> string(1) "3" [3]=> string(1) "4" [4]=> string(1) "5" [5]=> string(1) "6" [6]=> string(1) "7" [7]=> string(1) "8" [8]=> string(1) "9" [9]=> string(2) "11" [10]=> string(2) "18" [11]=> string(2) "40" } } } } [7]=> array(6) { ["file"]=> string(43) "/home/web/ctic/CTIC/base/cms/controller.php" ["line"]=> int(19) ["function"]=> string(10) "showAction" ["class"]=> string(18) "cSpecialController" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(37) "classical-concerts-in-european-cities" [1]=> int(198) } } [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'" } }