Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-22695

Error on restore of sipsettings module

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 15
    • Fix Version/s: None
    • Component/s: Backup & Restore
    • Labels:
      None
    • Asterisk Version:
      16
    • Distro Version:
      15
    • Distro:
      FreePBX Distro

      Description

      backup module version 15.0.10.61
      sipsettings module version 15.0.6.39

      Performing a backup/restore from primary to warmspare server with all module versions synchronized to the same version.

      Restore of sipsettings fails with the following lines in the the backup.log:

      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: Processing sipsettings [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: Resetting sipsettings module data [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: NOT Resetting sipsettings module data [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: Restoring from sipsettings [FreePBX\modules\Sipsettings\Restore] [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: warmspare enabled [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: Excluding Nat settings 'externip' [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: Excluding Nat settings 'localnets' [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.ERROR]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'data' cannot be null on line 1245 of file /var/www/html/admin/modules/sipsettings/Sipsettings.class.php [] []
      [2021-07-27 21:37:28] [04bc965c-4042-46c3-9d56-6cd481d4f2c2.INFO]: #0 /var/www/html/admin/modules/sipsettings/Sipsettings.class.php(1245): PDOStatement->execute(Array) #1 /var/www/html/admin/modules/sipsettings/Restore.php(88): Sipsettings->loadDbConfigs(Array) #2 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(138): FreePBX\modules\Sipsettings\Restore->runRestore() #3 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(126): FreePBX\modules\Backup\Handlers\Restore\Common->runRestore(Object(FreePBX\modules\Sipsettings\Restore)) #4 /var/www/html/admin/modules/backup/Handlers/Restore/Multiple.php(61): FreePBX\modules\Backup\Handlers\Restore\Common->processModule('sipsettings', '15.0.6.39') #5 /var/www/html/admin/modules/backup/Console/Backup.class.php(324): FreePBX\modules\Backup\Handlers\Restore\Multiple->process(true) #6 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php(255): FreePBX\Console\Command\Backup->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #7 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(960): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #8 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand(Object(FreePBX\Console\Command\Backup), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #9 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #10 /var/lib/asterisk/bin/fwconsole(163): Symfony\Component\Console\Application->run() #11

      {main}

      [] []

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                billsimon Bill Simon
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Feedback Requested:

                  NextupJiraPlusStatus

                  Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.