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
|