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

PDOException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'flags' cannot be null

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 15.0.12.79
    • Fix Version/s: 15, 16
    • Component/s: WebRTC Phone
    • Labels:
      None
    • ToDo:
    • Distro:
      FreePBX Distro
    • Module Fix Version:

      Description

      Error in process to update WebRTC Phone from version 15.0.10.2 to version 15.0.10.4

      PDOException thrown with message "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'flags' cannot be null"

      Stacktrace:
      #8 PDOException in /var/www/html/admin/modules/core/functions.inc/drivers/Sip.class.php:154
      #7 PDOStatement:execute in /var/www/html/admin/modules/core/functions.inc/drivers/Sip.class.php:154
      #6 FreePBX\modules\Core\Drivers\Sip:addDevice in /var/www/html/admin/modules/core/Core.class.php:1549
      #5 FreePBX\modules\Core:addDevice in /var/www/html/admin/modules/webrtc/Webrtc.class.php:438
      #4 FreePBX\modules\Webrtc:createDevice in /var/www/html/admin/modules/webrtc/Webrtc.class.php:81
      #3 FreePBX\modules\Webrtc:install in /var/www/html/admin/libraries/modulefunctions.class.php:2562
      #2 module_functions:_runscripts in /var/www/html/admin/libraries/modulefunctions.class.php:2035
      #1 module_functions:install in /var/www/html/admin/page.modules.php:288
      #0 include in /var/www/html/admin/config.php:477

      Detailed info

      
       #4 FreePBX\modules\Webrtc:createDevice in /var/www/html/admin/modules/webrtc/Webrtc.class.php:81
      $this->createDevice($client['user'],$client['certid'],$prefix,$module);
      Arguments:
      1: "6000"
      2: null
      3: ""
      4: "UCP"
      
      
      #5 FreePBX\modules\Core:addDevice in /var/www/html/admin/modules/webrtc/Webrtc.class.php:438
      $this->FreePBX->Core->addDevice($id,'sip',$settings);
       Arguments
      1: "996000"
      2: "sip"
      3: array:40 { //show only the array records that do not have the flag property
        "devicetype" => array:1 [▼
          "value" => "fixed"
        ]
       "user" => array:1 [▼
          "value" => "6000"
        ]
       "description" => array:1 [▼
          "value" => "WebRTC Javier Pastor"
        ]
        "emergency_cid" => array:1 [▼
          "value" => ""
        ]
      "webrtc" => array:1 [▼
          "value" => "yes"
        ]
      }
      
      
      #6 FreePBX\modules\Core\Drivers\Sip:addDevice in /var/www/html/admin/modules/core/Core.class.php:1549
      return $this->drivers[$tech]->addDevice($id, $settings);
      Arguments:
      1: 996000"
      2: array:36 { //show only the array records that do not have the flag property
        "webrtc" => array:1 [▼
          "value" => "yes"
        ]
      }
      
      
      #7 PDOStatement:execute in /var/www/html/admin/modules/core/functions.inc/drivers/Sip.class.php:154
      $sth->execute(array($id,$key,$setting['value'],$setting['flag']));
      Arguments:
      1: array:4 [▼
        0 => "996000"
        1 => "webrtc"
        2 => "yes"
        3 => null
      ]
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  vsc55 VSC55
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    NextupJiraPlusStatus

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