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

sipsettings module upgrade failure and bad dependencies

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 13, 14, 15
    • Fix Version/s: 13, 14, 15
    • Component/s: Asterisk SIP Settings
    • Labels:
      None
    • ToDo:
    • Asterisk Version:
      16
    • Distro Version:
      12.7.5-1902-3.sng7
    • Distro:
      FreePBX Distro

      Description

      module version 15.0.6.1 fails to install initially 

      subsequent modules fail with dependencies looking for versions 12.0.13 and 13.0.26 ???

       

      3 difference dependencies referenced for sip settings in the following dialogue

       

       

      
[root@freepbx ~]# fwconsole ma --edge upgradeall --verbose
Edge repository temporarily enabled
No repos specified, using: [standard,extended,commercial] from last GUI settings
 
Module(s) requiring upgrades: endpoint, restapps, sipsettings, sipstation, voicemail
Upgrading module 'sipsettings' from 15.0.6.1 to 15.0.6.1
Downloading module 'sipsettings'
Processing sipsettings
Verifying local module download...Verified
Extracting...Done
Download completed in 0 seconds
Updating tables sipsettings...Done
already exists
Migrate rtp.conf values if needed and initialize
 
In Database.class.php line 209:
                                                                                 
  [PDOException (42S22)]                                                         
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data' in 'field list' 
                                                                                 
 
Exception trace:
 () at /var/www/html/admin/libraries/BMO/Database.class.php:209
 PDO->query() at /var/www/html/admin/libraries/BMO/Database.class.php:209
 FreePBX\Database->query() at /var/www/html/admin/libraries/BMO/Database.class.php:303
 FreePBX\Database->sql_getOne() at /var/www/html/admin/libraries/BMO/Database.class.php:250
 FreePBX\Database->sql() at /var/www/html/admin/libraries/DB.class.php:235
 DB->sql() at /var/www/html/admin/libraries/sql.functions.php:29
 sql() at /var/www/html/admin/modules/sipsettings/install.php:213
 include_once() at /var/www/html/admin/libraries/modulefunctions.class.php:2630
 module_functions->_doinclude() at /var/www/html/admin/libraries/modulefunctions.class.php:2546
 module_functions->_runscripts() at /var/www/html/admin/libraries/modulefunctions.class.php:2018
 module_functions->install() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:415
 FreePBX\Console\Command\Moduleadmin->doInstall() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:1420
 FreePBX\Console\Command\Moduleadmin->handleArgs() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:214
 FreePBX\Console\Command\Moduleadmin->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:953
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:248
 Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:136
 
ma [-f|--force] [-d|--debug] [--edge] [--stable] [--color] [--skipchown] [-e|--autoenable] [--skipdisabled] [--snapshot SNAPSHOT] [--format FORMAT] [-R|--repo REPO] [-t|--tag TAG] [--skipbreakingcheck [SKIPBREAKINGCHECK]] [--sendemail] [--onlystdout] [--] [<args>]...
 
Upgrading module 'endpoint' from 15.0.16.21 to 15.0.16.21
Downloading module 'endpoint'
Processing endpoint
Verifying local module download...Verified
Extracting...Done
Download completed in 1 seconds
Detected Missing Dependency of: sipsettings 12.0.13
Found local Dependency of: sipsettings 15.0.6.1
Installing Missing Dependency of: sipsettings 12.0.13
Updating tables sipsettings...Done
already exists
Migrate rtp.conf values if needed and initialize
 
