object(PDOException)#222 (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(879) "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 "%E3%82%B5%E3%83%B3%E3%83%BB%E3%82%B8%E3%83%9F%E3%83%8B%E3%83%A3%E3%83%BC%E3%83%8E, %E3%82%AB%E3%83%BC%E3%83%8D%E3%82%AE%E3%83%BC%E3%83%BB%E3%83%9B%E3%83%BC%E3%83%AB%" AND eh.VIR_start_date BETWEEN "2024-05-11" AND "2029-05-10" AND eh.start_time > 1655802114 AND eh.start_time > 1715430905 AND eh.sale_end > 1715430905 AND eh.sale_start < 1715430905 AND 1 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(879) "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 "%E3%82%B5%E3%83%B3%E3%83%BB%E3%82%B8%E3%83%9F%E3%83%8B%E3%83%A3%E3%83%BC%E3%83%8E, %E3%82%AB%E3%83%BC%E3%83%8D%E3%82%AE%E3%83%BC%E3%83%BB%E3%83%9B%E3%83%BC%E3%83%AB%" AND eh.VIR_start_date BETWEEN "2024-05-11" AND "2029-05-10" AND eh.start_time > 1655802114 AND eh.start_time > 1715430905 AND eh.sale_end > 1715430905 AND eh.sale_start < 1715430905 AND 1 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(879) "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 "%E3%82%B5%E3%83%B3%E3%83%BB%E3%82%B8%E3%83%9F%E3%83%8B%E3%83%A3%E3%83%BC%E3%83%8E, %E3%82%AB%E3%83%BC%E3%83%8D%E3%82%AE%E3%83%BC%E3%83%BB%E3%83%9B%E3%83%BC%E3%83%AB%" AND eh.VIR_start_date BETWEEN "2024-05-11" AND "2029-05-10" AND eh.start_time > 1655802114 AND eh.start_time > 1715430905 AND eh.sale_end > 1715430905 AND eh.sale_start < 1715430905 AND 1 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(164) "%E3%82%B5%E3%83%B3%E3%83%BB%E3%82%B8%E3%83%9F%E3%83%8B%E3%83%A3%E3%83%BC%E3%83%8E, %E3%82%AB%E3%83%BC%E3%83%8D%E3%82%AE%E3%83%BC%E3%83%BB%E3%83%9B%E3%83%BC%E3%83%AB" [1]=> string(10) "2024-05-11" [2]=> string(10) "2029-05-10" [3]=> array(0) { } } } [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]=> NULL [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(false) [1]=> string(7) "concert" [2]=> bool(true) [3]=> NULL [4]=> NULL } } [6]=> array(6) { ["file"]=> string(75) "/home/web/ctic/CTIC/portal/app/portal/controller/searchController.class.php" ["line"]=> int(7) ["function"]=> string(18) "initViewSolrSearch" ["class"]=> string(14) "cAppController" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> bool(false) [1]=> string(7) "concert" } } [7]=> array(6) { ["file"]=> string(43) "/home/web/ctic/CTIC/base/cms/controller.php" ["line"]=> int(19) ["function"]=> string(10) "mainAction" ["class"]=> string(17) "cSearchController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [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'" } }