[Freeswitch-users] Issue with database updates
rick at magicmail.mooo.com
Sun Oct 8 18:13:26 UTC 2017
I had resorted to updating the table directly through SQL as FS doesn't appear to dynamically update the table if I use uuid_setvar :/
> On 8 Oct 2017, at 19:05, Vallimamod Abdullah <vma at vallimamod.org> wrote:
> I am not sure how you are updating these columns but if you are doing it directly through sql, I don't think it's the correct way.
> To set or update a value on a "presence data" column, you have to define or update a channel variable with the same name as the column. If there is no variable defined, the corresponding column will be set to NULL on the state change.
> Hope this helps.
> Best Regards,
> Vallimamod Abdullah
> SIP Solutions
> vma at sipsolutions.fr <mailto:vma at sipsolutions.fr>
> tel: +33 6 62 60 68 97
>> On 8 Oct 2017, at 16:50, Rick Jarvis <rick at magicmail.mooo.com <mailto:rick at magicmail.mooo.com>> wrote:
>> Is there any reason why FS iterates through all the fields in the channels table, when it updates a field? I’ve created some custom columns (as per https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols <https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols>) but the values I’m writing to my new columns are being overwritten when FS changes the channel state - it appears from the logs that this is due to FS reading the values from the table, and then setting every column (including my custom fields) when it then updates … to me this is counter-intuitive as far as SQL goes!?
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> Official FreeSWITCH Sites
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the FreeSWITCH-users