In Database.class.php line 209:
                                                                                 
  [PDOException (42S22)]                                                         
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data' in 'field list' 
                                                                                 
 
Exception trace:
 () at /var/www/html/admin/libraries/BMO/Database.class.php:209
 PDO->query() at /var/www/html/admin/libraries/BMO/Database.class.php:209
 FreePBX\Database->query() at /var/www/html/admin/libraries/BMO/Database.class.php:303
 FreePBX\Database->sql_getOne() at /var/www/html/admin/libraries/BMO/Database.class.php:250
 FreePBX\Database->sql() at /var/www/html/admin/libraries/DB.class.php:235
 DB->sql() at /var/www/html/admin/libraries/sql.functions.php:29
 sql() at /var/www/html/admin/modules/sipsettings/install.php:213
 include_once() at /var/www/html/admin/libraries/modulefunctions.class.php:2630
 module_functions->_doinclude() at /var/www/html/admin/libraries/modulefunctions.class.php:2546
 module_functions->_runscripts() at /var/www/html/admin/libraries/modulefunctions.class.php:2018
 module_functions->install() at /var/www/html/admin/libraries/modulefunctions.class.php:846
 module_functions->resolveDependencies() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:410
 FreePBX\Console\Command\Moduleadmin->doInstall() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:1420
 FreePBX\Console\Command\Moduleadmin->handleArgs() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:214
 FreePBX\Console\Command\Moduleadmin->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:953
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:248
 Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:136
 
ma [-f|--force] [-d|--debug] [--edge] [--stable] [--color] [--skipchown] [-e|--autoenable] [--skipdisabled] [--snapshot SNAPSHOT] [--format FORMAT] [-R|--repo REPO] [-t|--tag TAG] [--skipbreakingcheck [SKIPBREAKINGCHECK]] [--sendemail] [--onlystdout] [--] [<args>]...
 
Upgrading module 'restapps' from 15.0.12 to 15.0.12
Downloading module 'restapps'
Processing restapps
Verifying local module download...Verified
Extracting...Done
Download completed in 0 seconds
Detected Missing Dependency of: endpoint 13.0.70
Found local Dependency of: endpoint 15.0.16.21
Detected Missing Dependency of: sipsettings 12.0.13
Found local Dependency of: sipsettings 15.0.6.1
Installing Missing Dependency of: sipsettings 12.0.13
 
In DB_Helper.class.php line 358:
                                         
  [Exception]                            
  setMultiConfig was not given an array 
                                         
 
Exception trace:
 () at /var/www/html/admin/libraries/BMO/DB_Helper.class.php:358
 FreePBX\DB_Helper->setMultiConfig() at /var/www/html/admin/libraries/BMO/Modules.class.php:480
 FreePBX\Modules->getOnlineJson() at /var/www/html/admin/libraries/modulefunctions.class.php:1933
 module_functions->install() at /var/www/html/admin/libraries/modulefunctions.class.php:846
 module_functions->resolveDependencies() at /var/www/html/admin/libraries/modulefunctions.class.php:821
 module_functions->resolveDependencies() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:410
 FreePBX\Console\Command\Moduleadmin->doInstall() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:1420
 FreePBX\Console\Command\Moduleadmin->handleArgs() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:214
 FreePBX\Console\Command\Moduleadmin->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:953
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:248
 Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:136
 
ma [-f|--force] [-d|--debug] [--edge] [--stable] [--color] [--skipchown] [-e|--autoenable] [--skipdisabled] [--snapshot SNAPSHOT] [--format FORMAT] [-R|--repo REPO] [-t|--tag TAG] [--skipbreakingcheck [SKIPBREAKINGCHECK]] [--sendemail] [--onlystdout] [--] [<args>]...
 
Upgrading module 'sipstation' from 15.0.3.3 to 15.0.3.3
Downloading module 'sipstation'
Processing sipstation
Verifying local module download...Verified
Extracting...Done
Download completed in 0 seconds
Detected Missing Dependency of: sipsettings 13.0.26
Found local Dependency of: sipsettings 15.0.6.1
Installing Missing Dependency of: sipsettings 13.0.26
Updating tables sipsettings...Done
already exists
Migrate rtp.conf values if needed and initialize
 
