FreePBX 16 WarmSpare restore fails to restore IVRs

The WarmSpare job completes but IVRs don’t load and backup.log shows the following error:
I’ve reinstalled IVR on the WarmSpare, and confirmed both PBXs are fully up to date.

4476	[2025-01-15 07:48:33] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Processing ivr [] []	
4477	[2025-01-15 07:48:33] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Resetting ivr module data [] []	
4478	[2025-01-15 07:48:34] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Restoring from ivr [FreePBX\modules\Ivr\Restore] [] []	
4479	[2025-01-15 07:48:34] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.ERROR]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accept_pound_key' in 'field list' on line 241 of file /var/www/html/admin/modules/ivr/Ivr.class.php [] []	
4480	[2025-01-15 07:48:34] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: #0 /var/www/html/admin/modules/ivr/Ivr.class.php(241): PDOStatement->execute() #1 /var/www/html/admin/modules/ivr/Restore.php(8): FreePBX\modules\Ivr->saveDetail() #2 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(141): FreePBX\modules\Ivr\Restore->runRestore() #3 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(129): FreePBX\modules\Backup\Handlers\Restore\Common->runRestore() #4 /var/www/html/admin/modules/backup/Handlers/Restore/Multiple.php(71): FreePBX\modules\Backup\Handlers\Restore\Common->processModule() #5 /var/www/html/admin/modules/backup/Console/Backup.class.php(338): FreePBX\modules\Backup\Handlers\Restore\Multiple->process() #6 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php(255): FreePBX\Console\Command\Backup->execute() #7 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(992): Symfony\Component\Console\Command\Command->run() #8 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand() #9 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun() #10 /var/lib/asterisk/bin/fwconsole(163): Symfony\Component\Console\Application->run() #11 {main} [] []	
4481	[2025-01-15 07:48:34] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Processing logfiles [] []	
4482	[2025-01-15 07:48:34] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Resetting logfiles module data [] []	
4483	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Restoring from logfiles [FreePBX\modules\Logfiles\Restore] [] []	
4484	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Importing Table logfile_settings from logfiles [] []	
4485	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Cleaning table: logfile_settings [] []	
4486	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Importing Table logfile_logfiles from logfiles [] []	
4487	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Cleaning table: logfile_logfiles [] []	
4488	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Done [] []	
4489	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: [] []	
4490	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Processing manager [] []	
4491	[2025-01-15 07:48:35] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Resetting manager module data [] []	
4492	[2025-01-15 07:48:37] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Restoring from manager [FreePBX\modules\Manager\Restore] [] []	
4493	[2025-01-15 07:48:37] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.ERROR]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null on line 145 of file /var/www/html/admin/modules/manager/Manager.class.php [] []	
4494	[2025-01-15 07:48:37] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: #0 /var/www/html/admin/modules/manager/Manager.class.php(145): PDOStatement->execute() #1 /var/www/html/admin/modules/manager/Restore.php(8): FreePBX\modules\Manager->upsert() #2 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(141): FreePBX\modules\Manager\Restore->runRestore() #3 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(129): FreePBX\modules\Backup\Handlers\Restore\Common->runRestore() #4 /var/www/html/admin/modules/backup/Handlers/Restore/Multiple.php(71): FreePBX\modules\Backup\Handlers\Restore\Common->processModule() #5 /var/www/html/admin/modules/backup/Console/Backup.class.php(338): FreePBX\modules\Backup\Handlers\Restore\Multiple->process() #6 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php(255): FreePBX\Console\Command\Backup->execute() #7 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(992): Symfony\Component\Console\Command\Command->run() #8 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand() #9 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun() #10 /var/lib/asterisk/bin/fwconsole(163): Symfony\Component\Console\Application->run() #11 {main} [] []	
4495	[2025-01-15 07:48:37] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Processing miscapps [] []	
4496	[2025-01-15 07:48:37] [951c9b22-fc0f-4c0d-832f-dd59ac3d2bea.INFO]: Resetting miscapps module data [] []

Looks like other server DB schema is not up to date, try to install the latest ivr module please.

fwconsole ma downloadinstall ivr --tag=16.0.10

Best Regards,
Kapil

1 Like

That solved it, thank you.

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