Extension in use but not in gui

General Help
1

I have an extension stuck in the DB. It’s not in the gui, but when I try to add extension 138 for example, it says it’s in use. I ran the following and still have the same result

USE asterisk;
DELETE FROM sip WHERE id = ‘xxx’;
DELETE FROM users WHERE extension = ‘xxx’;
DELETE FROM devices WHERE id = ‘xxx’;

2

Not sure which version of FreePBX you use, but if you hover over that icon, it should tell you where it’s in use.
Might be it’s a Queue, Ring Group or Custom Extension.

3

Have you done SELECT * FROM sip WHERE id='138' and see how many, if any, results are returned?

You could also do: SELECT DISTINCT id FROM sip and that will kick back all the unique ids, which in this the case of this table is the extension number.

4

some how it ended up clearing out. Thanks

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.