| Exception in PHP Script /index.php/riik/Belize/164 |
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: reisiveeb.ee HTTP User Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Line 500: $objExc->IncrementOffset(); Line 501: throw $objExc; Line 502: } Line 503: Line 504: // Perform the Query and Instantiate the Array Result Line 505: $objDbResult = $objQueryBuilder->Database->Query($strQuery); Line 506: return Tripnote::InstantiateDbResult($objDbResult, $objQueryBuilder->ExpandAsArrayNodes, $objQueryBuilder->ColumnAliasArray); Line 507: } Line 508: Line 509: /** Line 510: * Static Qcubed Query method to query for a count of Tripnote objects.
SELECT
`t0`.`id` AS `a0`,
`t0`.`name` AS `a1`,
`t0`.`trip_id` AS `a2`,
`t0`.`user_id` AS `a3`,
`t0`.`image_id` AS `a4`,
`t0`.`content` AS `a5`,
`t0`.`pictures_source_type` AS `a6`,
`t0`.`pictures_username` AS `a7`,
`t0`.`pictures_album_code` AS `a8`,
`t0`.`pictures_url` AS `a9`,
`t0`.`pictures_size_type` AS `a10`,
`t0`.`comments_available` AS `a11`,
`t0`.`date_from` AS `a12`,
`t0`.`date_to` AS `a13`,
`t0`.`status` AS `a14`,
`t0`.`view_type` AS `a15`,
`t0`.`time_created` AS `a16`,
`t0`.`time_modified` AS `a17`,
`t1`.`id` AS `a18`,
`t1`.`filename` AS `a19`,
`t1`.`type` AS `a20`,
`t1`.`time_created` AS `a21`,
`t2`.`id` AS `a22`,
`t2`.`image_id` AS `a23`,
`t2`.`username` AS `a24`,
`t2`.`password` AS `a25`,
`t2`.`name` AS `a26`,
`t2`.`email` AS `a27`,
`t2`.`description` AS `a28`,
`t2`.`time_created` AS `a29`,
`t2`.`time_modified` AS `a30`,
`t2`.`time_last_login` AS `a31`,
`t2`.`login_count` AS `a32`,
`t2`.`status` AS `a33`,
`t2`.`auth_key` AS `a34`,
`t3`.`id` AS `a35`,
`t3`.`filename` AS `a36`,
`t3`.`type` AS `a37`,
`t3`.`time_created` AS `a38`,
`t4`.`id` AS `a39`,
`t4`.`name` AS `a40`,
`t4`.`description` AS `a41`,
`t4`.`user_id` AS `a42`,
`t4`.`image_id` AS `a43`,
`t4`.`total_distance` AS `a44`,
`t4`.`date_start` AS `a45`,
`t4`.`date_end` AS `a46`,
`t4`.`time_created` AS `a47`,
`t4`.`time_modified` AS `a48`,
((select count(tn.id)
from trip t
inner join tripnote tn on tn.trip_id = t.id
where t.user_id = `t0`.`user_id`
and tn.status = 2)) AS `__user_total_tripnotes`,
((select count(distinct te.country_id)
from trip t
inner join trip_entry te on t.id = te.trip_id
where t.user_id = `t0`.`user_id`)) AS `__user_total_countries`
FROM
`tripnote` AS `t0`
LEFT JOIN `image` AS `t1` ON `t0`.`image_id` = `t1`.`id`
LEFT JOIN `user` AS `t2` ON `t0`.`user_id` = `t2`.`id`
LEFT JOIN `image` AS `t3` ON `t2`.`image_id` = `t3`.`id`
LEFT JOIN `trip` AS `t4` ON `t0`.`trip_id` = `t4`.`id`
WHERE
(
`t0`.`id` IN (select tripnote_id from tripnote_country_v where country_id = 164)
AND
`t0`.`status` = 2
)
ORDER BY
`t0`.`name`#0 /www/apache/domains/www.reisiveeb.ee/htdocs/lib/includes/data_classes/generated/TripnoteGen.class.php(505): QMySqli5Database->Query('SELECT\r\n `t0...')
#1 /www/apache/domains/www.reisiveeb.ee/htdocs/app/private/tripnote/TripnoteUtil.class.php(262): TripnoteGen::QueryArray(Object(QQConditionAnd), Array)
#2 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/country/CountryPanel.class.php(26): TripnoteUtil::LoadCountryTripnoteDtoArray('164')
#3 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(78): CountryPanel->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}