| Exception in PHP Script /index.php/regioon/Kesk-Ameerika/5 |
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 = 5 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('5')
#3 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionPanel.class.php(25): RegionUtil::GetRegionDtoById('5')
#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}