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 [] []