Ticket reminder 24 hours - Numeric value out of range

[DannyXYZ]

Hello,

if you try to set the ticket reminder to 24 hours you get this error:

general.ERROR: PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'reminder_ticket_interval' at row 

1 in /vendors/minphp/db/src/PdoConnection.php:196
0 /vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute()
1 /vendors/minphp/record/src/Record.php(328): Minphp\Db\PdoConnection->query() #2 /plugins/support_manager/models/support_manager_departments.php(135): Minphp\Record\Record->update()
3 /plugins/support_manager/controllers/admin_departments.php(229): SupportManagerDepartments->edit()
4 /vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminDepartments->edit()
5 /index.php(21): Dispatcher::dispatch()
6 {main}

 

[Jono]

Thanks for the report.  I created CORE-4336 to deal with this.  It appears the column had the wrong data type assigned.

[DannyXYZ]

Hello,

yes i can confirm that it works if it is changed to INT(10).

Kind regards
Danny