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

[Joshua Colp (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-27515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp updated ASTERISK-27515:
-----------------------------------

    Assignee: Sunny  (was: Unassigned)
      Status: Waiting for Feedback  (was: Triage)

I just opened the mysql_config.sql file from 13.18.4 and there is indeed an alter:

{noformat}
-- Running upgrade 164abbd708c -> f3d1c5d38b56

ALTER TABLE ps_contacts ADD COLUMN prune_on_boot ENUM('yes','no');

UPDATE alembic_version SET version_num='f3d1c5d38b56' WHERE alembic_version.version_num = '164abbd708c';
{noformat}

Are you sure you copied the entire thing? Did the comments cause it to skip stuff? Did it error out for some reason?

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