[asterisk-bugs] [Asterisk 0016893]: [patch] Realtime queue does not re-read announce variable from mysql after first use

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16893 
====================================================================== 
Reported By:                haakon
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16893
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Target Version:             1.6.2.15
Asterisk Version:           SVN 
JIRA:                       SWP-964 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2010-02-24 07:39 CST
Last Modified:              2010-09-17 16:08 CDT
====================================================================== 
Summary:                    [patch] Realtime queue does not re-read announce
variable from mysql after first use
Description: 
I am using realtime queues extensively with * 1.6.1.

Everything works great. Asterisk reads new values from the queue table
each time a user enters the queue.
Except from one thing: announcements. The "announce" variable from the
queue table, doesn't seem to be read more than once, if it has already
found a value.

Example:
I create a queue in the queue table, and add announce = "my_audio_file"
Then I call in, and the agent gets the audio file played correctly before
they are set up.

Then I set the announce field to NULL, or empty it with a empty string.
Now if i call in, the agent still gets the audio file set up earlier.

I even tried changing the ID of the queue entry in mysql (because i know
the queue_members table require this).
But it still reads the "ghost" value of announce.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0012445 Autofill does not work from general sec...
has duplicate       0017918 No announce doesn't get reloaded in que...
====================================================================== 

---------------------------------------------------------------------- 
 (0127104) svnbot (reporter) - 2010-09-17 16:08
 https://issues.asterisk.org/view.php?id=16893#c127104 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 287388

_U  branches/1.8/
U   branches/1.8/apps/app_queue.c

------------------------------------------------------------------------
r287388 | tilghman | 2010-09-17 16:08:55 -0500 (Fri, 17 Sep 2010) | 21
lines

Merged revisions 287387 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/branches/1.6.2

................
  r287387 | tilghman | 2010-09-17 16:08:00 -0500 (Fri, 17 Sep 2010) | 14
lines
  
  Merged revisions 287386 via svnmerge from 
  https://origsvn.digium.com/svn/asterisk/branches/1.4
  
  ........
    r287386 | tilghman | 2010-09-17 16:06:03 -0500 (Fri, 17 Sep 2010) | 7
lines
    
    Blank columns should get set on reload, not ignored.
    
    (closes issue https://issues.asterisk.org/view.php?id=16893)
     Reported by: haakon
     Patches: 
           20100818__issue16893.diff.txt uploaded by tilghman (license 14)
  ........
................

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=287388 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-09-17 16:08 svnbot         Checkin                                      
2010-09-17 16:08 svnbot         Note Added: 0127104                          
======================================================================