Ticket #2528 (closed Bugs: fixed)

Opened 6 years ago

Last modified 6 years ago

Queues not updating from MySQL database

Reported by: ninthclowd Assigned to:
Priority: major Milestone: 2.4
Component: Queues Version: 2.3.1
Keywords: extensions_additional.conf Cc:
Confirmation: Confirmed Distro:
Backend Engine: Asterisk 1.4.x Distro Ver:
Backend Ver: SVN Revision (if applicable):

Description

Changes to a queue's fail over destination does not get updated in extensions_additional.conf. It does get updated in MySQL and repopulated in Free PBX/

I noticed this when I first created a queue using a custom fail over destination. It saved the custom destination to MySQL and therefore looked like it had took on the Free PBX page, but then when I looked in extensions_additional.conf Free PBX had written Goto(ext-queues,1,1) as the fail over destination for that queue. I did a search in MySQL for ext-queues,1,1 under extensions.args but there wasn't any entries pertinent to this queue.

Attachments

patch.diff (225 bytes) - added by ninthclowd on 12/19/07 18:35:51.
diff file for changes to modules/queues/functions.inc.php

Change History

(follow-up: ↓ 2 ) 12/04/07 18:27:42 changed by p_lindheimer

  • confirmation changed from Unreviewed to Need Feedback.

What version of Queues are you using?

(in reply to: ↑ 1 ) 12/04/07 18:42:21 changed by ninthclowd

Replying to p_lindheimer:

What version of Queues are you using?

Queues Version 2.2.13.4

12/18/07 16:01:33 changed by ninthclowd

I double checked everything and the MySQL database is correct in the extensions table and queues table. The problem is that it is not writing correctly to extensions_additional.conf. If this is low on your priority, could someone at least point me to the php page/function that writes the config files so I could do some debugging on my own?

12/19/07 18:22:44 changed by ninthclowd

HA!! I found the bug.

The problem is with the following line in the queues_get function in the functions.inc.php file of modules/queues 

$sql = "SELECT args FROM extensions WHERE extension = '".$account."' AND descr = 'jump'";

Should be: 

$sql = "SELECT args FROM extensions WHERE extension = '".$account."' AND descr = 'jump' AND context='ext-queues'";

I'm not a opensource developer so what do I have to do to get this committed?

12/19/07 18:35:51 changed by ninthclowd

  • attachment patch.diff added.

diff file for changes to modules/queues/functions.inc.php

12/19/07 19:20:00 changed by p_lindheimer

  • status changed from new to closed.
  • confirmation changed from Need Feedback to Confirmed.
  • resolution set to fixed.
  • milestone changed from Cut Line to 2.4.

r5546, r5547, r5548, r5549

you must have some left over stuff in your old extensions table for that to have occurred but you are right.