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

Add MOH Custom streaming fails with SQL error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Third Party Issue
    • Affects Version/s: 14
    • Fix Version/s: 13, 15
    • Component/s: Music On Hold
    • Labels:
      None
    • ToDo:
    • Asterisk Version:
      16.2.1
    • Distro Version:
      SID
    • Distro:
      Self Install Debian

      Description

      In a clean install of v14, when i try to add a custom MOH for streaming, it fails with an sql error, due to the default of the field in case.

      Maybe because of the insert in line 141 of Music.class.php

      $sql = "INSERT INTO music (`category`, `type`) VALUES (?,?)";

      Or the one in 326, i'm not sure, but maybe in line 326:

      $sql = "INSERT INTO music (`category`, `type`, `random`) VALUES (?,?,?)";

       

      Check the attached image.

      Let me know if you need any extra info to help on this, can't move forward with MOH creation.

      Thanks in advanced,

       

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                tm1000 Andrew Nagy
                Reporter:
                jasb jasb
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  NextupJiraPlusStatus

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