[asterisk-bugs] [JIRA] (ASTERISK-23473) [patch]Updating realtime sippeers using res_config_pgsql backend fails when 'port' column is null

[Rusty Newton (JIRA)]

Rusty Newton created ASTERISK-23473:
---------------------------------------

             Summary: [patch]Updating realtime sippeers using res_config_pgsql backend fails when 'port' column is null
                 Key: ASTERISK-23473
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23473
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Resources/res_config_pgsql
    Affects Versions: 12.0.0
         Environment: debian on raspberry pi
            Reporter: jmls
            Severity: Minor


when using postgres with sip realtime, an update fails when a port number is '' . The actual error is below:

[Feb 23 11:37:47] ERROR[32292] res_config_pgsql.c: PostgreSQL RealTime: Query Failed: UPDATE sippeers SET fullcontact = '', lastms = '0', useragent = '', regserver = '', regseconds = '0', port = '', ipaddr = '' WHERE name = '<name>'
[Feb 23 11:37:47] ERROR[32292] res_config_pgsql.c: PostgreSQL RealTime: Query Failed because: ERROR:  invalid input syntax for integer: ""
LINE 1: ...nt = '', regserver = '', regseconds = '0', port = '', ipaddr...
                                                             ^
 (PGRES_FATAL_ERROR)






--
This message was sent by Atlassian JIRA
(v6.2#6252)