Hi,

I join to the mail a csv witch is an export from acc table. As you can see, there are two bye at the same time.

To correct it in SERWeb, I redesign the SQL request like this :

strip this in select : bye_i_uri ; bye_to_uri ; bye_fromtag ; bye_totag ; bye_from_uri ; bye_sip_from

I add a DISTINCT instruction. So I've got only one call instead of two, and in SERWEb code I comment the parts wich concerns this column (i.e. INVITE and BYE unpaired).

For the BYE unpaired, I understand that it was implement for determine who have hang out. I'm not interresting by this function.So I always put "n/a". Moreover, for INVITE unpaired, I think it's a very rare problem. To prevent it, I have been thinking to add "is not null" in a where clause for inv_callid column to don't have a result with INVITE unpaired.

Thanks for your support, I wait for your opinion.

Regards

Le vendredi 27 avril 2007 à 08:52 +0200, Karel Kozlik a écrit :

Hi, thanks for report. Could you please send me an example of acc table content with these double BYEs? I will look if I am able to fix it.

thanks, Karel

inge napsal(a):

...

No one have an idea on this problem ?

I've got two BYE's only when caller and callee hang out at the same time. It's not very penalising because of the rarety of the case, but it's obstructing.

Thanks for your support.

Le mercredi 25 avril 2007 à 09:33 +0200, inge a écrit :

...

Hi all,

I use SERWeb especially for call history. The core of this function is method.get_acc_entries.php. For some calls, I see that they are posted two times.

During my investigation I see that the problem come from SQL request in method.get_acc_entries.

In fact, it seems that when both calling and called party hang out in the same time, there are two BYE generated in acc table.

Maybe the bug have been already reported, but I don't see nothing about this. Anyone one have an idea to correct it ?

Thanks for your su

---

Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serweb-users mailing list Serweb-users@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serweb-users