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(742) "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 "Munich%" AND
eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND
eh.start_time > 1655802114 AND
eh.start_time > 1714136735 AND
eh.sale_end > 1714136735 AND eh.sale_start < 1714136735 AND eh.venue_id IN (1218)
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(742) "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 "Munich%" AND
eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND
eh.start_time > 1655802114 AND
eh.start_time > 1714136735 AND
eh.sale_end > 1714136735 AND eh.sale_start < 1714136735 AND eh.venue_id IN (1218)
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(742) "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 "Munich%" AND
eh.VIR_start_date BETWEEN "2024-04-26" AND "2029-04-25" AND
eh.start_time > 1655802114 AND
eh.start_time > 1714136735 AND
eh.sale_end > 1714136735 AND eh.sale_start < 1714136735 AND eh.venue_id IN (1218)
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) "Munich"
[1]=>
string(10) "2024-04-26"
[2]=>
string(10) "2029-04-25"
[3]=>
array(1) {
["venue_id"]=>
array(1) {
[0]=>
string(4) "1218"
}
}
}
}
[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) "1218"
}
}
[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) "1218"
}
}
[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) "1218"
}
}
[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(2) "21"
["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(1) "3"
}
["is_active"]=>
string(1) "1"
["is_top"]=>
string(1) "0"
["insert_stamp"]=>
string(1) "0"
["update_stamp"]=>
string(1) "0"
}
}
[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) "1218"
["original_name"]=>
string(20) "Bayerischer Rundfunk"
["street"]=>
string(15) "Rundfunkplatz 1"
["postcode"]=>
string(5) "80335"
["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(2) "21"
}
["geo_lat"]=>
string(1) "0"
["geo_long"]=>
string(1) "0"
["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) "1376987562"
["update_stamp"]=>
string(10) "1376988134"
}
}
[2]=>
string(4) "1218"
}
}
[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'"
}
}