Music on hold - SQL - invalid datetime format when random 0

Getting this error when trying to save “random play” as “off” under a new MOH category:

SQLSTATE[22007]: 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 / Asterisk 16.7.0
Everything updated.
All modules report up-to-date (stable).
All system files up to date (apt).

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.