provided by Star2Billing S.L.

Hello,
I'm novice in asterisk & a2billing.
But i have a problem with rates adding.
After filling all necessary forms and pressing the button "CONFIRM DATA", the message warning appears:

Trunks, Call Plans, Rate Cards are added normally...

i am getting this same issue. also i am unable to generate multiple customers, can you generate them ?

yes, i can, i tried to generate 10 customers and everything went OK

i think the problem is in permissions or owners
i tried to import rates from the file and after that they appears in rates-list, but i can't edit any rate or delete it.

Can anyone tell, what files a2b uses to store rates, or maybe it stores them in mysql base, but i don't see a table named "rates" or something similar in my a2b database in MySQL.

which version of mysql are you using ?

mysql-5.0.45-7.el5.i386
i have a trixbox installed

i have exactly the same version

mysql-5.0.45-7.el5
mysql-devel-5.0.45-7.el5
php-mysql-5.2.6-jason.1
mysql-5.0.45-7.el5
mysql-server-5.0.45-7.el5
mysql-devel-5.0.45-7.el5


you can find the rates in cc_ratecard table


cheers

Same bug appeared after svn check
Checkout happened today, revision 1995

Btw
do we have any SVN browser, avaialble online ?

have u tried tortoise ?

I already found that we have web based source browser

swast, have you found out a solution for the add rate & generate customers problem ?

Currently i am checking this very nice code

On my wholesale system i have a2b 1.4 of Apr, 26. It seems to work - i can give you a copy
Contact me skype:tremez

Hello
I have the same problem with "add rate" in Admin UI.
The debug message appears to be a syntax error (mysql 5.0.77) :

mysql> INSERT INTO cc_ratecard LEFT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffplan = cc_ratecard.idtariffplan (idtariffplan, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock, startdate, stopdate, starttime, endtime, id_trunk, id_outbound_cidgroup) values ('1', '355', '355', '0.05', '30', '1', '0.09', '30', '1', '2009-05-11 01:17:39', '2019-05-11 01:17:39', '0', '10079', '-1', '-1');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffplan = cc_ratecard.' at line 1


Same kind of problem occurs with the sql query when editing a rate :
mysql> SELECT idtariffplan, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement,rateinitial, initblock, billingblock, connectcharge, disconnectcharge,disconnectcharge_after, minimal_cost, startdate, stopdate, starttime, endtime, rounding_calltime, rounding_threshold, additional_block_charge, additional_block_charge_time,additional_grace, id_trunk, id_outbound_cidgroup, tag FROM cc_ratecard LEFT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffplan = cc_ratecard.idtariffplan WHERE id='5' LIMIT 0,1;
ERROR 1052 (23000): Column 'idtariffplan' in field list is ambiguous

Revision 1957 have working code
Lets wait, when guys will ix it

fixed in rev 1999 for "Add Rate"

the "Edit Rate" still bugs with this new error :

mysql> SELECT cc_ratecard.idtariffplan, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock, connectcharge, disconnectcharge,disconnectcharge_after, minimal_cost, startdate, stopdate, starttime, endtime, rounding_calltime, rounding_threshold, additional_block_charge, additional_block_charge_time,additional_grace, id_trunk, id_outbound_cidgroup2, tag FROM cc_ratecard WHERE id='6' LIMIT 0,1;
ERROR 1054 (42S22): Unknown column 'id_outbound_cidgroup2' in 'field list'

commited too fast ?

I just made few modifications in order to fix this.
rev 2000

Yours,
/Areski