OV500 icon indicating copy to clipboard operation
OV500 copied to clipboard

SQL error in Customer call rate

Open TayyabTalha opened this issue 4 years ago • 2 comments

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

TayyabTalha avatar Jun 21 '20 08:06 TayyabTalha

please use the 1.0.1 branch

openvoips avatar Jun 21 '20 11:06 openvoips

Working Fine

TayyabTalha avatar Jun 23 '20 16:06 TayyabTalha