-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 14.0.13.4
-
Fix Version/s: None
-
Component/s: Calendar, Time Conditions
-
Labels:None
-
Bug Tracker:Customer Issue
-
ToDo:
-
Asterisk Version:16.2.1
-
Distro:Self Install Debian
PDOException thrown with message "SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `asterisk`.`timeconditions`.`time` at row 1"
Stacktrace:
#5 PDOException in /var/www/html/admin/modules/timeconditions/Timeconditions.class.php:510
#4 PDOStatement:execute in /var/www/html/admin/modules/timeconditions/Timeconditions.class.php:510
#3 FreePBX\modules\Timeconditions:addTimeCondition in /var/www/html/admin/modules/timeconditions/Timeconditions.class.php:38
#2 FreePBX\modules\Timeconditions: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
When i create a new time condition in calendar mode (choosing a calendar or a calendar group) an error occures (see above). The reason is, that the $post['Time'] variable is empty, because it is unused. As a workaround i changed the lines in function addTimeCondition and editTimeCondition to:
// ':time' => $post['time'],
':time' => ($post['time'] == '') ? time() : $post['time'],
greetings
Ralph
