Cannot Delete Extention

Reporting an Issue
1

When Deleting extention show thats the extention is assocated with

  • This item is being used as destination by the Blacklist module
  • This item is being used as destination by the Inbound Routes module

but in the reality the extention is not associated with any modules . please help
image

2

Same here on one of my servers, which is telling me the item is associated with a time condition.

3

Which version of VitalPBX is this?

4

VitalPBX Enterprise 3.2.3-6
Asterisk 18.12.1-1

5

What is the extension number?

What is the output of:

mysql -A ombutel
select * from ombu_blacklist;
6

±-------------±------------±------------±---------------±--------±----------+
| blacklist_id | number | description | destination_id | enabled | tenant_id |
±-------------±------------±------------±---------------±--------±----------+
| 16 | XXXXXXXXXX | Tefl | 99 | yes | 1 |
| 17 | XXXXXXXXXX | Child | 102 | yes | 1 |
| 21 | XXXXXXXXXX| Aboelnile | 137 | yes | 1 |
±-------------±------------±------------±---------------±--------±----------+

7

With the query below you can get a general view of your destinations:

mysql -uroot -A ombutel

select d.id, m.name as used_by, m2.name as dest, d.`index` as dest_id from ombu_destinations d
 inner join ombu_modules m on (d.module_id = m.module_id)
 inner join ombu_destinations_category odc on (d.category_id = odc.id)
 inner join ombu_modules m2 on (odc.module_id = m2.module_id);
9

Showing rows 0 - 94 (95 total, Query took 0.0018 seconds.)

select d.id, m.name as used_by, m2.name as dest, d.index as dest_id from ombu_destinations d
inner join ombu_modules m on (d.module_id = m.module_id)
inner join ombu_destinations_category odc on (d.category_id = odc.id)
inner join ombu_modules m2 on (odc.module_id = m2.module_id);

id used_by dest dest_id
22 blacklist extensions 21
43 blacklist extensions 21
63 inbound_route extensions 56
67 inbound_route extensions 21
69 blacklist extensions 21
126 dynamic_destinations extensions 82
128 dynamic_destinations extensions 82
60 blacklist custom_dest 1
62 blacklist custom_dest 1
65 custom_app custom_dest 1
73 blacklist custom_dest 1
6 ivr queues 9
7 ivr queues 9
8 ivr queues 1
9 ivr queues 2
10 ivr queues 3
54 ivr queues 9
74 blacklist queues 1
77 ivr queues 9
106 ivr queues 9
107 ivr queues 9
109 ivr queues 16
110 ivr queues 17
112 ivr queues 9
70 inbound_route trunk_group 1
129 blacklist disa 1
130 blacklist disa 1
134 blacklist disa 1
137 blacklist disa 2
11 time_conditions ivr 4
49 ivr ivr 1
50 ivr ivr 1
51 ivr ivr 1
52 ivr ivr 3
76 ivr ivr 1
79 blacklist ivr 1
94 custom_app ivr 1
108 ivr ivr 1
111 ivr ivr 4
12 time_conditions preannoun 1
14 custom_app preannoun 1
15 custom_app preannoun 3
99 blacklist preannoun 1
101 custom_app preannoun 6
102 blacklist preannoun 1
2 inbound_route time_conditions 1
16 inbound_route time_conditions 1
47 custom_app time_conditions 1
1 parking terminate_call 1
3 queues terminate_call 1
4 queues terminate_call 1
5 queues terminate_call 1
13 preannoun terminate_call 1
18 blacklist terminate_call 3
20 blacklist terminate_call 4
21 blacklist terminate_call 5
23 blacklist terminate_call 2
27 preannoun terminate_call 4
28 blacklist terminate_call 4
41 custom_app terminate_call 4
44 preannoun terminate_call 1
46 ring_group terminate_call 1
48 preannoun terminate_call 1
53 ring_group terminate_call 1
78 queues terminate_call 1
84 queues terminate_call 1
85 queues terminate_call 1
88 queues terminate_call 1
89 queues terminate_call 1
90 queues terminate_call 1
91 queues terminate_call 1
92 queues terminate_call 1
95 preannoun terminate_call 1
100 preannoun terminate_call 1
104 queues terminate_call 1
105 queues terminate_call 1
114 queues terminate_call 1
115 queues terminate_call 1
116 queues terminate_call 1
117 queues terminate_call 1
118 queues terminate_call 1
119 queues terminate_call 1
120 queues terminate_call 1
121 queues terminate_call 1
125 dynamic_destinations terminate_call 1
131 queues terminate_call 1
132 queues terminate_call 1
133 queues terminate_call 1
135 queues terminate_call 1
138 custom_contexts terminate_call 1
139 queues terminate_call 1
140 queues terminate_call 1
141 queues terminate_call 1
142 queues terminate_call 1
39 extensions custom_numbers XXXXXXX

10

This is mine from a small server. Did you find a fix for this?

id | used_by | dest | dest_id |
±—±----------------±----------------±--------+
| 1 | parking | vm_unavailable | 9 |
| 2 | inbound_route | extensions | 14 |
| 7 | time_conditions | extensions | 5 |
| 8 | time_conditions | vm_unavailable | 5 |
| 13 | inbound_route | time_conditions | 4 |
| 19 | ring_group | vm_unavailable | 9 |
| 23 | ivr | ivr | 1 |
| 24 | ivr | vm_unavailable | 9 |
| 25 | ivr | extensions | 15 |
| 26 | ivr | extensions | 2 |
| 27 | ivr | extensions | 7 |
| 28 | ivr | extensions | 12 |
| 29 | ivr | extensions | 16 |
| 30 | ivr | extensions | 3 |
| 31 | ivr | extensions | 13 |
| 32 | ivr | extensions | 14 |
| 33 | ivr | vm_unavailable | 9 |
| 37 | inbound_route | time_conditions | 4 |
| 38 | time_conditions | ring_group | 8 |
| 39 | time_conditions | vm_unavailable | 15