Cdr not working after restore

FreePBX Installation / Upgrade
,
1

Hi, took backup from 16 and restored it to 17. cdr are not logging anymore

WARNING[1221]: res_odbc.c:529 ast_odbc_print_errors: SQL Execute returned an error: 42S02: [ma-3.1.15][10.11.11-MariaDB-0+deb12u1]Table 'asteriskcdrdb.transient_cdr' doesn't exist
[2025-03-28 20:12:25] WARNING[1221]: res_odbc.c:424 ast_odbc_prepare_and_execute: SQL Execute error -1!
[2025-03-28 20:12:25] WARNING[1221]: cdr_adaptive_odbc.c:766 odbc_log: cdr_adaptive_odbc: Insert failed on 'asteriskcdrdb:cdr'.  CDR failed: INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, lastapp, lastdata, duration, billsec, disposition, amaflags, uniqueid, did, cnum, cnam, linkedid, sequence) VALUES ({ ts '2025-03-28 20:12:16' }, '"+306944XXXXXX" <+306944XXXXXX>', '+306944XXXXXX', '99', 'ext-group', 'PJSIP/OTE-000009cd', 'Playback', 'custom/greeting_ale', 8, 8, 'ANSWERED', 3, '1743185536.4036', '+302310XXXXXX', '+306944XXXXXX', '+306944XXXXXX', '1743185536.4036', 3011)
2

Hi @xtrgeo
It looks like transient_cdr table doesn’t exist in asteriskcdrdb,
You can confirm by runn this command mysql -D asteriskcdrdb -e 'show tables;'

to fix this follow the below steps

  1. Goto Advanced Settings in theGUI and look for Transient CDR then set it to NO
  2. Submit the changes and press the apply config button
  3. Once done, just run fwconsole ma install restapps on cli mode then
  4. Run fwconsole r and check the transient_cdr table will be created, now test the calls