Details
-
Type:
New Feature
-
Status: Done
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: v3.5
-
Labels:None
Description
Hello,
I've saved origination rates in the past and have 100s of them setup infact. However, I tried to add a new rate this evening and nothing happened.
I discovered that the AJAX call to origination_rate_save/ was returning an E500 and the error is duplicated below.
`A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'net','0','0','0','10','1','1','','2017-07-15 19:51:40') ON DUPLICATE KEY UPDATE' at line 1
Insert into routes (pricelist_id,pattern,comment,status,connectcost,includedseconds,cost,init_inc,inc,trunk_id,creation_date) values('1','^0220.','NG T'net','0','0','0','10','1','1','','2017-07-15 19:51:40') ON DUPLICATE KEY UPDATE pricelist_id = '1',pattern = '^0220.',comment = 'NG T'net',status = '0',connectcost = '0',includedseconds = '0',cost = '10',init_inc = '1',inc = '1',trunk_id = '',creation_date = '2017-07-15 19:51:40'
Filename: /var/www/html/astpp/modules/rates/models/rates_model.php
Line Number: 355`
I have done an update 5 mins ago and it did not help.