[ASTPPCOM-222] Errors on uploading rates Created: 11/Sep/17  Updated: 01/Apr/21  Resolved: 01/Apr/21

Status: Done
Project: ASTPP Community
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature
Reporter: clive18 Assignee: Samir Doshi
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Hi.
I am having errors uploading rates.
in line 351 of rates_model.php there is a reference to "old_cost" which seems to find its way into the database query, and this is where it fails.

The query generated is:
INSERT INTO routes (pattern, comment, connectcost, includedseconds, cost, init_inc, inc, precedence, last_modified_date, pricelist_id, trunk_id, reseller_id, creation_date) VALUES
('^467677.*','Sweden Mobile Telia','0','0','0','60','60','','2017-09-11 07:32:17','4','1','0','2017-09-11 07:32:17') ON DUPLICATE KEY UPDATE old_cost = IF(VALUES(cost) != cost,cost,old_cost), effective_date = IF(VALUES(cost) > cost,'',(IF(VALUES(cost) < cost,'',effective_date))), comment=VALUES(comment), connectcost=VALUES(connectcost), includedseconds=VALUES(includedseconds), cost=VALUES(cost), init_inc=VALUES(init_inc), inc=VALUES(inc), last_modified_date=VALUES(last_modified_date), status=IF(VALUES(cost) = '-1','1','0')

Any feedback would be appreciated.



 Comments   
Comment by clive18 [ 11/Sep/17 ]

Hi again.

This issue was fixed.

Many thanks

Generated at Sat Feb 10 07:15:14 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.