[asterisk-bugs] [Asterisk 0016536]: Updating field in realtime queue table does not take effect

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16536 
====================================================================== 
Reported By:                urosh
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16536
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     acknowledged
Asterisk Version:           Older 1.6.1 - please test a newer version 
JIRA:                       SWP-613 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-01-03 19:34 CST
Last Modified:              2010-01-05 13:45 CST
====================================================================== 
Summary:                    Updating field in realtime queue table does not take
effect
Description: 
Hi.
I noticed bug with realtime queue. The problem is when I change interface
from example(SIP/218 to SIP/219) asterisk still shows member SIP/218 as in
that queue. The only posible workaround is to change uniqueid. Then it
registers the change.
Here is my table from mysql.
CREATE TABLE  `voip`.`conf_queue_member` (
  `uniqueid` int(11) NOT NULL auto_increment,
  `queue_name` varchar(200) default NULL,
  `membername` varchar(120) default NULL,
  `interface` varchar(100) default NULL,
  `penalty` int(11) default '0',
  `paused` int(11) default '0',
  `parent_num` varchar(100) default NULL,
  PRIMARY KEY  (`uniqueid`),
  KEY `conf_queue_member_queue_name` (`queue_name`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-05 13:45 lmadsen        Summary                  Realtime queue =>
Updating field in realtime queue table does not take effect
2010-01-05 13:45 lmadsen        Description Updated                          
======================================================================