SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'application' at row 1 File:/var/www/html/admin/modules/music/Music.class.php:120

Hi I’m currently running FreePBX 17 on Google Cloud using Debian 12 and when I try to create a Music On Hold Stream and click submit I get this error

Is the stream longer than 255 characters?

MariaDB [asterisk]> describe music;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| category    | varchar(190) | YES  | UNI | NULL    |                |
| type        | varchar(100) | YES  |     | NULL    |                |
| random      | tinyint(1)   | YES  |     | 0       |                |
| application | varchar(255) | YES  |     | NULL    |                |
| format      | varchar(10)  | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+

The stream is longer than 255 characters, I used a different stream link and now it’s working, thank you for your assistance!

from a root shell

mysql asterisk -e "ALTER TABLE music MODIFY COLUMN application VARCHAR(512)"
2 Likes