[asterisk-bugs] [JIRA] (ASTERISK-27515) prune_on_boot field missing in ps_contact table

[Sunny (JIRA)]

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

Sunny commented on ASTERISK-27515:
----------------------------------

Hi Josh,

I had upgraded the Asterisk to 13.18.4 and had 2 files of mysql_config.sql and by mistake I used the old sql file, really sorry it was my mistake.

And in a new file alter command is there and it is perfect.

Thanks

> prune_on_boot field missing in ps_contact table 
> ------------------------------------------------
>
>                 Key: ASTERISK-27515
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27515
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_pjsip
>    Affects Versions: 13.18.4
>            Reporter: Sunny
>            Assignee: Sunny
>
> After upgrading to Asterisk 13.18.4, when somebody is trying to register ast box 13.18.4 is throwing warning
> res_config_odbc.c:120 custom_prepare: SQL Prepare failed! [INSERT INTO ps_contacts (id, via_addr, qualify_timeout, call_id, reg_server, prune_on_boot, path, endpoint, via_port, authenticate_qualify, uri, qualify_frequency, user_agent, expiration_time, outbound_proxy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
> Although I have updated the DB schema using the included the SQL files in the package and still prune_on_boot field missing (I am using mysql)
> So please alter the query for ps_contact table in 13.18.4 package



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