| Exception in PHP Script /index.php/sisukaart |
PHP Version: 7.4.33; Zend Engine Version: 3.4.0; Qcubed Version: 1.0.0 RC2 (QCubed 1.0 RC2) Application: Apache; Server Name: www.reisiveeb.ee HTTP User Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Line 21: where
Line 22: tn.status = ".TripnoteStatus::Published."
Line 23: group by tn.id
Line 24: order by r.name asc, c.name asc, tn.name asc
Line 25: ";
Line 26: $objResult = Data::Query($strQuery);
Line 27: $arrToReturn = array();
Line 28: if ($objResult) {
Line 29: while ($mixRow = $objResult->FetchArray()) {
Line 30: if (!isset($arrToReturn[$mixRow['region_id']])) {
Line 31: $arrToReturn[$mixRow['region_id']] = array();
select tn.id, tn.name, u.username, c.id as country_id, ifnull(ct.value, c.name) as country_name, r.id as region_id, ifnull(rt.value, r.name) as region_name from tripnote tn inner join tripnote_country_v tc on tc.tripnote_id = tn.id inner join country c on tc.country_id = c.id left join country_translation ct on ct.country_id = c.id and ct.language_id = 1 inner join region r on c.region_id = r.id left join region_translation rt on rt.region_id = r.id and rt.language_id = 1 inner join user u on tn.user_id = u.id where tn.status = 2 group by tn.id order by r.name asc, c.name asc, tn.name asc
#0 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/Data.class.php(23): QMySqli5Database->Query('\n\t\tselect\n\t\t\ttn...')
#1 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/sitemap/SitemapUtil.class.php(26): Data::Query('\n\t\tselect\n\t\t\ttn...')
#2 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/sitemap/SitemapPanel.class.php(18): SitemapUtil::GetTripnoteArray()
#3 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(78): SitemapPanel->Initialize()
#4 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(30): ReisiveebForm->PageOperation()
#5 /www/apache/domains/www.reisiveeb.ee/htdocs/lib/includes/qcodo/_core/qform/QFormBase.class.php(276): ReisiveebForm->Form_Create()
#6 /www/apache/domains/www.reisiveeb.ee/htdocs/index.php(70): QFormBase::Run('ReisiveebPublic...', '/www/apache/dom...')
#7 {main}