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(12) {
[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(715) "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 > 1714136746 AND
eh.sale_end > 1714136746 AND eh.sale_start < 1714136746 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(715) "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 > 1714136746 AND
eh.sale_end > 1714136746 AND eh.sale_start < 1714136746 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(715) "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 > 1714136746 AND
eh.sale_end > 1714136746 AND eh.sale_start < 1714136746 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]=>
NULL
[1]=>
string(10) "2024-04-26"
[2]=>
string(10) "2029-04-25"
[3]=>
array(1) {
["artist_id"]=>
array(1) {
[0]=>
string(4) "3491"
}
}
}
}
[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]=>
string(9) "artist_id"
[4]=>
string(4) "3491"
}
}
[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]=>
string(9) "artist_id"
[4]=>
string(4) "3491"
}
}
[6]=>
array(6) {
["file"]=>
string(77) "/home/web/ctic/CTIC/portal/app/portal/controller/listBaseController.class.php"
["line"]=>
int(45)
["function"]=>
string(18) "initViewSolrSearch"
["class"]=>
string(14) "cAppController"
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
bool(true)
[1]=>
string(7) "concert"
[2]=>
string(9) "artist_id"
[3]=>
string(4) "3491"
}
}
[7]=>
array(6) {
["file"]=>
string(75) "/home/web/ctic/CTIC/portal/app/portal/controller/artistController.class.php"
["line"]=>
int(29)
["function"]=>
string(11) "_showAction"
["class"]=>
string(19) "cListBaseController"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(6) "Artist"
[1]=>
string(4) "3491"
}
}
[8]=>
array(6) {
["file"]=>
string(43) "/home/web/ctic/CTIC/base/cms/controller.php"
["line"]=>
int(19)
["function"]=>
string(10) "showAction"
["class"]=>
string(17) "cArtistController"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(9) "nucci-leo"
[1]=>
string(4) "3491"
}
}
[9]=>
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"
}
[10]=>
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"
}
[11]=>
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'"
}
}