[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:                     ready for testing
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:              
====================================================================== 
Date Submitted:             2010-02-24 07:39 CST
Last Modified:              2010-09-17 16:06 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...
====================================================================== 

---------------------------------------------------------------------- 
 (0127102) svnbot (reporter) - 2010-09-17 16:06
 https://issues.asterisk.org/view.php?id=16893#c127102 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 287386

U   branches/1.4/apps/app_queue.c

------------------------------------------------------------------------
r287386 | tilghman | 2010-09-17 16:06:04 -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=287386 

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