[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=214345#comment-214345 ] 

Denis edited comment on ASTERISK-23177 at 1/23/14 2:01 PM:
-----------------------------------------------------------

i`ve delete most of columns and for others set big types, also set debug to 5, error the same, printscreens attached.
Definitely error occurs when sql try to update field "fullcontact" but i cant delete this field because occurs other error, what data was send to this field i have no idea, debug 5 also does not show such info.
                
      was (Author: den159):
    i`ve delete most of columns and for others set big types, also set debug to 5, error the same, printscreens attached.
Definitely error occurs when sql try to update field "fullcontact" but i cat delete this field because occurs other error, what data was send to this field i have no idea, debug 5 also does not show such info.
                  
> 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: 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