Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Aug 11, 2020 10:27 pm
Predictive Dialer

All times are UTC

Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Unknown and non-numeric Caller-ID
PostPosted: Sun Dec 03, 2006 12:57 pm 

Joined: Sun Dec 03, 2006 10:40 am
Posts: 10
I'm running asterisk2billing v1.2.3 on PostgreSQL-8.1

I noticed that (in case of Unknown and non-numeric Caller-ID) the query is somewhat like

INSERT .... (...src...) values (...,Unknown,...)

as src field is "text" it should be included within single quotes, so I suggest the following patch (after appliyng that patch everything is Ok with Unknown Caller-IDs):

available also at

--- trunk/A2Billing_AGI/libs_a2billing/Class.A2Billing.php.orig 2006-12-03 12:48:46.000000000 +0000
+++ trunk/A2Billing_AGI/libs_a2billing/Class.A2Billing.php 2006-12-03 12:50:01.000000000 +0000
@@ -937,7 +937,7 @@
$QUERY .= ", '$answeredtime', '".$inst_listdestination[4]."', '$dialstatus', now(), '0', '0', ".
- " '".$this->countrycode."', '".$this->subcode."', 'DID CALL', '0', '0', '0', '0', $this->CallerID, '3' )";
+ " '".$this->countrycode."', '".$this->subcode."', 'DID CALL', '0', '0', '0', '0', '$this->CallerID', '3' )";
if ($this->agiconfig['debug']>=1) $agi->verbose('line:'.__LINE__.' - '.$QUERY);
$this -> write_log("[DID CALL - LOG CC_CALL: SQL: $QUERY]");
$result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY, 0);

 Post subject:
PostPosted: Mon Dec 04, 2006 12:42 am 

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
That sounds like an important patch.
Thx, Areski

 Post subject: Similar problem with unknown callerID
PostPosted: Fri Dec 15, 2006 10:10 pm 

Joined: Tue Nov 21, 2006 7:01 pm
Posts: 19
Can you tell me what the symptoms were when you used a blank callerid, before applying the patch? I am having trouble when receiving a call where the callerid is blank, the system disconnects the caller immediately after they choose a language. I don't know if the SQL query executes before the hang up or not, but I don't see it in the logs. Have a look at my post on this matter and please comment if you can shed any additional light on it. ... =4091#4091



Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Predictive Dialer

All times are UTC

Who is online

Users browsing this forum: No registered users and 2 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group