In Database.class.php line 209:
                                                                                 
  [PDOException (42S22)]                                                         
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data' in 'field list' 
                                                                                 
 
Exception trace:
 () at /var/www/html/admin/libraries/BMO/Database.class.php:209
 PDO->query() at /var/www/html/admin/libraries/BMO/Database.class.php:209
 FreePBX\Database->query() at /var/www/html/admin/libraries/BMO/Database.class.php:303
 FreePBX\Database->sql_getOne() at /var/www/html/admin/libraries/BMO/Database.class.php:250
 FreePBX\Database->sql() at /var/www/html/admin/libraries/DB.class.php:235
 DB->sql() at /var/www/html/admin/libraries/sql.functions.php:29
 sql() at /var/www/html/admin/modules/sipsettings/install.php:213
 include_once() at /var/www/html/admin/libraries/modulefunctions.class.php:2630
 module_functions->_doinclude() at /var/www/html/admin/libraries/modulefunctions.class.php:2546
 module_functions->_runscripts() at /var/www/html/admin/libraries/modulefunctions.class.php:2018
 module_functions->install() at /var/www/html/admin/libraries/modulefunctions.class.php:846
 module_functions->resolveDependencies() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:410
 FreePBX\Console\Command\Moduleadmin->doInstall() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:1420
 FreePBX\Console\Command\Moduleadmin->handleArgs() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:214
 FreePBX\Console\Command\Moduleadmin->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:953
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:248
 Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:136
 
ma [-f|--force] [-d|--debug] [--edge] [--stable] [--color] [--skipchown] [-e|--autoenable] [--skipdisabled] [--snapshot SNAPSHOT] [--format FORMAT] [-R|--repo REPO] [-t|--tag TAG] [--skipbreakingcheck [SKIPBREAKINGCHECK]] [--sendemail] [--onlystdout] [--] [<args>]...
 
Upgrading module 'voicemail' from 15.0.13 to 15.0.13
Downloading module 'voicemail'
Processing voicemail
Verifying local module download...Verified
Extracting...Done
Download completed in 0 seconds
Updating tables voicemail_admin...Done
 
In WriteConfig.class.php line 191:
                                         
  [Whoops\Exception\ErrorException (2)] 
  chgrp(): Operation not permitted       
                                         
 
Exception trace:
 () at /var/www/html/admin/libraries/BMO/WriteConfig.class.php:191
 Whoops\Run->handleError() at n/a:n/a
 chgrp() at /var/www/html/admin/libraries/BMO/WriteConfig.class.php:191
 FreePBX\WriteConfig->writeFile() at /var/www/html/admin/libraries/BMO/WriteConfig.class.php:80
 FreePBX\WriteConfig->writeConfigs() at /var/www/html/admin/libraries/BMO/WriteConfig.class.php:66
 FreePBX\WriteConfig->writeConfig() at /var/www/html/admin/modules/voicemail/Voicemail.class.php:440
 FreePBX\modules\Voicemail->saveVoicemail() at /var/www/html/admin/modules/voicemail/install.php:183
 include_once() at /var/www/html/admin/libraries/modulefunctions.class.php:2630
 module_functions->_doinclude() at /var/www/html/admin/libraries/modulefunctions.class.php:2546
 module_functions->_runscripts() at /var/www/html/admin/libraries/modulefunctions.class.php:2018
 module_functions->install() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:415
 FreePBX\Console\Command\Moduleadmin->doInstall() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:1420
 FreePBX\Console\Command\Moduleadmin->handleArgs() at /var/www/html/admin/libraries/Console/Moduleadmin.class.php:214
 FreePBX\Console\Command\Moduleadmin->execute() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:953
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:248
 Symfony\Component\Console\Application->doRun() at /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /var/lib/asterisk/bin/fwconsole:136
 
ma [-f|--force] [-d|--debug] [--edge] [--stable] [--color] [--skipchown] [-e|--autoenable] [--skipdisabled] [--snapshot SNAPSHOT] [--format FORMAT] [-R|--repo REPO] [-t|--tag TAG] [--skipbreakingcheck [SKIPBREAKINGCHECK]] [--sendemail] [--onlystdout] [--] [<args>]...
 
All upgrades completed successfully!
Updating Hooks...Done
Resetting temporarily repository state

       

       

       

       

       

       

       

       

       

       

       

       

       

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                tm1000 Andrew Nagy
                Reporter:
                dolesec Chris Dolese
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  NextupJiraPlusStatus

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