-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Third Party Issue
-
Affects Version/s: 14.0.
-
Fix Version/s: 14
-
Component/s: Announcements, IVR, Music On Hold
-
Labels:None
-
Sprint:Sprint 16!
-
ToDo:
-
Module Fix Version:
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