Subsonic 6.1.6 (build 0cfa60) – November 10, 2019
Running with MySQL as a db.
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Data truncation: Data too long for column 'genre' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'genre' at row 1
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'genre' at row 1
I looked through the MySQL table, and see it well populated. I am not sure where the fail was, or what file was being processed. I did a walk of the media being scanned and checked genre tags and found nothing untold. Seems 'genre' is 64 chars, and nothing in the entire library meets that.
Thanks in advance.