<div class="gmail_quote">On Thu, Jun 24, 2010 at 2:42 AM, Rob Coward <span dir="ltr"><<a href="mailto:rob@jive-videos.net">rob@jive-videos.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<p>I'm just about to start experimenting with realtime queues, so can't offer anything from my own experience, but what happens if instead of updating the existing row, you delete it and insert a new one for the new user ?</p>
<p>ie. DELETE FROM queue_member_table WHERE id=1;</p>
<p>INSERT INTO queue_member_table (membername,queue_name,interface,penalty,paused) VALUES ('OtherUser','in_pruebas','SIP/1336','1','0');</p>
<p></p></blockquote><div><br></div><div>Hi, the result of delete or update is the same if I only change the membername field :(....</div><div><br></div><div>Asterisk CLI:</div><div><br></div><div><div>*CLI> queue show in_pruebas</div>
<div>in_pruebas has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0% within 0s</div><div> Members: </div><div> xxxx (SIP/1336) with penalty 1 (realtime) (Not in use) has taken no calls yet</div>
<div> No Callers</div></div><div><br></div><div>SQL:</div><div><div>mysql> select * from queue_member_table where queue_name = 'in_pruebas';</div><div>+------+------------+------------+-----------+---------+--------+</div>
<div>| id | membername | queue_name | interface | penalty | paused |</div><div>+------+------------+------------+-----------+---------+--------+</div><div>| 4528 | xxxx | in_pruebas | SIP/1336 | 1 | 0 |</div>
<div>+------+------------+------------+-----------+---------+--------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div>mysql> delete from queue_member_table where id = '4528';</div><div>Query OK, 1 row affected (0.00 sec)</div>
<div><br></div><div>mysql> select * from queue_member_table where queue_name = 'in_pruebas';</div><div>Empty set (0.00 sec)</div><div><br></div><div>mysql> insert into queue_member_table (membername,queue_name,interface,penalty,paused) VALUES ('chassoul','in_pruebas','SIP/1336','1','0');</div>
<div>Query OK, 1 row affected (0.00 sec)</div><div><br></div><div>mysql> select * from queue_member_table where queue_name = 'in_pruebas';</div><div>+------+------------+------------+-----------+---------+--------+</div>
<div>| id | membername | queue_name | interface | penalty | paused |</div><div>+------+------------+------------+-----------+---------+--------+</div><div>| 7261 | chassoul | in_pruebas | SIP/1336 | 1 | 0 |</div>
<div>+------+------------+------------+-----------+---------+--------+</div><div>1 row in set (0.00 sec)</div></div><div><br></div><div>Asterisk CLI:</div><div><br></div><div><div>*CLI> queue show in_pruebas</div><div>
in_pruebas has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0% within 0s</div><div> Members: </div><div> xxxx (SIP/1336) with penalty 1 (realtime) (Not in use) has taken no calls yet</div>
<div> No Callers</div></div><div><br></div><div><div>as you can see the problem is the same, I really don't know why or what to do with this :( please help!</div></div><div><br></div><div><br></div><div><br></div></div>