User is deleted after deteting the DID group

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

Hi,

I have following bug: When I delete a DID group, all users are deleted that are assigned to this group.

Does anyone else have this? How can this be fixed?

And theres another bug I cant figure out. On the user interface a DID group is shown that I already deleted. How is this possible?

middletn · **Posted:** Fri Mar 14, 2008 9:40 pm

Sadly the DID setup on A2B is pretty awefull if not brain dead. These issues should be resolved in 1.4

regards

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

can somebody help me to fix this bug?
The DID-s isnt appear on the user interface.

stavros · **Posted:** Wed Mar 19, 2008 11:59 am

Can you please describe exactly how to reproduce it.

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

In the admin interface I create a DID group, then I create a DID there. On the user interface the DID doesnt appear.
First this worked but after I deleted the DID groups and DIDs once it doesnt work anymore.

stavros · **Posted:** Thu Mar 20, 2008 5:00 pm

And you've updated the customer to be a member of the new DID group?

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

stavros wrote:

And you've updated the customer to be a member of the new DID group?

Yes.

stavros · **Posted:** Fri Mar 21, 2008 7:35 pm

I see what's going on. The DIDs aren't marked as free when the DID group is deleted.

The simplest way to recover from this is to use your SQL server directly to update the did_use table to point at the new DID group.
In this example the deleted DID group was id 1, and the new replacement is id 6:

Code:

psql=> UPDATE cc_did SET id_cc_didgroup='6' WHERE id_cc_didgroup = '1';
UPDATE 19

The warning you receive about 'dependent records' when deleting the DID group is your clue that there may well be consequences if you confirm the deletion. You should ideally tidy up your DIDs and deallocate them from customers before removing the DID group.

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

Before you wrote this the did_use table was empty, I deleted all rows to be sure its not disturbing. Then I created a DID group and a DID but in the user interface I couldnt select this DID.

The tables look like this:
cc_did
id:1 id_cc_didgroup:1

cc_didgroup:
id:1 iduser:0

stavros · **Posted:** Fri Mar 21, 2008 11:21 pm

That could well be your problem. cc_did_use keeps tracks of which DIDs are available (free).

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

So this means when I create a DID there should be created a record in the did_use table?
What should be in the row?

stavros · **Posted:** Fri Mar 21, 2008 11:35 pm

The easy way to find out is to create a new DID and have a look.

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

Well I created a new DID and theres a new row in the did_use table but it is still not available in the user interface. How come?

stavros · **Posted:** Fri Mar 21, 2008 11:46 pm

Is the new DID a unique number, rather than a clone of an existing DID?
If so we're back to the DID not being in the same DID group as the customer. You'll may have to log out of the customer UI and back in after changing the customer's DID group.

mr001 · **Joined:** Fri Nov 16, 2007 12:28 pm **Posts:** 74

Ok I tried now with logout and login again and it works. But I have to assign the DID group to the user manually. But its still a bit strange, because I can choose 2 DIDs but in the did_use table there is only 1 record.

provided by Star2Billing S.L.

User is deleted after deteting the DID group

Who is online