[asterisk-bugs] [JIRA] (ASTERISK-23351) realtime sip peers update fails
jmls (JIRA)
noreply at issues.asterisk.org
Sun Feb 23 11:08:03 CST 2014
jmls created ASTERISK-23351:
-------------------------------
Summary: realtime sip peers update fails
Key: ASTERISK-23351
URL: https://issues.asterisk.org/jira/browse/ASTERISK-23351
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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the asterisk-bugs
mailing list