2025-11-24 12:38:37.94118314.0MbinfoCronjob execution started. PID: 43195
2025-11-24 12:38:37.94248114.0MbinfoDetermined default period: 2020-01-01 - 2026-01-24.
2025-11-24 12:38:37.97002014.0MbinfoStart populating quick reports content for `ClientInvoiceRows` source.
------------------------------------------------------------------------------
mysqli
UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_services` AS serv ON (src.idService=serv.id) LEFT JOIN `rd_offers` AS off ON (serv.id=off.idService) SET src.offerStartDate = DATE(off.startDatetime), src.offerStartDateY = YEAR(off.startDatetime), src.offerStartDateM = MONTH(off.startDatetime), src.offerStartDateYM = DATE_FORMAT(off.startDatetime, '%Y%m'), src.offerDestCountryCode = off.destinationCountryCode, src.offerDestCityId = off.destinationCityId, src.idSupplier = off.idSupplier, src.serviceIdUser = serv.idUser, src.serviceIdOffice = serv.idOffice
------------------------------------------------------------------------------
Query:
UPDATE
`pivotTablesData_clientInvoiceRows` AS src
INNER JOIN `rd_services` AS serv ON (src.idService=serv.id)
LEFT JOIN `rd_offers` AS off ON (serv.id=off.idService)
SET
src.offerStartDate = DATE(off.startDatetime),
src.offerStartDateY = YEAR(off.startDatetime),
src.offerStartDateM = MONTH(off.startDatetime),
src.offerStartDateYM = DATE_FORMAT(off.startDatetime, '%Y%m'),
src.offerDestCountryCode = off.destinationCountryCode,
src.offerDestCityId = off.destinationCityId,
src.idSupplier = off.idSupplier,
src.serviceIdUser = serv.idUser,
src.serviceIdOffice = serv.idOffice
failed. Unknown column 'src.serviceIdUser' in 'field list'
1054: Unknown column 'src.serviceIdUser' in 'field list'
ADOConnection._Execute( UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_services` AS serv ON (src.idService=serv.id) )% line 1195, file: /var/www/html/dan.baluta/tina3/project/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php
ADODB_mysqli.execute( UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_services` AS serv ON (src.idService=serv.id) )% line 201, file: /var/www/html/dan.baluta/tina3/project/_classes/App/QuickReports/PivotTables/Source/ClientInvoiceRows.php
App\QuickReports\PivotTables\Source\ClientInvoiceRows.populateData_services()% line 74, file: /var/www/html/dan.baluta/tina3/project/_classes/App/QuickReports/PivotTables/Source/ClientInvoiceRows.php
App\QuickReports\PivotTables\Source\ClientInvoiceRows.populateData()% line 79, file: /var/www/html/dan.baluta/tina3/project/_classes/App/QuickReports/PivotTables/Source/GeneralAbstract.php
App\QuickReports\PivotTables\Source\GeneralAbstract.reloadData()% line 83, file: /var/www/html/dan.baluta/tina3/project/_classes/App/Cron/Job/QuickReportsPopulate.php
App\Cron\Job\QuickReportsPopulate.populateClientInvoiceRows(2020-01-01, 2026-01-24)% line 38, file: /var/www/html/dan.baluta/tina3/project/_classes/App/Cron/Job/QuickReportsPopulate.php
App\Cron\Job\QuickReportsPopulate.executeJob()% line 541, file: /var/www/html/dan.baluta/tina3/project/_classes/App/Cron/Job/Utils/GeneralAbstract.php
App\Cron\Job\Utils\GeneralAbstract.execute()% line 104, file: /var/www/html/dan.baluta/tina3/project/Modules/Admin/CronJobs/Runner/Controller.php
Modules\Admin\CronJobs\Runner\Controller.actionRun(Array[6])% line 22, file: /var/www/html/dan.baluta/tina3/project/_classes/App/Mvc/Controller/CLIAbstract.php
App\Mvc\Controller\CLIAbstract.execute(run, Array[6])% line 93, file: /var/www/html/dan.baluta/tina3/project/_classes/Engine/Mvc/Dispatcher.php
Engine\Mvc\Dispatcher.dispatch(Array[6])% line 295, file: /var/www/html/dan.baluta/tina3/project/disp.php
2025-11-24 12:38:38.42687714.0MbcriticalCronjob execution stopped prematurely. DBException:Could not populate pivot table info (step2 - services - offer).
------------------------------------------------------------------------------
mysqli
SELECT * FROM `cronJobs` WHERE `id`=? [ (0=>'s') (1=>'QuickReportsPopulate') ]
------------------------------------------------------------------------------
------------------------------------------------------------------------------
mysqli
UPDATE `cronJobs` SET `status`=?, `lastUpdateTime`=?, `idUpdateUser`=?, `updatesCount`=updatesCount+1 WHERE `id`=? [ (0=>'ssis') (1=>'a:8:{s:8:"progress";d:1;s:12:"progressStep";i:0;s:13:"progressSt...') (2=>'2025-11-24 12:38:37') (3=>'0') (4=>'QuickReportsPopulate') ]
------------------------------------------------------------------------------
2025-11-24 12:38:38.43627514.0MbinfoCronjob execution ended.
------------------------------------------------------------------------------
mysqli
UPDATE `cronJobsLogs` SET `status`=?, `errorStatus`=? WHERE `id`=? [ (0=>'sss') (1=>'ended') (2=>'ci') (3=>'190484') ]
------------------------------------------------------------------------------
------------------------------------------------------------------------------
mysqli
INSERT INTO `zzUserTraces_202511` ( `module`, `action`, `entityType`, `entityOperation`, `idEntity`, `extraData`, `timestamp`, `idUser` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?) [ (0=>'ssssssdissssssdissssssdissssssdissssssdi') (1=>'') (2=>'') (3=>'CronJob') (4=>'update') (5=>'QuickReportsPopulate') (6=>'') (7=>'1763980717.9388') (8=>'0') (9=>'Modules/Admin/CronJobs/Runner') (10=>'actionRun') (11=>'') (12=>'') (13=>'') (14=>'') (15=>'1763980717.939') (16=>'0') (17=>'Modules/Admin/CronJobs/Runner') (18=>'actionRun') (19=>'CronJob') (20=>'update') (21=>'QuickReportsPopulate') (22=>'') (23=>'1763980717.9412') (24=>'0') (25=>'Modules/Admin/CronJobs/Runner') (26=>'actionRun') (27=>'App\ReportsData\Params') (28=>'save') (29=>'') (30=>'') (31=>'1763980717.97') (32=>'0') (33=>'Modules/Admin/CronJobs/Runner') (34=>'actionRun') (35=>'CronJob') (36=>'update') (37=>'QuickReportsPopulate') (38=>'') (39=>'1763980718.4362') (40=>'0') ]
------------------------------------------------------------------------------