BUG Incredible PBX 13 13 - Errors on IVR creation

[Jerome Jourdain]

Hi,

I have weird errors while trying to create an IVR on a fresh install of Incredible PBX 13 on Ubuntu 18.04 and everything is up-to-date.

hopefully someone will catch this issue

here what I think is the issue : General error: 1366 Incorrect integer value: 'None' for column 'announcement' at row 1::

just like if the system is awaiting for an interger value but the choices are not integers

seems like whatever I choose for the "annoncement" I have this error !


here is some errors (highlithed line with errors) :

/var/www/html/admin/libraries/utility.functions.php

1. if(is_object($extended_text) && method_exists($extended_text,"getMessage")) {
2. $e = $extended_text;
3. $extended_text = htmlentities($e->getMessage());
4. $code = $e->getCode();
5. throw new \Exception($text . "::" . $extended_text,$code,$e);
6. } else {
7. $extended_text = htmlentities($extended_text);
8. throw new \Exception($text . "::" . $extended_text);
9. }
10. }

/var/www/html/admin/modules/ivr/functions.inc.php

1. $start .= "$k, ";
2. $end .= ":$k, ";
3. }
4. $sql = substr($start, 0, -2).substr($end, 0, -2).")";
5. $foo = $db->query($sql, $vals);
6. if($db->IsError($foo)) {
7. die_freepbx(print_r($vals,true).' '.$foo->getDebugInfo());
8. }
9. // Was this a new one?

/var/www/html/admin/modules/ivr/functions.inc.php

1. $id = FreePBX::Recordings()->addRecording("ivr-".$vars['name']."-recording-".time(),sprintf(_("Recording created for IVR named '%s'"),$vars['name']),"custom/".$filename);
2. $vars['announcement'] = $id;
3. } else {
4. $vars['announcement'] = '';
5. }
6. }
7. //get real dest
8. $vars['id'] = ivr_save_details($vars);
9. ivr_save_entries($vars['id'], $entries);
10. needreload();

/var/www/html/admin/libraries/components.class.php

1. if ( !$this->sorted_processfuncs ) {
2. $this->sortprocessfuncs();
3. }
4. if ( is_array($this->processfuncs) ) {
5. foreach ( array_keys($this->processfuncs) as $sortorder ) {
6. foreach ( $this->processfuncs[$sortorder] as $func ) {
7. $func($this->compname);
8. }
9. }

/var/www/html/admin/config.php

1. // BMO: Process ConfigPageInit functions
2. $bmo->Performance->Start("inits-$display");
3. $bmo->GuiHooks->doConfigPageInits($display, $currentcomponent);
4. $bmo->Performance->Stop("inits-$display");
5. // now run each 'process' function and 'gui' function
6. $bmo->Performance->Start("processconfigpage-$display");
7. $currentcomponent->processconfigpage();
8. $bmo->Performance->Stop("processconfigpage-$display");
9. $bmo->Performance->Start("buildconfigpage-$display");

 

[Jerome Jourdain]

Here already an update.....Finally the only option I can't choose is "none" all the other preloaded announcements seems to work

 

[Vopis]

You need to change the columns type for 2 columns:
announcement -> varchar(50)
strict_dial_timeout -> varchar(255), NULL: YES, Default: 0

 

[PBX Novice]

k I'm on the same system and getting the same errors- any idea what I can do to fix this?