NEW IncrediblePBX 2026-Debian13

[kenn10]

Try this:
3211 [2026-06-07 14:05:23] VERBOSE[238655][C-0000000b] pbx.c: Spawn extension (macro-hangupcall, s, 6) exited non-zero on 'PJSIP/210-00000010'
3212 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute returned an error: 42S02: [ma-3.1.15][11.8.6-MariaDB-0+deb13u1 from Debian]Table 'asteriskcdrdb.transient_cdr' doesn't ex ist
3213 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute error -1!
3214 [2026-06-07 14:05:23] WARNING[3194097] cdr_adaptive_odbc.c: cdr_adaptive_odbc: Insert failed on 'asteriskcdrdb:cdr'. CDR failed: INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, uniqueid, cnum, cnam, outbound_cnum, outbound_cnam, linkedid, sequence) VALUES ({ ts '2026-06-07 14:04: 38' }, '"John Doe" <18285551212>', '18285551212', '17704557141', 'from-internal', 'PJSIP/210-00000010', 'PJSIP/BulkVS-00000011', 'Dial', 'PJSIP/17704557141@BulkVS,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obrout', 44, 36, 'ANSWERED', 3, '1780855478.16', '210', 'Office 210', '18285551212', 'John Doe', '1780855478.16', 19)

 

[Samot]

Try this:
3211 [2026-06-07 14:05:23] VERBOSE[238655][C-0000000b] pbx.c: Spawn extension (macro-hangupcall, s, 6) exited non-zero on 'PJSIP/210-00000010'
3212 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute returned an error: 42S02: [ma-3.1.15][11.8.6-MariaDB-0+deb13u1 from Debian]Table 'asteriskcdrdb.transient_cdr' doesn't ex ist
3213 [2026-06-07 14:05:23] WARNING[3194097] res_odbc.c: SQL Execute error -1!
3214 [2026-06-07 14:05:23] WARNING[3194097] cdr_adaptive_odbc.c: cdr_adaptive_odbc: Insert failed on 'asteriskcdrdb:cdr'. CDR failed: INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, uniqueid, cnum, cnam, outbound_cnum, outbound_cnam, linkedid, sequence) VALUES ({ ts '2026-06-07 14:04: 38' }, '"John Doe" <18285551212>', '18285551212', '17704557141', 'from-internal', 'PJSIP/210-00000010', 'PJSIP/BulkVS-00000011', 'Dial', 'PJSIP/17704557141@BulkVS,300,Tb(func-apply -sipheaders^s^1,(1))U(sub-send-obrout', 44, 36, 'ANSWERED', 3, '1780855478.16', '210', 'Office 210', '18285551212', 'John Doe', '1780855478.16', 19)

Now we would need to see

fwconsole m
MariaDB [asterisk]> use asteriskcdrdb;
MariaDB [asteriskcdrdb]> show columns from cdr;

Paste the output so we can see the structure and settings.

 

[kenn10]

Now we would need to see


Paste the output so we can see the structure and settings.

I already created the transient_cdr table and at that point everything works correctly. Not sure what showing the cdr table will do now.

+---------------+--------------+------+-----+---------------------+-------+
| Field         | Type         | Null | Key | Default             | Extra |
+---------------+--------------+------+-----+---------------------+-------+
| calldate      | datetime     | NO   | MUL | 1000-01-01 00:00:00 |       |
| clid          | varchar(80)  | NO   |     |                     |       |
| src           | varchar(80)  | NO   |     |                     |       |
| dst           | varchar(80)  | NO   | MUL |                     |       |
| dcontext      | varchar(80)  | NO   |     |                     |       |
| channel       | varchar(80)  | NO   |     |                     |       |
| dstchannel    | varchar(80)  | NO   | MUL |                     |       |
| lastapp       | varchar(80)  | NO   |     |                     |       |
| lastdata      | varchar(80)  | NO   |     |                     |       |
| duration      | int(11)      | NO   |     | 0                   |       |
| billsec       | int(11)      | NO   |     | 0                   |       |
| disposition   | varchar(45)  | NO   |     |                     |       |
| amaflags      | int(11)      | NO   |     | 0                   |       |
| accountcode   | varchar(20)  | NO   | MUL |                     |       |
| uniqueid      | varchar(32)  | NO   | MUL |                     |       |
| userfield     | varchar(255) | NO   |     |                     |       |
| did           | varchar(50)  | NO   | MUL |                     |       |
| recordingfile | varchar(255) | NO   | MUL |                     |       |
| cnum          | varchar(80)  | NO   |     |                     |       |
| cnam          | varchar(80)  | NO   |     |                     |       |
| outbound_cnum | varchar(80)  | NO   |     |                     |       |
| outbound_cnam | varchar(80)  | NO   |     |                     |       |
| dst_cnam      | varchar(80)  | NO   |     |                     |       |
| linkedid      | varchar(32)  | NO   | MUL |                     |       |
| peeraccount   | varchar(80)  | NO   |     |                     |       |
| sequence      | int(11)      | NO   |     | 0                   |       |
+---------------+--------------+------+-----+---------------------+-------+

 

[kenn10]

My suggestion for Sangoma would be to modify the FreePBX-17 backup/restore module so that if the transient_cdr table does not exist during a restore function, that it be created. That would solve the issue. The other problem is that even if you set transient_cdr to "no" in the Settings > Advanced Settings and fwconsole restart, it still errors out if that table is not there.

 

[Samot]

My suggestion for Sangoma would be to modify the FreePBX-17 backup/restore module so that if the transient_cdr table does not exist during a restore function, that it be created. That would solve the issue. The other problem is that even if you set transient_cdr to "no" in the Settings > Advanced Settings and fwconsole restart, it still errors out if that table is not there.

Oh there's other issues with how they handle the restore. This helped track that down.