Getting this error when trying to save “random play” as “off” under a new MOH category:
SQLSTATE: Invalid datetime format: 1366 Incorrect integer value: '' for column `asterisk`.`music`.`random` at row 1
It would appear it is trying to save an empty value instead of a int 0? And saving datetime as a nonquoted string? Usual suspects anyway…
“File” types will save fine if you pick “Enable Random Play” - sql saves a ‘1’. No errors.
“Custom Application” types are not able to be saved at all due to there not being a Random selector/button. (Always is saved with ‘0’ / off - or should be.) So, there is always an error when saving and it never does.
This is a fresh install of v15 image on a RPI4 - very little configured yet.
FreePBX 126.96.36.199 / Asterisk 16.7.0
All modules report up-to-date (stable).
All system files up to date (apt).