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

IVR module - Exception error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Third Party Issue
    • Affects Version/s: 14.0.
    • Fix Version/s: 14
    • Labels:
      None
    • Sprint:
      Sprint 16!
    • ToDo:
    • Module Fix Version:

      Description

      Exception error if you left the field "Announcement" as "None" in IVR module
      (Version of IVR module: 14.0.9.4 Stable) and the field "Recording" as "None" in Announcement module (13.0.7.7)

      And the fied "Enable Random Play" - "No" in the module Music on Hold v.13.0.22.7 also causes Error and require to set it field to "Yes"

      IVR Module:

      
      Exception thrown with message "Array
      (
          [name] => IVR-91111-IN
          [alertinfo] => 
          [description] => INCOMING-91111
          [announcement] => None
          [directdial] => ext-local
          [invalid_loops] => 1
          [invalid_retry_recording] => 14
          [invalid_destination] => app-blackhole,hangup,1
          [invalid_recording] => 12
          [retvm] => 
          [timeout_time] => 7
          [timeout_recording] => 12
          [timeout_retry_recording] => default
          [timeout_destination] => app-blackhole,hangup,1
          [timeout_loops] => 0
          [timeout_append_announce] => 0
          [invalid_append_announce] => 0
          [timeout_ivr_ret] => 0
          [invalid_ivr_ret] => 0
          [rvolume] => 0
          [strict_dial_timeout] => 2
      )
       SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'None' for column `asterisk`.`ivr_details`.`announcement` at row 1::"
      
      Stacktrace:
      #4 Exception in /var/www/html/admin/libraries/utility.functions.php:207
      #3 die_freepbx in /var/www/html/admin/modules/ivr/functions.inc.php:463
      #2 ivr_save_details in /var/www/html/admin/modules/ivr/functions.inc.php:427
      #1 ivr_configprocess in /var/www/html/admin/libraries/components.class.php:469
      #0 component:processconfigpage in /var/www/html/admin/config.php:423
      

      Announcement module:

      
      Stacktrace:
      #4 Exception in /var/www/html/admin/libraries/utility.functions.php:207
      #3 die_freepbx in /var/www/html/admin/modules/ivr/functions.inc.php:463
      #2 ivr_save_details in /var/www/html/admin/modules/ivr/functions.inc.php:427
      #1 ivr_configprocess in /var/www/html/admin/libraries/components.class.php:469
      #0 component:processconfigpage in /var/www/html/admin/config.php:423
      
      
      Exception thrown with message "SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `asterisk`.`announcement`.`recording_id` at row 1INSERT INTO announcement (description, recording_id, allow_skip, post_dest, return_ivr, noanswer, repeat_msg) VALUES ('INSTRUCTION-TO-LEAVE-COUNTER-DATA', '', '0', 'ext-local,vms9999,1', '0', '0', '')::"
      
      Stacktrace:
      #5 Exception in /var/www/html/admin/libraries/utility.functions.php:207
      #4 die_freepbx in /var/www/html/admin/modules/announcement/functions.inc.php:169
      #3 announcement_add in /var/www/html/admin/modules/announcement/Announcement.class.php:133
      #2 FreePBX\modules\Announcement:doConfigPageInit in /var/www/html/admin/libraries/BMO/GuiHooks.class.php:290
      #1 FreePBX\GuiHooks:doBMOConfigPage in /var/www/html/admin/libraries/BMO/GuiHooks.class.php:252
      #0 FreePBX\GuiHooks:doConfigPageInits in /var/www/html/admin/config.php:418
      
      

      Music on Hold:

      
      SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `asterisk`.`music`.`random` at row 1
      File:/var/www/html/admin/modules/music/Music.class.php:125
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Astashov_Alexey Astashov_Alexey
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Feedback Requested:

                  NextupJiraPlusStatus

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