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

[Asterisk Bug Tracker]

The following issue has been RESOLVED. 
====================================================================== 
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:                     resolved
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: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...
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-09-17 16:06 svnbot         Status                   ready for testing =>
assigned
2010-09-17 16:06 svnbot         Status                   assigned => resolved
2010-09-17 16:06 svnbot         Resolution               open => fixed       
======================================================================