Uploaded image for project: 'ASTPP Community'
  1. ASTPP Community
  2. ASTPPCOM-212

Database Error when trying to save origination rate

    XMLWordPrintable

    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.

        Attachments

          Activity

            People

            Assignee:
            samir.doshi Samir Doshi
            Reporter:
            dedayoa dedayoa
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 2.5h
                2.5h