Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-16128

Updating call groups from CSV can cause callees table to go out of range

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 14
    • Fix Version/s: 14
    • Component/s: Broadcast (Commercial)
    • Labels:
      None

      Description

      broadcast 14.0.1.5

      Probably affects 13, didn't test.

      When configuring the Broadcast module to update call groups from CSV, it appears that each time a CSV file is loaded, numbers are deleted and then re-added. This has the effect of auto incrementing the id column each time for each number. As the id column is set to mediumint(9), once the id column hits the 8M mark, table inserts fail. As we give control to the user to run updates at very short intervals (in seconds) and there is no limit to the size csv lists, its possible to reach this limit with normal usage.

      Need to modify the SQL query not to delete and re-add values that already exist and need to remain, or eliminate the auto-increment column if it doesn't serve a purpose.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jphilip Philip Joseph
                Reporter:
                lgaetz Lorne Gaetz
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:

                  NextupJiraPlusStatus

                  Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.