Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Sat Oct 20, 2018 12:44 am
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Unable to add new DID
PostPosted: Wed Sep 14, 2016 2:46 am 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
[a2billing 2.2.0, Debian 8, asterisk 13]

Trying to add inbound DID through web GUI. But gives me error meaasge: "Your new did hasn't been inserted."

Used php quick profiler as suggested by Joe and file the following error:

ERROR 1054 (42S22): Unknown column 'connection_charge' in 'field list'

The happens when the following sql is attempted:
INSERT INTO cc_did (did, billingtype, startingdate, expirationdate, id_cc_country, activated, fixrate, connection_charge, selling_rate, aleg_carrier_connect_charge, aleg_carrier_cost_min, aleg_retail_connect_charge, aleg_retail_cost_min, aleg_carrier_connect_charge_offp, aleg_carrier_cost_min_offp, aleg_retail_connect_charge_offp, aleg_retail_cost_min_offp) values ('908036665640', '0', '2016-09-13 22:42:18', '2026-09-13 22:42:18', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

I do not see the column name "connection_charge" in my mysql table cc_did

What gives? Many thanks for any suggestions


Top
 Profile  
 
 Post subject: Re: Unable to add new DID
PostPosted: Wed Sep 14, 2016 11:31 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

Looks like you did not apply the updates correctly contained in UPDATE-a2billing-v1.4.0-to-v1.4.1.sql

Joe


Top
 Profile  
 
 Post subject: Re: Unable to add new DID
PostPosted: Sat Oct 01, 2016 8:42 pm 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
Thanks Joe.

It was caused bythe same issue with mysql 5.7

I remove 'STRICT_TRANS_TABLES' – this allows insertion of rate and customers via web gui - this solved the problem.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Hosted Voice Broadcast


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:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group