SQL error in Customer call rate

openvoips / OV500

OpenSource Freeswitch & Kamailio Billing, rating and Routing Software

http://ov500.openvoips.org

GNU Affero General Public License v3.0

100 stars 54 forks source link

SQL error in Customer call rate #22

Open TayyabTalha opened 4 years ago

TayyabTalha commented 4 years ago

Error Number: 42S22/1054

Unknown column 'id' in 'order clause'

SELECT SQL_CALC_FOUND_ROWS *, 'customer_rates' as rate_table_name, (SELECT ratecard_for FROM ratecard WHERE ratecard.ratecard_id = customer_rates.ratecard_id) AS ratecard_for FROM customer_rates WHERE ratecard_id IN (SELECT ratecard_id FROM tariff_ratecard_map WHERE tariff_id = 'USA4635') AND prefix = '1' ORDER BY id DESC LIMIT 1000

Filename: models/Rate_mod.php

Line Number: 324

openvoips commented 4 years ago

please use the 1.0.1 branch

TayyabTalha commented 4 years ago

Working Fine