[bug]: CDR Reports Pro does not update with new calls

[stevepbxc]

FreePBX Version

FreePBX 16

Issue Description

CDR Reports Pro was installed. The sync went fine, but it does not update with new records after the sync.

Operating Environment

FreePBX Framework 16.0.45
Asterisk version: 18.9
cdr: 16.0.46.27
cdrpro: 16.0.33.19

Relevant log output

The logfile cdrpro_out.log shows this:

2026-01-15 16:46 +01:00: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'uniqueid' cannot be null in file /var/www/html/admin/modules/cdrpro/Cdrpro.class.php on line 1812
2026-01-15 16:46 +01:00: Stack trace:
2026-01-15 16:46 +01:00:   1. PDOException->() /var/www/html/admin/modules/cdrpro/Cdrpro.class.php:1812
2026-01-15 16:46 +01:00:   2. PDOStatement->execute() /var/www/html/admin/modules/cdrpro/Cdrpro.class.php:1812
2026-01-15 16:46 +01:00:   3. FreePBX\modules\Cdrpro->cdrpro_Unprocessed_uniqueids() /var/www/html/admin/modules/cdrpro/functions.inc/call-hangup-event.php:146
2026-01-15 16:46 +01:00:   4. cdrpro_UNprocessed_uniqueids() /var/www/html/admin/modules/cdrpro/functions.inc/call-hangup-event.php:9
2026-01-15 16:46 +01:00:   5. {closure}() /var/www/html/admin/libraries/php-asmanager.php:1614
2026-01-15 16:46 +01:00:   6. AGI_AsteriskManager->process_event() /var/www/html/admin/libraries/php-asmanager.php:348
2026-01-15 16:46 +01:00:   7. AGI_AsteriskManager->wait_response() /var/www/html/admin/modules/cdrpro/functions.inc/call-hangup-event.php:43
2026-01-15 16:46 +01:00:   8. unknown() /var/www/html/admin/modules/cdrpro/call-hangup-event.php:25

[msanthosh18]

Hi @stevepbxc make sure cdrpro pm2 process is running to sync the new call. every 5 min cdrpro job will be executed

fwconsole pm2 --list

If the service is not running, Please restart the Service by running the command fwconsole pm2 --restart cdrpro Or fwconsole ma install cdrpro

[stevepbxc]

Hi,

Yes the service is running. I restarted it to be sure:

fwconsole pm2 --list

+---------------------------+-------+---------+----------+--------------------+------+---------+
| Process Name | PID | Status | Restarts | Uptime | CPU | Mem |
+---------------------------+-------+---------+----------+--------------------+------+---------+
| xmpp | 4770 | online | 0 | 5 months, 24 days | 0% | 95,15MB |
| core-calltransfer-monitor | 0 | stopped | 0 | 0 | 0% | 0,00B |
| ucp | 12514 | online | 0 | 1 month, 18 days | 0,2% | 75,57MB |
| cdrpro | 19060 | online | 18 | 1 hour, 21 minutes | 0% | 30,09MB |
+---------------------------+-------+---------+----------+--------------------+------+---------+

[msanthosh18]

Hi @stevepbxc
Can you please check whether the livecallsync job exists? by running below command
fwconsole job --list | grep cdrpro

It runs every 5 minutes, and any call entry older than 5 minutes will be processed.

Step 1: Make a test call.
Step 2: Verify that the MySQL entry for the test call is present by running:

mysql -D asterisk -e "SELECT * FROM cdrpro_unprocessed_uniqueids;"

Step 3: Monitor the logs by running:

tail -f /var/log/asterisk/cdrpro_out.log

If you encounter any errors, please share the error details.

[stevepbxc]

Hi @msanthosh18

I see the new calls:

]# mysql -D asterisk -e "SELECT * FROM cdrpro_unprocessed_uniqueids;"
+------+--------------------+--------------------+----------------+---------------------+
| id | uniqueid | linkedid | process_status | calldate |
+------+--------------------+--------------------+----------------+---------------------+
| 2624 | 1768567345.4138784 | 1768567345.4138784 | 0 | 2026-01-16 13:45:22 |
| 2625 | 1768566115.4137796 | 1768566115.4137796 | 0 | 2026-01-16 13:46:50 |
| 2626 | 1768567435.4139187 | 1768567435.4139187 | 0 | 2026-01-16 13:46:59 |
| 2627 | 1768567533.4139394 | 1768567533.4139394 | 0 | 2026-01-16 13:47:01 |
| 2628 | 1768567626.4139498 | 1768567626.4139498 | 0 | 2026-01-16 13:47:57 |
| 2629 | 1768567386.4138905 | 1768567386.4138905 | 0 | 2026-01-16 13:49:28 |
| 2630 | 1768567788.4139652 | 1768567788.4139652 | 0 | 2026-01-16 13:52:00 |
+------+--------------------+--------------------+----------------+---------------------+

Every 5 minutes they are processed. But in /var/log/asterisk/cdrpro_out.log I only see this:

2026-01-16 13:32 +01:00: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'uniqueid' cannot be null in file /var/www/html/admin/modules/cdrpro/Cdrpro.class.php on line 1812
2026-01-16 13:32 +01:00: Stack trace:
2026-01-16 13:32 +01:00: 1. PDOException->() /var/www/html/admin/modules/cdrpro/Cdrpro.class.php:1812
2026-01-16 13:32 +01:00: 2. PDOStatement->execute() /var/www/html/admin/modules/cdrpro/Cdrpro.class.php:1812
2026-01-16 13:32 +01:00: 3. FreePBX\modules\Cdrpro->cdrpro_Unprocessed_uniqueids() /var/www/html/admin/modules/cdrpro/functions.inc/call-hangup-event.php:146
2026-01-16 13:32 +01:00: 4. cdrpro_UNprocessed_uniqueids() /var/www/html/admin/modules/cdrpro/functions.inc/call-hangup-event.php:9
2026-01-16 13:32 +01:00: 5. {closure}() /var/www/html/admin/libraries/php-asmanager.php:1614
2026-01-16 13:32 +01:00: 6. AGI_AsteriskManager->process_event() /var/www/html/admin/libraries/php-asmanager.php:348
2026-01-16 13:32 +01:00: 7. AGI_AsteriskManager->wait_response() /var/www/html/admin/modules/cdrpro/functions.inc/call-hangup-event.php:43
2026-01-16 13:32 +01:00: 8. include() /var/www/html/admin/modules/cdrpro/call-hangup-event.php:25
2026-01-16 13:32 +01:00: Call Hangup Event listener staring

No new entries there.

[jissphilip]

Hi @stevepbxc, Can you check in the table cdrpro_unprocessed_uniqueids and check whether any entry is having empty/ blank in the uniqueid column
select * from cdrpro_unprocessed_uniqueids whereuniqueid='' Or uniqueid=NULL;
if any entry is there , please remove it
Delete from cdrpro_unprocessed_uniqueids where uniqueid='' Or uniqueid=NULL;

Thanks

[stevepbxc]

Sorry for the late reply, but there are no entries empty/ blank in the uniqueid column.