Qxact does not sync

Commercial Modules
1

Freepbx 15, Queue pro 15.0.7.30
Qxact report stopped working after a reboot on our pbx. Queue.log files are showing logs. I tried
[root@usash-pbx-pri etc]# fwconsole qxactreports --sync --verbose
Using Queue Logs
Importing /var/log/asterisk/queue_log

In QueueDataImport.php line 79:

[PDOException (23000)]
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘waittime’ cannot be null

Exception trace:
() at /var/www/html/admin/modules/qxact_reports/QueueDataImport.php:79
PDOStatement->execute() at /var/www/html/admin/modules/qxact_reports/QueueDataImport.php:79
FreePBX\modules\Qxact_reports\QueueDataImport->updateCalls() at /var/www/html/admin/modules/qxact_reports/Console/Qxact_reports.class.php:180
FreePBX\Console\Command\Qxact_reports->syncronize() at /var/www/html/admin/modules/qxact_reports/Console/Qxact_reports.class.php:43
FreePBX\Console\Command\Qxact_reports->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:960
Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:255
Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:148
Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:163

qxactreports [–sync] [–dryrun] [–forcetype FORCETYPE] [–import IMPORT] [–reimport REIMPORT] [–runscheduledreports RUNSCHEDULEDREPORTS]

if waittime means maxwait time for queue, all queues are set to unlimited or 180s.

Whats wrong then?

2

Hi @moghimigiti This issue has already been addressed in FreePBX 16.

For now, I have backported the fix and pushed it to the edge module for you to try. However, please note that we are no longer issuing fixes for FreePBX 15. We strongly recommend that you consider upgrading to FreePBX 16, or you might want to try the FreePBX 17 beta.

fwconsole ma downloadinstall qxact_reports --tag=15.0.21
fwconsole chown
fwconsole r

Thanks

3

Yes, its working now , Thanks.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.