[asterisk-bugs] [JIRA] (ASTERISK-24772) ODBC error in realtime sippeers when device unregisters under MariaDB

[Richard Miller (JIRA)]

Richard Miller created ASTERISK-24772:
-----------------------------------------

             Summary: ODBC error in realtime sippeers when device unregisters under MariaDB
                 Key: ASTERISK-24772
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24772
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Channels/chan_sip/DatabaseSupport
    Affects Versions: 11.16.0
         Environment: CentOS 6.4, MariaDB 10.0.x
            Reporter: Richard Miller
            Severity: Minor


When a device unregisters, the query to clear the port number in sippeers uses an empty string in the function destroy_association.  Most database engines will coerce an empty string value to a zero value.  MariaDB does not do this.

The log shows

WARNING[17024]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.5-10.0.16-MariaDB]Incorrect integer value: '' for column 'port' at row 1 (108)
WARNING[17024]: res_odbc.c:658 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to ...




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