Exception in PHP Script /index.php/regioon/Euroopa/1 |
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 53: left join tripnote tn on tn.id = tc.tripnote_id Line 54: where tn.status = ".TripnoteStatus::Published." Line 55: and c.region_id = ".((int)$intRegionId)." Line 56: group by c.id Line 57: order by c.name asc"; Line 58: $objResult = Data::Query($strQuery); Line 59: if ($objResult) { Line 60: while ($mixRow = $objResult->FetchArray()) { Line 61: $dto = new CountryDto(); Line 62: $dto->strName = $mixRow['name']; Line 63: $dto->intId = $mixRow['id'];
select c.*, ifnull(ct.value, c.name) as name, count(distinct tn.id) as tripnote_count from country c left join country_translation ct on ct.country_id = c.id and ct.language_id = 1 left join tripnote_country_v tc on tc.country_id = c.id left join tripnote tn on tn.id = tc.tripnote_id where tn.status = 2 and c.region_id = 1 group by c.id order by c.name asc
#0 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/Data.class.php(23): QMySqli5Database->Query('select\n\t\tc.*, i...') #1 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionUtil.class.php(58): Data::Query('select\n\t\tc.*, i...') #2 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionUtil.class.php(21): RegionUtil::GetCountryDtoArrayByRegionId('1') #3 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionPanel.class.php(25): RegionUtil::GetRegionDtoById('1') #4 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(78): RegionPanel->Initialize() #5 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(30): ReisiveebForm->PageOperation() #6 /www/apache/domains/www.reisiveeb.ee/htdocs/lib/includes/qcodo/_core/qform/QFormBase.class.php(276): ReisiveebForm->Form_Create() #7 /www/apache/domains/www.reisiveeb.ee/htdocs/index.php(70): QFormBase::Run('ReisiveebPublic...', '/www/apache/dom...') #8 {main}