[asterisk-bugs] [JIRA] (ASTERISK-23177) RealTime cant update sipbuddies table when registering or updating friend

[Denis (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-23177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=214350#comment-214350 ] 

Denis commented on ASTERISK-23177:
----------------------------------

excuse me, debug log attached this is error place:
[Jan 23 15:24:31] DEBUG[9004] res_config_mysql.c: MySQL RealTime: Connection okay.
[Jan 23 15:24:31] DEBUG[9004] res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE t_sippeus SET `ipaddr` = '192.168.1.25', `sip:101 at 192.168.1.25:5065;ob` = 'sip:101 at 192.168.1.25:5065^3Bob', `0` = '0', `PJSUA v2.1 win32-5.1/i386/msvc-15.0` = 'PJSUA v2.1 win32-5.1/i386/msvc-15.0', `101` = '101', `1390508971` = '1390508971', `5065` = '5065' WHERE `name` = '101'
[Jan 23 15:24:31] WARNING[9004] res_config_mysql.c: MySQL RealTime: Failed to update database: Unknown column 'sip:101 at 192.168.1.25:5065;ob' in 'field list'
                
> RealTime cant update sipbuddies table when registering or updating friend 
> --------------------------------------------------------------------------
>
>                 Key: ASTERISK-23177
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23177
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/res_config_mysql, PBX/pbx_realtime
>    Affects Versions: 12.0.0
>         Environment: Centos 6.5 on Oracle VirtualBox
>            Reporter: Denis
>            Assignee: Denis
>         Attachments: debug_log, files2.zip, files.zip
>
>
> {noformat}
> Connected to Asterisk 12.0.0 currently running on localhost (pid = 6257)
>   == Manager 'manager' logged on from 192.168.1.25
>     -- Registered SIP '101' at 192.168.1.25:5065
>        > Saved useragent "PJSUA v2.1 win32-5.1/i386/msvc-15.0" for peer 101
> [Jan 22 09:26:16] WARNING[6284]: res_config_mysql.c:631 update_mysql: MySQL RealTime: Failed to update database: Unknown column 'sip:101 at 192.168.1.25:5065;ob' in 'field list'
> {noformat}

--
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